laurenz/oracle_fdw ORACLE_FDW_2_0_0

Release 2.0.0

on GitHub

Incompatible changes:

• Remove the deprecated option plan_costs, since it is not very useful and is a maintenance burden.
  After an upgrade, tables with this option set should be updated with:

  ALTER FOREIGN TABLE ... OPTIONS (DROP plan_costs);
  

Enhancements:

• Push down 2-way inner joins in SELECT statements if all conditions can be pushed down.
  Patch by Tatsuro Yamada (@yamatattsu), courtesy of NTT OSS Center.

Bugfixes:

• oracle_fdw crashed on Windows if queries use a NULL parameter or an empty subselect.
  Report by PAscal Lemoy (@legrandlegrand).

• Reading srid.map sometimes caused errors even if everything was alright.
  Report by Paul Dziemiela (@pauldzy), analysis by Christian Ullrich (@chrullrich).

• Don't push down expressions with CLOB column references.
  Because of Oracle's inability to use CLOB in SQL expressions, this could lead to errors like

   ORA-00932: inconsistent datatypes: expected - got CLOB
  

• Fix bug in pg_terminate_backend handling.
  pg_terminate_backend (or SIGTERM) was not handled correctly, since neither was the Oracle query canceled nor did the backend terminate.
  Reported by Dmitry Chirkin (@josser).