[ ANNOUNCEMENT ] 3.16.12 and 3.17.6 patch releases with minor improvements and bug fixes

[Lukas Eder]

Version 3.16.12 - December 8, 2022
================================================================================

This is a 3.16 patch release with minor improvements and bug fixes


Features and Improvements
-------------------------
#14244 - Add support for DB2 ROWNUMBER and DENSERANK window function in parser


Bug Fixes
---------
#14178 - ParserCLI in interactive mode should use Settings defaults for its SQL transformation flags
#14184 - MANIFEST.MF contains unnecessary javax.persistence dependency
#14193 - DefaultDiagnosticsContext should cache resultSetFetchedRows
#14198 - Bad syntax generated when using the Field.collate() clause in CREATE TABLE statements
#14212 - Regression in MS Access CONCAT implementation
#14222 - Update blog links from Javadoc and comments
#14228 - Outdated Javadoc on DSL.array() for how jOOQ renders H2 array constructors
#14238 - DefaultDiagnosticsContext shouldn't call ResultSet::getMetaData on already closed ResultSet
#14241 - Work around SQLite's error: HAVING clause on a non-aggregate query
#14266 - Improve generated unknown data type javadoc when forcedTypes match return type, but there are still unknown parameter types
#14278 - Median emulation ignores FILTER and OVER clauses
#14285 - Kotlin Value Classes in Constructor lead to name based mapping failure
#14288 - Upgrade pgjdbc to 42.4.3 to mitigate CVE-2022-41946
#14291 - ScalaGenerator generated code should avoid "procedure syntax"
#14293 - ForcedType enum with no matching value being converted to last enum value
#14296 - ON CONFLICT DO NOTHING emulation should continue to be applied for PostgreSQL 9.3 and 9.4
#14305 - In MySQL, withReturnAllOnUpdatableRecord(true) causes two SELECT statements
#14315 - Informix DDL statements generate invalid SQL for timestamp columns
#14318 - Informix CURRENT_TIMESTAMP emulation doesn't work as DDL DEFAULT expression
#14323 - Wrong NULL behaviour of BitAndAgg, BitOrAgg, and related aggregate function emulations
#14327 - Informix BOOLEAN literals 't' and 'f' need to be cast to BOOLEAN explicitly
#14330 - Excess query executed against SQLite when emulating INSERT .. RETURNING
#14335 - ArrayIndexOutOfBoundsException when parsing ill formed SQL ending with a comment and a semicolon
#14341 - Exception in Teradata code generation: Unknown column TVName
#14345 - StackOverflowError in parser with Settings.parseWithMetaLookups == IGNORE_ON_FAILURE
#14348 - Error: Invalid Top N Value: N is too big for Teradata OFFSET emulation
#14351 - Teradata TOP expression or DISTINCT TOP don't work
#14355 - Parser meta lookups don't work correctly when using DELETE .. FROM with aliased tables
#14370 - Meta::getTables should list also PARTITIONED TABLE
#14375 - Parser produces wrong projection data type when parsing doubly nested derived table
#14377 - Parser reports wrong Ambiguous field identifier error when derived tables share column names

Version 3.17.6 - December 8, 2022
================================================================================

This is a 3.17 patch release with minor improvements and bug fixes


Features and Improvements
-------------------------
#14243 - Add support for DB2 ROWNUMBER and DENSERANK window function in parser


Bug Fixes
---------
#14177 - ParserCLI in interactive mode should use Settings defaults for its SQL transformation flags
#14183 - MANIFEST.MF contains unnecessary javax.persistence dependency
#14188 - StackOverflowError in transformPatternsArithmeticExpressions when commutative operator has 2 inline arguments
#14192 - DefaultDiagnosticsContext should cache resultSetFetchedRows
#14197 - Bad syntax generated when using the Field.collate() clause in CREATE TABLE statements
#14211 - Regression in MS Access CONCAT implementation
#14219 - Plain SQL INSERT .. RETURNING doesn't work with unqualified field templates in SQL Server
#14221 - Update blog links from Javadoc and comments
#14227 - Outdated Javadoc on DSL.array() for how jOOQ renders H2 array constructors
#14233 - ORA-00904: "v0"."GET_WKT": invalid identifier
#14234 - Cannot query geometry value in a nested ROW
#14235 - Cannot query geometry value in a multiset
#14237 - DefaultDiagnosticsContext shouldn't call ResultSet::getMetaData on already closed ResultSet
#14240 - Work around SQLite's error: HAVING clause on a non-aggregate query
#14259 - ClassCastException in WithImpl::$replace
#14265 - Improve generated unknown data type javadoc when forcedTypes match return type, but there are still unknown parameter types
#14277 - Median emulation ignores FILTER and OVER clauses
#14281 - AbstractToJacksonConverter does not work when userType is array
#14284 - Kotlin Value Classes in Constructor lead to name based mapping failure
#14287 - Upgrade pgjdbc to 42.4.3 to mitigate CVE-2022-41946
#14290 - ScalaGenerator generated code should avoid "procedure syntax"
#14292 - ForcedType enum with no matching value being converted to last enum value
#14295 - ON CONFLICT DO NOTHING emulation should continue to be applied for PostgreSQL 9.3 and 9.4
#14304 - In MySQL, withReturnAllOnUpdatableRecord(true) causes two SELECT statements
#14314 - Informix DDL statements generate invalid SQL for timestamp columns
#14317 - Informix CURRENT_TIMESTAMP emulation doesn't work as DDL DEFAULT expression
#14322 - Wrong NULL behaviour of BitAndAgg, BitOrAgg, and related aggregate function emulations
#14326 - Informix BOOLEAN literals 't' and 'f' need to be cast to BOOLEAN explicitly
#14329 - Excess query executed against SQLite when emulating INSERT .. RETURNING
#14334 - ArrayIndexOutOfBoundsException when parsing ill formed SQL ending with a comment and a semicolon
#14340 - Exception in Teradata code generation: Unknown column TVName
#14344 - StackOverflowError in parser with Settings.parseWithMetaLookups == IGNORE_ON_FAILURE
#14347 - Error: Invalid Top N Value: N is too big for Teradata OFFSET emulation
#14350 - Teradata TOP expression or DISTINCT TOP don't work
#14354 - Parser meta lookups don't work correctly when using DELETE .. FROM with aliased tables
#14369 - Meta::getTables should list also PARTITIONED TABLE
#14374 - Parser produces wrong projection data type when parsing doubly nested derived table
#14376 - Parser reports wrong Ambiguous field identifier error when derived tables share column names