SAP Note 658322 - Composite SAP Note: Incorrect resulting set with Oracle

Composant : Oracle -

Solution : https://service.sap.com/sap/support/notes/658322 (Connexion à SAP Service Marketplace requise)

Mots Clés :
floating point number differ slightly, oracle database query returns, incorrect 'number -> character' conversion 10, prevent incorrect resulting sets, database character set, index skip scan 19, predicate pushing solution 1, sql statement displays, current patch set, incorrect resulting set

Notes associées :

1244076kkp* merge fix for Oracle 10.2.0.4
1144178 Invalid float values
1126517ORA-1445 or incorrect values with 10.2
111919410.2.0.2: Incorrect result set with Bloom filters
1118068 Rounding effects for floating point numbers & Oracle DBs
1109753Table prefetching produces incorrect result sets
110770010.2.0.2: Execution of SQL statements in wrong schema
1088403 Table buffer and NULL values on database
1040300Wrong values with Star Transformation Hint 9.2.0.8 /10.2.0.2
1037600 Oracle 9.2.0.8: Data is not selected using index skip scan
1003198J2EE: Incorrect data with Oracle10g JDBC lower than 10.2.0.4
992261Optimizer merge fix for Oracle 9.2.0.8
985118Wrong Values with parallel execution
977319Incorrect values in Oracle 10.2 (II)
964858Incorrect vals w/ STAR_TRANSFORMATION_ENABLED in Oracle 10.2
896903Optimizer merge fix for Oracle 9.2.0.7
834100Merge fix for Oracle 9.2.0.6
825653Oracle: Common misconceptions
822638 Incorrect values for query with OR
815653 Various bug fixes: ST-SER320 SP06
814514 Incorrect values for a query with a "common sub-expression"
755629 KKO merge fix for Oracle 9.2.0.5
727310Wrong Results with ODS or Non-Star_Transformation Queries
717496 Wrong results with STAR_TRANSFORMATION_ENABLED=TRUE
708762 Oracle9: Error converting NUMBER to CHAR
699521Oracle 9: Incorrect results with EXEC SQL
695080Merge fix for Oracle 9.2.0.4
656704Duplicate data records during AND EQUAL index access
617679 Error due to incomplete column definitions
610668Document flow: Material document from incorrect fiscal year
610526 Incorrect results with ANSI OUTER JOIN
606359FAQ: Oracle National Language Support (NLS)
602843Environment settings for R/3/Oracle on UNIX
595757 Composite note Oracle 9.2.0.2 & incor. data (star transf.)
594136 Compos. SAP note Oracle 8.1.7.4 & wrong data (star transf.)
556232Environment settings for R/3/Oracle on Windows
459314 SE16 and pooled tables
357016Incorrect results with PARALLEL hint
355774Incorrect results from the database server
335877Incorrect res. qty w/ select with OR in WHERE cond.
140237 Incorrect results for SELECT .. ORDER BY DESC