Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Outer Join Bug in Oracle 12c?

user6748224Apr 16 2014 — edited Apr 21 2014

In previous versions of Oracle (and on SQL Server and DB2), the query below returns 1 record.  In Oracle 12c, no records are returned.  Is this a known issue in Oracle 12c? CREATE TABLE FOO (id NUMBER, inherit NUMBER(1), parentId NUMBER); INSERT INTO FOO VALUES (1, 0, null); COMMIT; SELECT FOO.id, PARENT.id, GRANDPARENT.id FROM FOO LEFT JOIN FOO PARENT ON FOO.parentId = PARENT.id AND FOO.inherit = 1 LEFT JOIN FOO GRANDPARENT ON PARENT.parentId = GRANDPARENT.id AND PARENT.inherit = 1

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 19 2014
Added on Apr 16 2014
14 comments
26,105 views