Bugfixes
-
Throw an error if
ctid
or other system columns are used in theWHERE
clause. Since these columns have no meaning in Oracle, they are assigned meaningless values, and using them inWHERE
conditions would lead to meaningless results.
Reported on Stackoverflow. -
Fix the server option
nchar
introduced in 2.4.0.
Due to an omission, that option never worked, andNCHAR
andNVARCHAR2
columns were converted wrongly even ifnchar
wason
.
Report and analysis by @chmyaf in #706. -
Fix
IMPORT FOREIGN SCHEMA
so that it imports tables whose name is the same as the name of an index.
Report by Leho Lehes. -
Don't push down
LIMIT
.
This is a regression from older releases, but the current implementation was incorrect, as reported by @gytune74 in #721. -
Fix a crash with column options on non-existing columns.
If the Oracle table has fewer columns than the PostgreSQL foreign table and one of these extra columns has a column option set, oracle_fdw would crash.
Reported by @ganshinm, analysis by @ziva777 in #744. -
Increase the size of the Oracle execution plan lines.
With the previous limit of 1000,EXPLAIN (VERBOSE)
for some Oracle metadata queries resulted inORA-01406: fetched column value was truncated
Report by @ganshinm in #745 and @saygoodbye in #747.