Oracle Lite Database Select Statement Incorrectly Processed (Doc ID 1486797.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Lite - Version 10.3.0.3.0 to 10.3.0.3.0 [Release 10.3]
Information in this document applies to any platform.

Symptoms

After applying Patch 14160895 the following SQL produces the wrong resulsts i.e.

select * from (select * from A where upper(col2) like '%A%') T1, (select * from B) T2 where T1.col1 = T2.col1(+);

Should produce the following (as per RDBMS 10.2)

  COL1 COL2 COL1 COL2
--------- -------------------- --------- --------------------
  1 A1 1 B1
  2 A2 2 B2
  3 A3

In Lite Client we find the following

COL1 | COL2 | COL1 | COL2
-------+-------+-------+--------
1 | A1 | 1 | B1
2 | A2 | NULL | NULL
3 | A3 | NULL | NULL

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms