Bug 8432019 - Wrong Results With Full Outer Join, Database Link and Merged Inline View [ID 8432019.8]
Modified 01-SEP-2010 Type PATCH Status PUBLISHED
Bug 8432019 Wrong Results With Full Outer Join, Database Link and Merged Inline View
This note gives a brief overview bug 8432019.
The content was last updated on: 01-SEP-2010
Click here for details of each of the sections below.
Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions >= 9 but BELOW 12.1
Versions confirmed as being affected • 220.127.116.11
Platforms affected Generic (all / most platforms affected)
This issue is fixed in • 12.1 (Future Release)
• 18.104.22.168 (Server Patch Set)
Symptoms: Related To:
• Wrong Results
• Database Link / Distributed
• ANSI Joins
A full outer join query with inline view executing remotely gets wrong result
missing rows when the inline view is merged.
If a full outer join query is executed without native full outer join over a
database link and produces wrong results (missing rows) and the join involves
an inline view which is being merged then you may have encountered this bug.
Use native full outer join or prevent the inline view from merging
by adding a NO_MERGE hint.
Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice.
Bug:8432019 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article