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 -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/759d0a93-510d-4278-866d-e350f3e9785en%40googlegroups.com.
