psql12.3 + jdbc_fdw - return wrong query results by using OR

From: emilu(at)encs(dot)concordia(dot)ca
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: psql12.3 + jdbc_fdw - return wrong query results by using OR
Date: 2020-05-28 15:39:56
Message-ID: 20200528113956.767qptz1cg44cw0g@webmail.encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

psql12.3 + jdbc_fdw(oracle18.x), tried:

[1]
select count(*)
from oracle_t1 as a
inner join local_t1 as b
on (a.c1 = b.c1);

return 100 records

[2]
select count(*)
from oracle_t1 as a
inner join local_t1 as b
on (a.c1 = b.c1
OR
a.c2 = b.c1
);

return only 2 records

(no null values in both tables.)

May I know what may cause the error please?

Thanks a lot.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-05-28 16:40:04 Re: psql12.3 + jdbc_fdw - return wrong query results by using OR
Previous Message Karsten Hilbert 2020-05-28 15:10:56 Re: Linux Update Experience