[ ANNOUNCEMENT ] jOOQ 3.17.18, 3.18.9, and 3.19.2 patch releases with minor improvements and bug fixes
Lukas Eder
Version 3.17.18 - January 12, 2024
================================================================================
This is a 3.17 patch release with minor improvements and bug fixes
Features and Improvements
-------------------------
#16025 - Add Javadoc to discourage using any Fields.field(x, Class<T>) method if there's an Fields.field(x, DataType<T>) overload, as well as inline(T), value(T), and val(T)
#16047 - org.jooq.tools.Convert should delegate to org.jooq.impl.Convert, instead of duplicating implementations
Bug Fixes
---------
#16016 - Compilation error in KotlinGenerator generated code when GeneratorStrategy produces identifiers conflicting with property access syntax of AbstractRoutine getters
#16028 - Cannot project TableAsField if table contains embeddables in PostgreSQL
#16034 - SQLPerformanceWarning should log hint about gathering dictionary statistics in OracleDatabase
#16042 - Compilation error in JavaGenerator generated code when <pojosAsJavaRecordClasses> is active and a table references a UDT
#16051 - DATE column in Oracle is null when fetched through multiset
#16062 - MetaSQL lookups are done with SQLDialect.family(), not SQLDialect
#16068 - Add Javadoc to all XJC-generated "withers" and setters of boolean types
Version 3.18.9 - January 12, 2024
================================================================================
This is a 3.18 patch release with minor improvements and bug fixes
Features and Improvements
-------------------------
#16024 - Add Javadoc to discourage using any Fields.field(x, Class<T>) method if there's an Fields.field(x, DataType<T>) overload, as well as inline(T), value(T), and val(T)
#16046 - org.jooq.tools.Convert should delegate to org.jooq.impl.Convert, instead of duplicating implementations
Bug Fixes
---------
#15977 - Wrong statement generated for MySQL when leading unqualified asterisk is used with plain SQL template table
#15984 - Comparison predicates and quantified comparison predicates should hint array type to org.jooq.impl.Array for empty expression array casts
#15986 - Regression in PostgreSQL query using 'x' = ANY (ARRAY [(SELECT ARRAY ['x'])]) style quantified comparison predicate on multi dimensional arrays
#15995 - RenderTable.WHEN_MULTIPLE_TABLES only works with table lists, not with joins
#16015 - Compilation error in KotlinGenerator generated code when GeneratorStrategy produces identifiers conflicting with property access syntax of AbstractRoutine getters
#16027 - Cannot project TableAsField if table contains embeddables in PostgreSQL
#16033 - SQLPerformanceWarning should log hint about gathering dictionary statistics in OracleDatabase
#16041 - Compilation error in JavaGenerator generated code when <pojosAsJavaRecordClasses> is active and a table references a UDT
#16050 - DATE column in Oracle is null when fetched through multiset
#16061 - MetaSQL lookups are done with SQLDialect.family(), not SQLDialect
#16067 - Add Javadoc to all XJC-generated "withers" and setters of boolean types
Version 3.19.2 - January 12, 2024
================================================================================
This is a 3.19 patch release with minor improvements and bug fixes
Features and Improvements
-------------------------
#16023 - Add Javadoc to discourage using any Fields.field(x, Class<T>) method if there's an Fields.field(x, DataType<T>) overload, as well as inline(T), value(T), and val(T)
#16032 - SQLPerformanceWarning should log hint about gathering dictionary statistics in OracleDatabase
#16045 - org.jooq.tools.Convert should delegate to org.jooq.impl.Convert, instead of duplicating implementations
Breaking changes
----------------
#16058 - Remove mandatory dependency from compileJava to jOOQ-codegen-gradle tasks
Bug Fixes
---------
#15976 - Wrong statement generated for MySQL when leading unqualified asterisk is used with plain SQL template table
#15983 - Comparison predicates and quantified comparison predicates should hint array type to org.jooq.impl.Array for empty expression array casts
#15985 - Regression in PostgreSQL query using 'x' = ANY (ARRAY [(SELECT ARRAY ['x'])]) style quantified comparison predicate on multi dimensional arrays
#15994 - RenderTable.WHEN_MULTIPLE_TABLES only works with table lists, not with joins
#16004 - Misleading XSD warnings logged when working with MiniJAXB
#16010 - Code generator fails when generating triggers because TriggerExecution value is null
#16014 - Compilation error in KotlinGenerator generated code when GeneratorStrategy produces identifiers conflicting with property access syntax of AbstractRoutine getters
#16026 - Cannot project TableAsField if table contains embeddables in PostgreSQL
#16030 - Regression: NullPointerException in KotlinGenerator generated code when InlineDerivedTable constructor calls TableImpl.where(null)
#16038 - ScalaGenerator produces duplicate paths for cyclic foreign key relationships
#16040 - Compilation error in JavaGenerator generated code when <pojosAsJavaRecordClasses> is active and a table references a UDT
#16049 - DATE column in Oracle is null when fetched through multiset
#16057 - Cannot look up tasks.named("jooqCodegen") from gradle scripts
#16060 - MetaSQL lookups are done with SQLDialect.family(), not SQLDialect
#16063 - Regression: Table metadata calculation for Oracle does not work after 3.19.0
#16066 - Add Javadoc to all XJC-generated "withers" and setters of boolean types