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 anORDER 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
Report by @VictorRas.error executing query: OCINumberFromText failed to convert parameter OCI-22062: invalid input string [8feee298-7ce5-4761-9487-34cab831fead]
- 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
during the attempt to INSERT empty strings in a foreign table.ORA-01459: invalid length for variable character string
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
andskip_matviews
toIMPORT FOREIGN SCHEMA
.
From a patch by @mkgrgis.