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

2020-06-01 Thread Ying Lu
> psql12.3 + jdbc_fdw(oracle18.x), tried: [got bad query results] > How about giving oracle_fdw a try? I will try oracle_fdw then. Thank you very much for everyone's help!

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

2020-05-28 Thread Ying Lu
Hello, Please find the info for both SQLs (removed yr) For Q1: QUERY PLAN --- Aggregate (cost=5.40..5.41 rows=