Bugfixes
-
Throw an error if
ctidor other system columns are used in theWHEREclause. Since these columns have no meaning in Oracle, they are assigned meaningless values, and using them inWHEREconditions would lead to meaningless results.
Reported on Stackoverflow. -
Fix the server option
ncharintroduced in 2.4.0.
Due to an omission, that option never worked, andNCHARandNVARCHAR2columns were converted wrongly even ifncharwason.
Report and analysis by @chmyaf in #706. -
Fix
IMPORT FOREIGN SCHEMAso 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 truncatedReport by @ganshinm in #745 and @saygoodbye in #747.