Different Results On Query With Left Join In Oracle 12g vs 18c, 19c, & 21c
(Doc ID 3002867.1)
Last updated on FEBRUARY 27, 2024
Applies to:
Oracle Database - Standard Edition - Version 18.3.0.0.0 and laterOracle Database - Enterprise Edition - Version 18.3.0.0.0 and later
Oracle Database Cloud Exadata Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.
Symptoms
After moving data from Oracle version 12.2.0.1.0 to version 19.21.0.0.0.
A SQL statement with LEFT JOIN returns wrong data (not the same as in Oracle 12.2.0.1.0).
Changes
Upgrade from 12.2 to any version from 18c, 19c up to 19.21, or 21c.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |