[ ANNOUNCEMENT ] 3.15.9 and 3.16.5 patch releases with minor improvements and bug fixes

21 views
Skip to first unread message

Lukas Eder

unread,
Mar 9, 2022, 7:29:57 AMMar 9
to jOOQ User Group
Version 3.15.9 - March 9, 2022
================================================================================

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


Features and Improvements
-------------------------        
#13099 - Add Converters.forArrayComponents(Converter<T[], U[]>): Converter<T, U>
#13186 - Add Javadoc warnings to UpdatableRecord::fetchChildren, and TableRecord::fetchParent about the N+1 problem

Bug Fixes
---------
#13026 - Record.formatJSON(Writer) and Record.formatXML(Writer) should flush the writer
#13056 - java.lang.IllegalArgumentException: Cannot create a VALUES() constructor with an empty set of rows when using JSON_ARRAY(ABSENT ON NULL) in PostgreSQL
#13062 - Typo in Records.intoArray(Class) Javadoc
#13084 - Cannot use H2 enum values in JSON documents
#13087 - Field.sortAsc() should not hard wire NULLS FIRST behaviour
#13091 - MySQL's BIT(1) type doesn't map correctly in MULTISET subqueries
#13092 - SQLDataType.XYZ.getArrayDataType().getTypeName() and getCastTypeName() should produce standard SQL XYZ ARRAY type
#13101 - Order of calling DataType.asConvertedDataType(Converter) and DataType.getArrayDataType() should not matter
#13122 - Cannot use RETURNING with 2-level nested ROW expressions in SQL Server
#13141 - Bad JSONFormat rendering of nested records
#13146 - ClobBinding shouldn't call Clob.length() in Firebird
#13159 - Work around Oracle / ojdbc bug where JSON_ARRAY() can't combine bind parameter marker with FORMAT JSON
#13165 - Compilation error when PostgreSQL stored function has an ANY[] data type reference
#13178 - Incorrect parsing of (NULL) row literal in PostgreSQL for nested records, UDTs, etc.
#13180 - ERROR: could not determine data type of parameter when projecting PostgreSQL UDT bind value
#13198 - Db2 RowAsField emulation using JSON_OBJECT is lacking RETURNING BLOB when using the JSONB emulation
#13207 - Boolean values aren't serialised correctly in SQL Server JSON documents
#13210 - Cast NULL literal to known type in Derby
#13214 - KotlinGenerator cannot read existing catalog/schema version
#13219 - Work around xerial SQLite driver's Clob behaviour when data is null
#13222 - Register array types of built-in types in internal static type registry
#13232 - UNNEST with array argument doesn't work in Oracle when used with derived column list
#13235 - UNNEST table expression does not maintain derived column list
#13239 - ORA-03001: unimplemented feature when nested row emulation produces double quotes in Oracle identifiers
#13243 - NPE in INSERT .. ON DUPLICATE KEY emulation when defaulted PRIMARY KEY value isn't supplied in Oracle



Version 3.16.5 - March 9, 2022
================================================================================

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


Features and Improvements
-------------------------        
#13032 - Add a rootPath property to the LiquibaseDatabase configuration for the FileSystemResourceAccessor
#13098 - Add Converters.forArrayComponents(Converter<T[], U[]>): Converter<T, U>
#13185 - Add Javadoc warnings to UpdatableRecord::fetchChildren, and TableRecord::fetchParent about the N+1 problem
#13247 - Add code generation flags to turn off the recognition of jOOQ-specific types

Bug Fixes
---------
#13025 - Record.formatJSON(Writer) and Record.formatXML(Writer) should flush the writer
#13030 - SQLDataType.XYZ.getArrayDataType().getTypeName() and getCastTypeName() should produce standard SQL XYZ ARRAY type
#13042 - Code generator cannot handle tables from other schemas than PUBLIC referencing H2 enum domain types
#13044 - Avoid generating H2 NUMBER type alias for NUMERIC types
#13050 - Settings.parseRetainCommentsBetweenQueries doesn't work for the last comment
#13055 - java.lang.IllegalArgumentException: Cannot create a VALUES() constructor with an empty set of rows when using JSON_ARRAY(ABSENT ON NULL) in PostgreSQL
#13061 - Typo in Records.intoArray(Class) Javadoc
#13083 - Cannot use H2 enum values in JSON documents
#13086 - Field.sortAsc() should not hard wire NULLS FIRST behaviour
#13090 - MySQL's BIT(1) type doesn't map correctly in MULTISET subqueries
#13102 - Order of calling DataType.asConvertedDataType(Converter) and DataType.getArrayDataType() should not matter
#13110 - Register array types of built-in types in internal static type registry
#13111 - jOOQ Open Source Edition shouldn't fail when parsing geometry type in DDL
#13121 - Cannot use RETURNING with 2-level nested ROW expressions in SQL Server
#13140 - Bad JSONFormat rendering of nested records
#13145 - ClobBinding shouldn't call Clob.length() in Firebird
#13158 - Work around Oracle / ojdbc bug where JSON_ARRAY() can't combine bind parameter marker with FORMAT JSON
#13164 - Compilation error when PostgreSQL stored function has an ANY[] data type reference
#13177 - Incorrect parsing of (NULL) row literal in PostgreSQL for nested records, UDTs, etc.
#13179 - ERROR: could not determine data type of parameter when projecting PostgreSQL UDT bind value
#13197 - Db2 RowAsField emulation using JSON_OBJECT is lacking RETURNING BLOB when using the JSONB emulation
#13206 - Boolean values aren't serialised correctly in SQL Server JSON documents
#13209 - Cast NULL literal to known type in Derby
#13213 - KotlinGenerator cannot read existing catalog/schema version
#13218 - Work around xerial SQLite driver's Clob behaviour when data is null
#13221 - SQLite's JSON operators don't retain boolean three-valued logic
#13228 - Wrong escaping of string literals in doubly nested EXECUTE IMMEDIATE blocks for DDL emulations
#13231 - UNNEST with array argument doesn't work in Oracle when used with derived column list
#13234 - UNNEST table expression does not maintain derived column list
#13238 - ORA-03001: unimplemented feature when nested row emulation produces double quotes in Oracle identifiers
#13241 - Code generation fails with H2 2.1.210 when using MySQL execution mode
#13242 - NPE in INSERT .. ON DUPLICATE KEY emulation when defaulted PRIMARY KEY value isn't supplied in Oracle

Reply all
Reply to author
Forward
0 new messages