Version 3.16.20 - June 23, 2023
================================================================================
This is a 3.16 patch release with minor improvements and bug fixes
Features and Improvements
-------------------------
#15078 - maven-install and maven-deploy shell scripts should use -e flag to report more error info
#15141 - Improve Javadoc on DSLContext.executeInsert(), executeUpdate(), and executeDelete() about optimistic locking not applying
#15234 - Add support for MySQL DECIMAL/FLOAT/DOUBLE/REAL UNSIGNED types in Meta and code generation
#15242 - MetaImpl::ddl() should produce plain SQL CREATE VIEW statements if it can't parse the view contents
Deprecations
----------------
#15200 - Deprecate inconsistent DSL.jsonObject(Field...) and DSL.jsonbObject(Field...) overloads
Bug Fixes
---------
#15064 - DDLDatabase defaultNameCase=lower doesn't work with ENUM types
#15068 - Unable to rename table with qualified target table name
#15081 - Add error message to maven-install.sh which doesn't work with Maven 3.9.0 due to MNG-7679
#15084 - Parser meta lookup fails when using qualified asterisk on a table alias
#15091 - Misleading error message when ON KEY finds ambiguous keys
#15100 - Inconsistent implementation of TableImpl::equals and TableImpl::hashCode when comparing generated tables with plain SQL ones
#15113 - Ambiguous type name warning for non-ambiguous type name in OracleDatabase
#15124 - Wrong warning logged regarding CockroachDB version support
#15130 - DefaultConfiguration::toString logs wrong flags in R2DBC context
#15138 - Improve error message when unversioned, row based optimistic locking doesn't work with DAOs and POJOs
#15152 - PostgresDatabase and subtypes may produce wrong table comments in presence of stored functions
#15194 - PostgreSQL: array(<domain over UUID>) causes exception
#15205 - Add missing Experimental annotation to migrations API types
#15217 - H2 dialect should cast binary data of unknown length as VARBINARY, not as BINARY
#15221 - NullPointerException in AbstractMeta::lookupTable and other methods, when there is no DefaultCatalog
#15245 - Ambiguous match found when using aliases with implicit join and joining the same table twice
#15256 - ScalaGenerator produces wrong code when generator strategy adds multiple interfaces to legacy enum type
#15264 - Add Javadoc to plain SQL DSL.field() constructors recommending to use code generation or at least pass a DataType
#15269 - LoggerListener logs some batch queries twice, when using BatchMultiple
#15274 - Wrong implementation of SelectQueryImpl::wrapQueryExpressionBodyInDerivedTable in jOOQ Open Source Edition
Version 3.17.14 - June 23, 2023
================================================================================
This is a 3.17 patch release with minor improvements and bug fixes
Features and Improvements
-------------------------
#15077 - maven-install and maven-deploy shell scripts should use -e flag to report more error info
#15119 - Add a jooq.codegen.propertyOverride system property to GenerationTool
#15132 - Add DSLContext.transactionCoroutine overload accepting CoroutineContext
#15140 - Improve Javadoc on DSLContext.executeInsert(), executeUpdate(), and executeDelete() about optimistic locking not applying
#15233 - Add support for MySQL DECIMAL/FLOAT/DOUBLE/REAL UNSIGNED types in Meta and code generation
Deprecations
----------------
#15199 - Deprecate inconsistent DSL.jsonObject(Field...) and DSL.jsonbObject(Field...) overloads
Bug Fixes
---------
#15063 - DDLDatabase defaultNameCase=lower doesn't work with ENUM types
#15067 - Unable to rename table with qualified target table name
#15080 - Add error message to maven-install.sh which doesn't work with Maven 3.9.0 due to MNG-7679
#15083 - Parser meta lookup fails when using qualified asterisk on a table alias
#15090 - Misleading error message when ON KEY finds ambiguous keys
#15110 - Compilation error in Oracle generated code for package type in PL/SQL RECORD constructor
#15112 - Ambiguous type name warning for non-ambiguous type name in OracleDatabase
#15123 - Wrong warning logged regarding CockroachDB version support
#15129 - DefaultConfiguration::toString logs wrong flags in R2DBC context
#15134 - Use awaitSingle instead of awaitFirstOrNull in transactionCoroutine to correctly sequence transaction script
#15137 - Improve error message when unversioned, row based optimistic locking doesn't work with DAOs and POJOs
#15151 - PostgresDatabase and subtypes may produce wrong table comments in presence of stored functions
#15170 - NullPointerException in code generator when omitting <target> directory
#15185 - Compilation error in generated DAO code when visibility of a field is changed to private
#15193 - PostgreSQL: array(<domain over UUID>) causes exception
#15204 - Add missing Experimental annotation to migrations API types
#15216 - H2 dialect should cast binary data of unknown length as VARBINARY, not as BINARY
#15220 - NullPointerException in AbstractMeta::lookupTable and other methods, when there is no DefaultCatalog
#15241 - MetaImpl::ddl() should produce plain SQL CREATE VIEW statements if it can't parse the view contents
#15244 - Ambiguous match found when using aliases with implicit join and joining the same table twice
#15255 - ScalaGenerator produces wrong code when generator strategy adds multiple interfaces to legacy enum type
#15263 - Add Javadoc to plain SQL DSL.field() constructors recommending to use code generation or at least pass a DataType
#15268 - LoggerListener logs some batch queries twice, when using BatchMultiple
#15273 - Wrong implementation of SelectQueryImpl::wrapQueryExpressionBodyInDerivedTable in jOOQ Open Source Edition
Version 3.18.5 - June 23, 2023
================================================================================
This is a 3.18 patch release with minor improvements and bug fixes
Features and Improvements
-------------------------
#15076 - maven-install and maven-deploy shell scripts should use -e flag to report more error info
#15079 - Add error message to maven-install.sh which doesn't work with Maven 3.9.0 due to MNG-7679
#15118 - Add a jooq.codegen.propertyOverride system property to GenerationTool
#15131 - Add DSLContext.transactionCoroutine overload accepting CoroutineContext
#15139 - Improve Javadoc on DSLContext.executeInsert(), executeUpdate(), and executeDelete() about optimistic locking not applying
#15232 - Add support for MySQL DECIMAL/FLOAT/DOUBLE/REAL UNSIGNED types in Meta and code generation
#15262 - Add Javadoc to plain SQL DSL.field() constructors recommending to use code generation or at least pass a DataType
Deprecations
----------------
#15198 - Deprecate inconsistent DSL.jsonObject(Field...) and DSL.jsonbObject(Field...) overloads
Bug Fixes
---------
#15062 - DDLDatabase defaultNameCase=lower doesn't work with ENUM types
#15066 - Unable to rename table with qualified target table name
#15082 - Parser meta lookup fails when using qualified asterisk on a table alias
#15087 - KotlinGenerator produces wrong code with kotlinNotNullPojoAttributes when multiple references to an embeddable have different nullability - Merge [#14991
#15089 - Misleading error message when ON KEY finds ambiguous keys
#15098 - Inconsistent implementation of TableImpl::equals and TableImpl::hashCode when comparing generated tables with plain SQL ones
#15109 - Compilation error in Oracle generated code for package type in PL/SQL RECORD constructor
#15111 - Ambiguous type name warning for non-ambiguous type name in OracleDatabase
#15122 - Wrong warning logged regarding CockroachDB version support
#15128 - DefaultConfiguration::toString logs wrong flags in R2DBC context
#15133 - Use awaitSingle instead of awaitFirstOrNull in transactionCoroutine to correctly sequence transaction script
#15136 - Improve error message when unversioned, row based optimistic locking doesn't work with DAOs and POJOs
#15150 - PostgresDatabase and subtypes may produce wrong table comments in presence of stored functions
#15169 - NullPointerException in code generator when omitting <target> directory
#15184 - Compilation error in generated DAO code when visibility of a field is changed to private
#15192 - PostgreSQL: array(<domain over UUID>) causes exception
#15203 - Add missing Experimental annotation to migrations API types
#15215 - H2 dialect should cast binary data of unknown length as VARBINARY, not as BINARY
#15219 - NullPointerException in AbstractMeta::lookupTable and other methods, when there is no DefaultCatalog
#15240 - MetaImpl::ddl() should produce plain SQL CREATE VIEW statements if it can't parse the view contents
#15243 - Ambiguous match found when using aliases with implicit join and joining the same table twice
#15254 - ScalaGenerator produces wrong code when generator strategy adds multiple interfaces to legacy enum type
#15267 - LoggerListener logs some batch queries twice, when using BatchMultiple
#15272 - Wrong implementation of SelectQueryImpl::wrapQueryExpressionBodyInDerivedTable in jOOQ Open Source Edition