Solution : https://service.sap.com/sap/support/notes/658322 (Connexion à SAP Service Marketplace requise)
Résumé :
Cette note SAP identifie divers écarts dans les résultats des requêtes de base de données Oracle à travers diverses versions et conditions spécifiques. Les problèmes courants comprennent des jeux de résultats incorrects, tels que des entrées excessives, insuffisantes ou dupliquées dues à différentes raisons telles que les valeurs NULL, l'utilisation de ORDER BY DESC, des jointures inappropriées, et des indications inefficaces parmi d'autres. De nombreux cas spécifiques allant de Oracle 8.0.4 à 10.2.0.4 sont abordés, détaillant des comportements erronés potentiels dans des scénarios tels que les requêtes parallèles, les transformations étoiles, et la gestion des nombres FLOAT. Les solutions impliquent principalement des correctifs, des mises à niveau, et des ajustements de paramètres. Il est recommandé de se référer correctement aux notes SAP correspondantes pour des correctifs spécifiques afin de résoudre ces écarts.
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 :
| 1244076 | kkp* merge fix for Oracle 10.2.0.4 |
| 1144178 | Invalid float values |
| 1126517 | ORA-1445 or incorrect values with 10.2 |
| 1119194 | 10.2.0.2: Incorrect result set with Bloom filters |
| 1118068 | Rounding effects for floating point numbers & Oracle DBs |
| 1109753 | Table prefetching produces incorrect result sets |
| 1107700 | 10.2.0.2: Execution of SQL statements in wrong schema |
| 1088403 | Table buffer and NULL values on database |
| 1040300 | Wrong 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 |
| 1003198 | J2EE: Incorrect data with Oracle10g JDBC lower than 10.2.0.4 |
| 992261 | Optimizer merge fix for Oracle 9.2.0.8 |
| 985118 | Wrong Values with parallel execution |
| 977319 | Incorrect values in Oracle 10.2 (II) |
| 964858 | Incorrect vals w/ STAR_TRANSFORMATION_ENABLED in Oracle 10.2 |
| 896903 | Optimizer merge fix for Oracle 9.2.0.7 |
| 834100 | Merge fix for Oracle 9.2.0.6 |
| 825653 | Oracle: 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 |
| 727310 | Wrong Results with ODS or Non-Star_Transformation Queries |
| 717496 | Wrong results with STAR_TRANSFORMATION_ENABLED=TRUE |
| 708762 | Oracle9: Error converting NUMBER to CHAR |
| 699521 | Oracle 9: Incorrect results with EXEC SQL |
| 695080 | Merge fix for Oracle 9.2.0.4 |
| 656704 | Duplicate data records during AND EQUAL index access |
| 617679 | Error due to incomplete column definitions |
| 610668 | Document flow: Material document from incorrect fiscal year |
| 610526 | Incorrect results with ANSI OUTER JOIN |
| 606359 | FAQ: Oracle National Language Support (NLS) |
| 602843 | Environment 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.) |
| 556232 | Environment settings for R/3/Oracle on Windows |
| 459314 | SE16 and pooled tables |
| 357016 | Incorrect results with PARALLEL hint |
| 355774 | Incorrect results from the database server |
| 335877 | Incorrect res. qty w/ select with OR in WHERE cond. |
| 140237 | Incorrect results for SELECT .. ORDER BY DESC |