github laurenz/oracle_fdw ORACLE_FDW_2_7_0
Release 2.7.0

3 months ago

Note: Building and running oracle_fdw with old minor releases may fail; see the installation requirement documentation for details.

Bugfixes

  • Don't push down LIMIT without an ORDER BY clause.
    This can lead to wrong results in some cases.
    Report by @fbattke.
  • Fix support for query parameters of type uuid.
    This led to errors like
    error executing query: OCINumberFromText failed to convert parameter
    OCI-22062: invalid input string [8feee298-7ce5-4761-9487-34cab831fead]
    
    Report by @VictorRas.
  • Fix a memory leak in statements that return LOBs.
    The memory for LOB locators didn't get released before the end of the transaction, so running many statements in a single transaction could cause out-of-memory errors and server crashes.
    Report by @JosefMachytkaNetApp.
  • Fix building on Windows with PostgreSQL versions older than v15.
    This used to report "unresolved external symbol XactReadOnly".
    Report by @w0pr.
  • Fix crash or empty result when reading larger CLOBs.
    Report by @sabineWalter and @vlisterik.
  • Bind empty string parameters as NULL values.
    Failure to do that led to the error
    ORA-01459: invalid length for variable character string
    
    during the attempt to INSERT empty strings in a foreign table.
    Report by @adrianboangiu and @intgr.

Enhancements

  • Speed up IMPORT FOREIGN SCHEMA ... LIMIT TO (...) by filtering out tables whose name don't match on the Oracle side.
    Per suggestion from @joaostorrer.
  • Add options skip_tables, skip_views and skip_matviews to IMPORT FOREIGN SCHEMA.
    From a patch by @mkgrgis.

Don't miss a new oracle_fdw release

NewReleases is sending notifications on new releases.