forked from laurenz/oracle_fdw
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathCHANGELOG
193 lines (170 loc) · 8.21 KB
/
CHANGELOG
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
Version 1.2.0, released 2015-01-03
Enhancements:
- Add support for a file "srid.map" to translate SRIDs between Oracle
and PostGIS.
- If the Oracle session has been terminated outside of a transaction,
try to reconnect once.
Idea by AVEN.
Bugfixes:
- Prepared statements with parameters can crash.
Because of custom plans, this does not manifest until the query has been
executed several times in PostgreSQL 9.2 and higher.
Per report from Krzysztof Gorczyński and others.
This bug was introduced in 1.1.0.
Version 1.1.0, released 2014-12-03
Enhancements:
- Add efficient support for translating between Oracle SDO_GEOMETRY and
PostGIS geometry. Supported geometry types are POINT, LINE, POLYGON,
MULTIPOINT, MULTILINE and MULTIPOLYGON.
Courtesy of Oslandia, implemented by Vincent Mora.
- Add regression tests for improved quality.
- Bind LOB data instead of LOB locators for INSERT and UPDATE.
This simplifies the code and makes Oracle triggers on LOB columns
behave as expected.
Bugfixes:
- Fix a bug introduced in 1.0.0 that leads to crashes when LOB columns
are modified.
- Fix several crashes when the foreign table has fewer or more columns
than the Oracle table.
- Fix a bug that caused "RETURNING <expression>" to return NULL for
complex expressions.
- Writing date or timestamp columns failed when DateStyle was not ISO.
- Reading or writing negative INTERVAL DAY TO SECOND resulted in bad
values because the string formats in PostgreSQL and Oracle differ.
Version 1.0.0, released 2014-04-08
Enhancements:
- Add function oracle_diag(name) for diagnostic purposes.
ATTENTION: Use "ALTER EXTENSION oracle_fdw UPDATE" when upgrading
from a previous version of oracle_fdw.
- Avoid unnecessary local filtering for pushed down WHERE clauses with
internal parameters.
- Add support for triggers on foreign tables for PostgreSQL 9.4.
Bugfixes:
- Fix logic error that keeps Oracle connections from closing.
- Fix "cache lookup failed for type 0" in queries with string parameters.
Per report from Adolfho Lopes.
Version 0.9.10 (beta), released 2013-12-24
Enhancements:
- Add support for INSERT, DELETE and UPDATE.
This is a major rewrite that might cause some destabilization in
existing functionality.
- Add new column option "key" to indicate primary key columns.
This is needed for UPDATE and DELETE.
- Add new table option "readonly" to forbid data modifying statements.
- Improved transaction handling for data modifying statements.
COMMIT, ROLLBACK and SAVEPOINT will work as expected.
- Add paths for Oracle 12.1 to the Makefile.
Patch by Guillaume Lelarge.
Bugfixes:
- Don't try to push down the division operator.
That would produce incorrect results for numeric data types.
Version 0.9.9 (beta), released 2013-08-07
Enhancements:
- Enable build with PostgreSQL 9.3.
Bugfixes:
- Fix error "ORA-01406: fetched column value was truncated"
caused by timestamps with precision greater than 6.
Per report from David E. Wheeler.
- Fix crash with IN lists that do not entirely consist of constants.
Per report from Wang Dong.
- Fix handling of parameters during pushdown of WHERE conditions.
The previous implementation returned incorrect results for certain
queries like SELECT ... WHERE colname = (SELECT ...)
ATTENTION: Since correct handling of parameters is not possible before
PostgreSQL 9.2, query parameters will not be pushed down in PostgreSQL 9.1.
This is a regression for cases where this happened to work.
- Fix a logical error that can lead to incorrect Oracle WHERE clauses.
- Fix a bug that can lead to the incorrect omission of a scan clause,
leading to wrong results.
Version 0.9.8 (beta), released 2012-10-16
Enhancements:
- Add support for pushdown of IN and NOT IN clauses in WHERE conditions.
As suggested by Wang Dong.
Bugfixes:
- Add check to make sure that character string data are properly encoded.
This is necessary because Oracle does not check this properly.
Per report from David E. Wheeler.
Version 0.9.7 (beta), released 2012-09-07
Bugfixes:
- Avoid failure to describe synonyms under certain conditions.
ATTENTION: This constitutes a compatibility break: table and schema names
now have to be exactly as they are in Oracle's catalogs, i.e. without
double quotes and normally in uppercase.
Per report from Bry Lo.
- Add paths to Makefile so that we can build with Instant Client RPMs.
Noticed by Andrew Theaker.
- Fix a memory corruption bug that can lead to crashes, errors and
wrong results.
- Improve bad performance of "SELECT count(*)" on foreign tables.
This is a simple workaround for the (not yet confirmed)
Oracle bug 14562530.
Version 0.9.6 (beta), released 2012-06-25
Enhancements:
- Support Oracle types LONG and LONG RAW.
Introduce table option "max_long" (default 32767) to set the maximal
length of such columns.
Bugfixes:
- Fix a bug that causes a server crash when the PostgreSQL session is
terminated if the only statements involving oracle_fdw during that
session were CREATE statements.
Per report from Bry Lo.
Version 0.9.5 (beta), released 2012-05-11
Enhancements:
- Support ANALYZE on foreign tables (from PostgreSQL 9.2 on).
Bugfixes:
- Fix a bug that leads to warnings and sometimes bad results if system
columns of the foreign table are referenced.
- Fix wrong column width estimates of plan_costs=on.
Version 0.9.4 (beta), released 2012-03-19
Enhancements:
- Support the new foreign data wrapper API introduced in 9.2.
In PostgreSQL 9.2 and above, WHERE conditions that get pushed down to
Oracle will not be checked a second time.
- Improve error messages for errors during conversion of Oracle data
so that the problem can be diagnosed.
Bugfixes:
- Fix uninitialized value that caused intermittent server crashes.
Per report from Bruno Voigt.
- Rework the handling of errors and transactions. Now an error should not
be able to cause an Oracle transaction to be left open. This also fixes
a bug introduced in 0.9.3 that prevented Oracle errors from being
reported as DETAIL message. Also, all foreign scans in one local query
will now be executed within one Oracle transaction if they belong to
the same Oracle session.
- Rework memory management to exclude memory leaks under all circumstances.
Version 0.9.3 (beta), released 2012-02-07
Enhancements:
- Add support for PostgreSQL data type "uuid".
Bugfixes:
- After an error message, calls to the foreign server result in this error:
error connecting to Oracle: OCITransStart failed to start a transaction
ORA-01453: SET TRANSACTION must be first statement of transaction
The problem is that the previous transaction was not closed.
This used to go unnoticed, the problem now becomes manifest because we
explicitly start a serializable transaction.
Per reports from Keith Fiske and Bruno Voigt.
Version 0.9.2 (beta), released 2011-12-30
Bugfixes:
- Fix handling of Oracle BFILE columns. This was totally broken; attempts
to select such columns resulted in the error message
'ORA-00932: inconsistent datatypes: expected %s got %s'.
Bug report and patch by Dominique Legendre.
- Use a serializable transaction in Oracle to make sure that consistent
data are retrieved during a rescan.
Version 0.9.1 (beta), released 2011-09-14
Bugfixes:
- Fix incorrect use of an automatic variable for binding timestamp parameters
in Oracle.
- Remove unnecessary lvalue casts.
These violate the C standard and cause errors on gcc 4.
Per report from Dominique Legendre.
- Fix lack of support for dropped columns in foreign table.
oracle_fdw incorrectly assumed that the n-th PostgreSQL column corresponds
to the n-th Oracle column. This leads to confusion in the presence of
dropped columns, which retain an entry in pg_attribute.
Per report from Dominique Legendre.
- Fix typo that caused wrong and negative sizes being assumed for longer
Oracle columns. This led to palloc() errors and Oracle fetch errors.
Per report from Dominique Legendre.
Version 0.9 (beta), released 2011-08-25
- initial release