| 2856059* |
OERI[KCBGTCR_1] selecting from COMPRESSED IOT after UPGRADE
from 8.1.7 to 9.2
This bug is alerted in Note 245918.1 |
| 1387345 |
DBMS_SQL.DEFINE_ARRAY returns wrong number of rows if CNT
parameter > 64k |
| 1561713 |
Subquery IN | NOT IN subquery may give wrong results under CBO
|
| 2068210 |
"ROWNUM = constant" predicate can return wrong results with
RBO |
| 2130923 |
Wrong value for 'global cache current block receive time' in
V$SYSSTAT |
| 2193751 |
Materialized views can remain "STALE" after refresh |
| 2257439 |
NULL value in partition returned if partition bound value is
in WHERE predicate |
| 2309282 |
OCCI getRowid/setRowid do not work properly |
| 2422838 |
Fetching a "TIMESTAMP with LOCAL TIMEZONE" column into
SQLT_TIMESTAMP_LTZ gives wrong results |
| 2434397 |
Wrong results with PQ with an OUTER JOIN |
| 2501229 |
Redefines using SQLT_TIMESTAMP_TZ get wrong results / dump
|
| 2539213 |
UNION ALL rewrite fails with ORA-1790 or wrong results |
| 2549186 |
OCI client in UTF16 mode may see corrupt data from UTF8
database |
| 2601507 |
sqlgls() / SQLStmtGetText() can give wrong SQL code |
| 2630914 |
TIMESTAMP may be converted incorrectly for date format
'dd-mon-rrrr' |
| 2651178 |
V$SHARED_POOL_RESERVED can return incorrect data |
| 2692500 |
GROUP BY with ROLLUP / CUBE may return no rollup rows |
| 2695081 |
ON-COMMIT refresh on nested Materialized JOIN view may product
wrong results |
| 2740805 |
V$SESSION.OS_USER set incorrectly if client uses RADIUS |
| 2780020 |
Wrong order results from query with FUNCTIONAL INDEX and ORDER
BY and CONSTANT PREDICATE |
| 2782260 |
Duplicate rows in USER_TYPE_METHODS after ALTER TYPE ADD/DROP
ATTRIBUTE |
| 2786409 |
Wrong results from push predicate with inline view |
| 2807291 |
Wrong results with predicate move around |
| 2816521 |
DBA_UNDO_EXTENTS may return too many rows |
| 2820295 |
Implicit describe of a SELECT looses NUMBER precision for VIEW
containing UNION |
| 2821879 |
wrong results for queries on pipeline functions involving
NULLs |
| 2823021 |
V$PROCESS.PGA_MAX_MEM may contain wrong values |
| 2846865 |
Wrong results possible from query rewrite of exact match
|
| 2850227 |
JDBC treats some illegal UTF-8 data as valid |
| 2860212 |
PLSQL RPC with functional default parameter values may get
NULL default / PLS-801 |
| 2860835 |
Text query on LONG datatype can return wrong results |
| 2894146 |
Wrong results from TEMP TABLE transformation with an OUTER
JOIN |
| 2900863 |
V$UNDOSTAT is not updated after an ORA-30036 occurs |
| 2935718 |
V$ACTIVE_SESSION_HISTORY.CURRENT_XXX columns not populated
|
| 2944007 |
OERI:kcoapl_blkchk / bad block possible during CR rollback of
index block |
| 2954868 |
OERI:kcoapl_blkchk / bad block from CR rollback of IOT or
compressed index |
| 2959490 |
Select from view with ORDER BY always returns the rowid of
last row in the view |
| 2977823 |
Wrong results with PQ and HASH outer joins and GROUP BY |
| 2991842 |
Wrong result using several "or" predicates on an NCHAR column
|
| 2994212 |
A query with correlated subqueries can return wrong results
|
| 2999388 |
SYS_EXTRACT_UTC can return wrong results |
| 3002347 |
ResultSet.getTimestamp() gets corrupt data if Statement
reexecuted |
| 3004610 |
Wrong query / dump possible when Synonym policies used via
another synonym |
| 3005317 |
CTX_DOC.MARKUP does not work for multibyte character sets
|
| 3010314 |
Wrong results possible from NESTED LOOPS over a single
partition table |
| 3017881 |
SYS_CONTEXT function does not reflect the correct BG_JOB_ID
|
| 3039078 |
Column precision lost from CTAS of PACKED DECIMAL over HS
|
| 3039491 |
Some JA16EUCTILDE characters are not handled correctly |
| 3041166 |
Wrong results from SEMI JOIN with NL to remote table |
| 3054485 |
Wrong results possible with aggregates of constants |
| 3060261 |
<Queue_table>.ENQ_TIME and V$ view TIME columns may be
ahead of SYSDATE |
| 3066701 |
Date.isNull() returns true if date set using fromText() method
|
| 3068657 |
Incorrect error possible on FETCH (ORA-1405/ORA-6502 instead
of ORA-1403) |
| 3073088 |
Wrong results possible from Text MINUS or ABOUT |
| 3073109 |
Dump / wrong results from complex view merging with inline
views |
| 3077339 |
OCCI: iterated setNumber() causes ORA-1438 or wrong results /
corrupt data |
| 3077754 |
CURRENT_DATE may show the incorrect date in a PLSQL block
|
| 3084922 |
Wrong results possible from SYS_OP_MAP_NON_NULL with a
semi-join |
| 3085399 |
Wrong results possible from CBO with DISTINCT aggregate and
subquery |
| 3092670 |
Wrong results from VIEW using DISTINCT and CONNECT BY |
| 3098761 |
Wrong results possible on XML HASPATH search using
japanese_vgram_lexer |
| 3098884 |
wrong results from STAR transformation with joinback
elimination |
| 3100760 |
XML_SECTION_GROUP and WITHIN queries can give wrong results
|
| 3107254 |
Data truncation after redefine when fetching a LOB in Pro/OCI
|
| 3111186 |
DBMS_LOGMNR_SESSION SAFE_PURGE_SCN may be wrong |
| 3113998 |
Wrong row count possible (OCI_ATTR_ROW_COUNT) on array INSERT
to partitioned table |
| 3119276 |
ORA-942 using ANSI full join with another users view |
| 3119368 |
PLSQL "REPLACE" function assigned to CHAR does not return NULL
when expected |
| 3121812 |
DROP / EXCHANGE partition do not show up in
USER_TAB_MODIFICATIONS |
| 3123633 |
Wrong results on SELECT from VIEW with UNION ALL with multi
column inlist |
| 3125715 |
SQLLDR log file shows incorrect rows loaded when ERRORS clause
is used |
| 3126312 |
SDO_RELATE may return wrong results for ANYINTERACT |
| 3128343 |
Wrong results possible from BITMAP access execution plans
|
| 3128453 |
Null struct possible from JDBC call to PLSQL if BatchSize is
1000 |
| 3129300 |
(Sub)partition level attributes can be incorrect after a fast
split |
| 3134655 |
Wrong results from semijoin elimination inside a view |
| 3135311 |
Wrong results from SYS_CONTEXT('userenv', 'terminal') |
| 3138341 |
Wrong datatypes returned from PLSQL REF Cursor using CAST
|
| 3148847 |
PLSQL "ASCIISTR" returns NULL for HANKAKU KATAKAN |
