pgjdbc_r2dbc-postgresql

1
R2DBC PostgreSQL Changelog
2
=============================
3

4
1.0.0.RELEASE
5
-----------------------------------------
6
* Associate `PostgresConnectionClosedException` with error code `08006` #538
7
* Bump postgresql from 42.4.0 to 42.4.1 #539
8
* Await `ReadyForQuery` before emitting errors from transactional control methods #541
9
* SRID not preserved in Geometry types (Point) since it is encoded as text using the WKTWriter #542
10
* Release 1.0.0.RELEASE #544
11
* Add GraalVM native reflection hints #549
12
* Allow `StringCodec` registration for `CITEXT` usage #551
13
* Upgrade to Reactor 2022.0.0 #554
14
* Fix `LocalTimeCodec` array OID #555
15
* Fix `NumericDecodeUtils.decodeBinary(byteBuf)` decoding #558
16
* Ensure buffer release on copyIn failure #560
17

18
1.0.0.RC1
19
-----------------------------------------
20
* Support for Postgresql multi-host failover functionality #120
21
* Parameter values are not sent in the correct order #482
22
* Support for postgis geometry parent type #483
23
* Let `Result.getRowsUpdated()` return `Long` #484
24
* Remove deprecated `RowMetadata.getColumnNames()` method #485
25
* Consider lowercase `sslmode` for easier JDBC URL adaption #486
26
* Can't process CITEXT #488
27
* ReactorNettyClient `requestProcessor` can retain data from queries #492
28
* Update Readme as LOB types are already supported #493
29
* Upgrade to postgresql 42.3.3 #494
30
* Fix postgres OID type decoding #495
31
* Release 0.8.12.RELEASE #496
32
* Add `COPY FROM` support #500
33
* Upgrade to Reactor 2022.0.0-M1 #503
34
* Upgrade to Reactor 2022.0.0-M2 #506
35
* Upgrade to R2DBC 1.0 #508
36
* Issue parsing timestamp with timezone having offset of format `+hh:mm:ss` #509
37
* `CachedCodecLookup` wrongly assumes uniqueness of `hashCode()` #511
38
* Extend `PostgresqlSqlLexer` to handle PG14 SQL-standard function body syntax #512
39
* Upgrade to netty 4.1.77.Final to address epoll_wait() not implemented on Linux #514
40
* using an EnumCodec with no enums generates invalid SQL #515
41
* Add configuration for `TimeZone` #520
42
* Align `LocalDate` conversion to configured time zone #521
43

44
0.9.0.RELEASE
45
-----------------------------------------
46
* Polishing #478
47

48
0.9.0.RC1
49
-----------------------------------------
50
* Upgrade to R2DBC 0.9.0.RELEASE #473
51
* Adopt renamed TCK column name #472
52
* NumberFormatException in BuiltinDynamicCodecs when reading oid value #470
53
* Truncated the values tested in time-related unit tests to their micro… #469
54
* Lexing sql statements #468
55
* Move off deprecated Reactor Netty API #464
56
* Let `Statement.add()` always create a new binding set #463
57
* Use sequential processing in `Result.flatMap(…)` #462
58
* Buffers in `SSLSessionHandlerAdapter` not released after decoding #458
59
* Propagate offending SQL into R2DBC exceptions #457
60
* Align `Statement.bind(…)` and `Readable.get(…)` exceptions with specification #456
61
* Upgrade to R2DBC SPI 0.9 RC1 #455
62
* Add support to decode enums and other types as `String` #454
63
* SSL=False Option isn't working #453
64
* Upgrade dependencies #448
65
* Remove usage of `java.security.AccessController` #447
66
* Replace `EmitterProcessor` with `Sinks` API #445
67
* Introduce codec mapping caches (0.8.x branch) #444
68
* Updated rows from batch should not be aggregated #440
69
* Remove restriction on ending semicolon in ExtendedQueryPostgresStatement #439
70
* Avoid cast to X509Certificate array during certificate verification #438
71
* Add support for reading arbitrary enum values as `String` #429
72
* Introduce codec mapping caches #410
73
* Add support to re-prepare cached statements #382
74

75
0.9.0.M2
76
-----------------------------------------
77
* Invalid string formatting in `PostgresTypes.lookupType` #437
78
* Adding Extension from Option #433
79
* Upgrade to R2DBC SPI 0.9.0.M2 #425
80
* Add support for Result segment API #424
81
* Add `Row.getMetadata()` method #423
82
* Adapt to changed `Option.getRequiredValue()` return type #422
83
* PostgresObjectId#isValid uses exception as control mechanism resulting in significant performance penalty #420
84
* Memory Leak of BalancedResolverGroup #412
85
* Multi-byte characters inside HStore columns are not read correctly #407
86
* PG Bouncer tests fail with [08P01] password authentication failed #402
87
* Fetch rows never completes #401
88
* QueryLogger not used by ExtendedFlowDelegate #400
89
* Add BooleanArrayCodec, FloatArrayCodec, DoubleArrayCodec support #399
90
* Overflow Exception when fetchSize is set #395
91
* Can't bind Boolean[] types #394
92
* Introduce connection factory option for statementTimeout #381
93

94
0.9.0.M1
95
-----------------------------------------
96
* Upgrade to R2DBC SPI 0.9.0.M1 #388
97
* Upgrade to Reactor 2020.0.3 #380
98
* Add support for extended transaction definitions #379
99
* Add support for SPI Parameters #378
100
* Unable to insert a new entity in a table containing name "returning" #377
101
* Update license headers to report the inception year instead of start-end range #369
102
* Decoding CopyOutResponse message does not comply with postgres documentation #367
103
* Make JsonIntegrationTests extend AbstractIntegrationTests #364
104
* Upgrade to Testcontainers 1.15.0 #363
105
* Unable to decode array_agg(varchar) type. #361
106
* Remove travis build file as we no longer need travis-ci #359
107
* Map postgres' 40001 error code to PostgresqlRollbackException #355
108
* Add BigDecimal array codec #349
109
* Refactor dead if branch into single return flow #348
110
* Restrict CI and release task to pgjdbc/r2dbc-postgresql repo #347
111
* Add Interval Codec #345
112
* Upgrade dependencies #343
113
* Extended flow queries hang with pgpool 4.1 #341
114
* Replace casts to ByteBuffer after ByteBuffer.flip #340
115
* Introduce connection context to allow correlation of log statements to the actual connection #339
116
* Use RoundRobinInetAddressResolver for DNS resolution #338
117
* RowMetadata.getColumnNames() iteration order doesn't match result set column order #337
118
* Add UUID array codec #336
119
* Occasional delays caused by TCP NoDelay config option defaulting to false #334
120
* Upgrade to R2DBC SPI 0.8.3 #333
121
* Use detached byte buffers by default for decoded values #330
122
* JsonCodec.encode(…) doesn't release input buffer #329
123
* Upgrade to Assertj 3.17.2 #328
124
* Upgrade to Netty 4.1.51.Final #327
125
* Upgrade to Reactor Dysprosium SR11 #326
126
* Use GitHub actions to deploy to OSS Sonatype/Maven Central #325
127
* Issue parsing UTC timestamptz from CockroachDB #320
128
* Possibility to configure LoopResources  inside ReactorNettyClient  #319
129
* Accept SSL certificates by providing a URL to use cert from within a jar #313
130
* Add priority to EnumCodec registrar #310
131
* EnumCodec's canDecode method fix (Issue #302) #308
132
* Support for geospatial types - point, line, box, polygon etc #306
133
* NullPointerExceptionwhen adding SSL handler via SSLTunnelHandlerAdapter #304
134
* Add priority to EnumCodec registrar #303
135
* EnumCodec decoding fails if the requested value type is Object #302
136
* Row.decode(…) fails for enum type with IllegalArgumentException: 72093 is not a valid object id #301
137
* Ensure no snapshots get referenced in release builds #299
138
* Add config options for TCP nodelay and keepalive #296
139
* Add support for SSL tunnels #295
140
* Support for "time with time zone" type #294
141
* Query doesn't complete #292
142
* Upgrade to Reactor Dysprosium SR9 #291
143
* Rename master branch to main #290
144
* Upgrade to Reactor Dysprosium SR8 #289
145
* Move repository to pgjdbc organization #287
146
* SSL Mode configuration is not working anymore with v0.8.3.RELEASE #286
147
* Infinite drainLoop call in BackendMessageSubscriber #285
148
* Add support for point type #283
149
* Support for geospatial types - point, line, box, polygon etc #282
150
* Upgrade dependencies #281
151
* Introduce OptionMapper for option mapping #279
152
* add capability to log query parameters (bindings) values #278
153
* Add BlockHound to integration tests #276
154
* static initializers of StartupMessage cause blocking calls #275
155
* Connection in unstable state when rollback after a failed commit #274
156
* adds capability to specify connections options via URL #273
157
* add support for providing "search_path" connection option #271
158
* Fix typo #270
159
* Support hstore as default codec #268
160
* Upgrade build plugin and test dependencies #266
161
* Upgrade to netty 4.1.47.Final #265
162
* Upgrade to Reactor Dysprosium-SR6 #264
163
* Upgrade to testcontainers 1.13.0 #261
164
* Stage releases directly on maven central #259
165
* Default fetch size #256
166
* IllegalStateException when reading empty byte array #253
167
* Allow configuration of ErrorResponse and NoticeResponse logging #249
168
* Canceling requests in progress with CancelRequest #246
169
* Fetch size implementation #245
170
* Add codec for Postgres enumerated types #244
171
* Add fast-path emission of incoming frames #243
172
* High CPU usage when cancelled query #242
173
* Allow configuration of ErrorResponse and NoticeResponse logging #239
174
* Update license header years to 2020 #236
175
* Add a codec for BigInteger #233
176
* Reinstantiate backpressure propagation to NettyInbound #231
177
* Fix for concurrent exchanging on one client #230
178
* Add support for RefCursor #229
179
* Terminate Notification stream on disconnect #227
180
* Capability to disable prepared statement caching #223
181
* Insertion of too many rows do not complete #222
182
* Upgrade to Testcontainers 1.12.4 #218
183
* Enable Travis for pull requests #214
184
* Migrate to Jenkins CI #213
185
* On error not triggered when listen connection terminated #212
186
* Simplify factory provider #210
187
* Fails to startup with forceBinary=true using Spring Boot #208
188
* rowsUpdated() returns more than one item. #207
189
* Readme cleanup #206
190
* Fix typo in project url #205
191
* Enable consumption of REFCURSOR #173
192
* Combine extended flow messages into a single composite message #138
193
* Send cancelation packet to Postgres server in order to interrupt running query  #121
194

195
0.8.7.RELEASE
196
-----------------------------------------
197
* Upgrade to R2DBC SPI 0.8.4.RELEASE #387
198
* Unable to insert a new entity in a table containing name "returning" #377
199
* Update license headers to report the inception year instead of start-end range #369
200
* Decoding CopyOutResponse message does not comply with postgres documentation #367
201
* Make JsonIntegrationTests extend AbstractIntegrationTests #364
202
* Upgrade to Testcontainers 1.15.0 #363
203
* Unable to decode array_agg(varchar) type. #361
204
* Map postgres' 40001 error code to PostgresqlRollbackException #355
205
* Add BigDecimal array codec #349
206
* Refactor dead if branch into single return flow #348
207
* Add Interval Codec #345
208
* Extended flow queries hang with pgpool 4.1 #341
209
* Accept SSL certificates by providing a URL to use cert from within a jar #313
210

211
0.8.6.RELEASE
212
-----------------------------------------
213
* Upgrade dependencies #343
214
* Replace casts to ByteBuffer after ByteBuffer.flip #340
215
* Introduce connection context to allow correlation of log statements to the actual connection #339
216
* Use RoundRobinInetAddressResolver for DNS resolution #338
217
* RowMetadata.getColumnNames() iteration order doesn't match result set column order #337
218
* Add UUID array codec #336
219
* Occasional delays caused by TCP NoDelay config option defaulting to false #334
220
* Upgrade to R2DBC SPI 0.8.3 #333
221
* Use GitHub actions to deploy to OSS Sonatype/Maven Central #325
222
* add capability to log query parameters (bindings) values #278
223
* Combine extended flow messages into a single composite message #138
224

225
0.8.5.RELEASE
226
-----------------------------------------
227
* Use detached byte buffers by default for decoded values #330
228
* JsonCodec.encode(…) doesn't release input buffer #329
229
* Upgrade to Assertj 3.17.2 #328
230
* Upgrade to Netty 4.1.51.Final #327
231
* Upgrade to Reactor Dysprosium SR11 #326
232
* Issue parsing UTC timestamptz from CockroachDB #320
233
* Possibility to configure LoopResources  inside ReactorNettyClient  #319
234
* Add priority to EnumCodec registrar #310
235
* EnumCodec's canDecode method fix (Issue #302) #308
236
* Support for geospatial types - point, line, box, polygon etc #306
237
* NullPointerExceptionwhen adding SSL handler via SSLTunnelHandlerAdapter #304
238
* Add priority to EnumCodec registrar #303
239
* EnumCodec decoding fails if the requested value type is Object #302
240
* Row.decode(…) fails for enum type with IllegalArgumentException: 72093 is not a valid object id #301
241
* Support for geospatial types - point, line, box, polygon etc #282
242

243
0.8.4.RELEASE
244
-----------------------------------------
245
* Ensure no snapshots get referenced in release builds #299
246
* Add config options for TCP nodelay and keepalive #296
247
* Add support for SSL tunnels #295
248
* Support for "time with time zone" type #294
249
* Query doesn't complete #292
250
* Upgrade to Reactor Dysprosium SR9 #291
251
* Upgrade to Reactor Dysprosium SR8 #289
252
* SSL Mode configuration is not working anymore with v0.8.3.RELEASE #286
253
* Infinite drainLoop call in BackendMessageSubscriber #285
254
* Add support for point type #283
255
* Connection in unstable state when rollback after a failed commit #274
256
* Add codec for Postgres enumerated types #244
257

258
0.8.3.RELEASE
259
-----------------------------------------
260
* Upgrade dependencies #281
261
* Introduce OptionMapper for option mapping #279
262
* Add BlockHound to integration tests #276
263
* Static initializers of StartupMessage cause blocking calls #275
264
* Adds capability to specify connections options via URL #273
265
* Add support for providing "search_path" connection option #271
266
* Support hstore as default codec #268
267
* Capability to disable prepared statement caching #223
268
* Simplify factory provider #210
269

270
0.8.2.RELEASE
271
-----------------------------------------
272
* Upgrade build plugin and test dependencies #266
273
* Upgrade to netty 4.1.47.Final #265
274
* Upgrade to Reactor Dysprosium-SR6 #264
275
* Backport usage of testcontainers 1.13.0 #262
276
* Stage releases directly on maven central #260
277
* Default fetch size #256
278
* IllegalStateException when reading empty byte array #253
279
* Fetch size implementation #245
280
* Add fast-path emission of incoming frames #243
281
* High CPU usage when cancelled query #242
282
* Enable consumption of REFCURSOR #173
283

284
0.8.1.RELEASE
285
-----------------------------------------
286
* Upgrade dependencies #238
287
* Update license header years to 2020 #236
288
* Add a codec for BigInteger #233
289
* ConcurrentHashModification at IndefiniteStatementCache #232
290
* Reinstantiate backpressure propagation to NettyInbound #231
291
* Fix for concurrent exchanging on one client #230
292
* Capability to disable prepared statement caching #223
293
* Insertion of too many rows do not complete #222
294
* Upgrade to Testcontainers 1.12.4 #218
295
* Backport Travis support to 0.8.x #217
296
* Backport Jenkins to 0.8.x #216
297
* On error not triggered when listen connection terminated #212
298
* Fails to startup with forceBinary=true using Spring Boot #208
299
* rowsUpdated() returns more than one item #207
300
* Readme cleanup #206
301
* Fix typo in project url #205
302
* Reduce allocations #138
303

304
0.8.0.RELEASE
305
-----------------------------------------
306
* Upgrade to Reactor Dysprosium SR2 #204
307
* Upgrade to R2DBC SPI 0.8.0.RELEASE #202
308
* Add query logger #201
309
* Drop SLF4J in favor of Reactor's Logger utilities #200
310
* Fix instant handling #196
311
* Add an auth-config for local connections in testing #195
312
* Invalid listen example in README #192
313
* Add customizeSslContext(Consumer<SslContextBuilder>) #191
314
*  Default to scalar values for LOB column retrieval according to spec changes #190
315
* Upgrade to Testcontainers 1.12.3 #189
316
* SSL disabled exceptions not propagated in connect phase #187
317
* Enable BlobCodec and ClobCodec for binary usage #186
318
* Split unit test and integration test execution #185
319
* Cannot decode value of type java.net.InetAddress #184
320
* DB exceptions are not handled correctly by PostgresqlConnection for INSERT ... RETURNING in transaction #182
321
* Support unix domain socket connections #181
322
* Relax requirement for password #178
323
* Statement execution gets stuck when connection gets disconnected #177
324
* Add ConnectionFactory option for binaryTransfer (forceBinary) #160
325
* Add LogicalDecoding #18
326

327
0.8.0.RC2
328
------------------
329
* Revert reactor-netty exclusions #175
330
* Added documentation for options parameter in ConnectionConfiguration #174
331

332
0.8.0.RC1
333
------------------
334
* Upgrade to SCRAM Client 2.1 #171
335
* Add automatic module name #170
336
* Upgrade to Reactor Dysprosium GA #169
337
* Edit documentation #166
338
* Memory leak fixes #165
339
* Remove dependencies to Spring Boot #163
340
* Exclude not-required dependencies #162
341
* Implement JSON and JSONB codecs #161
342
* Allow type conversion across codecs #159
343
* Add JMH benchmarks and apply optimizations #158
344
* Fix memory leaks in BackendMessageEnvelopeDecoder #157
345
* Adapt to Row.get(int)/get(String) in PostgresqlRow #156
346
* Add binary codecs for BYTEA. #155
347
* Remove repositories declaration from published pom #154
348
* Fix of IllegalReferenceCountException on discardReadComponents call #153
349
* BackendMessageEnvelopeDecoder. fails with IllegalReferenceCountException: refCnt: 0 #151
350
* Expose Connection metadata #150
351
* Adapt to Statement.bind and Row.get by name #149
352
* ExtendedQueryPostgresqlStatement emits Result before processing execution errors #148
353
* Adapt to SPI changes for IsolationLevel and AutoCommit #147
354
* Upgrade to Reactor Dysprosium RC1 #146
355
* Rename …Example to …TestKit. #143
356
* Add support for setting runtime parameters for new connections #142
357
* PostgresqlConnection does not rollback if transaction status is FAILED #139
358
* Enable StringArrayCodec for binary usage #135
359
* Implement validate() SPI #133
360
* RuleBasedCollector is blocking #131
361
* Upgrade to Postgres JDBC 42.2.6 #130
362
* Upgrade to testcontainers-java 1.12.0 #129
363
* Upgrade to maven-compiler-plugin 3.8.1 #128
364
* Upgrade to Mockito 3.0.0 #127
365
* PostgresConnectionFactoryProvider.supports(…) is too restrictive #125
366
* Deprecate LEGACY_POSTGRESQL_DRIVER #124
367
* No exception without calling getRowsUpdated/map on PostgresqlResult fix #119
368
* Sql exceptions handling #118
369
* Support "postgres" driver #117
370
* Fix canDecode for arrays #115
371
* Avoid array index out of bounds on missing result size in tag #114
372
* Array codecs missing during `canDecode(..)` implementation #113
373
* Fix for multiple usage of same parameter in extended query #111
374
* Blob encoding fix #110
375
* DateCodec delegation to InstantCodec cannot read columns with date type  #109
376
* Weird codec issue when running concurrent queries #107
377
* Update connection example in README #106
378
* Use R2DBC Exception hierarchy for driver exceptions #98
379
* Add CodecRegistrar extension point to register codecs provided by 3rd-party libraries #95
380
* Row.get seems to mix up columns #86
381
* TLS connectivity #59
382
* Added support for listening to notifications #52
383

384
0.8.0.M8
385
------------------
386
* Remove Enum Codec #103
387
* Implement RowMetadata.getColumnNames() #102
388
* Row.get fails for array-typed values #67
389
* Multi-dimensional arrays #42, #54
390
* handle() instead of flatMap() #97
391
* Treat port as optional #93, #100
392
* Check for data before decoding array elements #89, #90
393
* Infinite result execution #81, #85
394
* Prefer binary transfer #21, #76
395
* Error response possibly lost #16, #75
396
* Improve Authentication Error Message #34, #72
397
* BLOB/CLOB Support #99
398
* ConnectionFactoryProvider.getDriver() #77, #78
399

400
1.0.0.M7
401
------------------
402
* Update changelog for M7 #73
403
* ConnectionFactory Discovery #66
404
* Improved ColumnMetadata #64
405
* SCRAM authentication #63
406
* Reinstated generated value retrieval #60
407
* Documentation improvements #57, #68
408
* ConnectionTimeout Configuration #56
409
* Multi-dimensional array support #53
410
* Nullability enforcement returns accurate exception #51
411
* Support multiline queries #50
412
* BackendMessageDecoder memory leak #49
413
* Support for BPCHAR #47
414
* Array type construction #40
415
* Configure a schema #37
416
* Improve support for multiple authentication mechanisms #19
417
* More Stream removal #12
418

419
1.0.0.M6
420
------------------
421
* Initial array codecs
422
* Quick connection close #33
423
* Handle authentication error when creating. onnections #30
424
* Complete subscribers when channel is unregistered #29
425
* Pipelined requests #28
426
* Additional boolean text options #27
427
* Type OID issues #25
428
* More stream removal #24, #32
429
* Propagage mapping error upstream #17
430

431
1.0.0.M4
432
------------------
433
* Decode VARCHAR properly #9
434
* Decode best-effort Object.class #8
435
* Reduce Stream Usage #5
436
* Initialize PostgresqlServerException with reason and SQL state #4
437
* Upgrade to Reactor Californium #1
438