On 5/28/20 8:39 AM, emilu@encs.concordia.ca wrote:
> 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?
I'm guessing you are seeing this:
https://www.postgresql.org/docs/12/sql-expressions.html
4.2.14. Expression Evaluation Rules
". Boolean expressions (AND/OR/NOT combinations) in those clauses can be
reorganized in any manner allowed by the laws of Boolean algebra."
It would help to see the EXPLAIN ANALYZE for the queries above.
>
> Thanks a lot.
>
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com