[ ANNOUNCEMENT ] jOOQ 3.17.20, 3.18.11, and 3.19.4 patch releases with minor improvements and bug fixes

[Lukas Eder]

Version 3.17.20 - February 20, 2024

================================================================================

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

Bug Fixes

---------

#16131 - Maximum consumed results reached when Hikari close a SQL Server connection, leading to excessive logging

#16183 - %ROWTYPE UDT types generate invalid system columns when underlying table references object types

#16198 - Overall performance improvement in AbstractNamed.hashCode() specialisations by avoiding Name::append

#16206 - Remove internal AbstractContext::toggle utilities

#16212 - AbstractScope::dsl, ::settings, ::dialect, and ::family should avoid unnecessary null-checks on Configuration

#16235 - Wrong Support annotation on CREATE TRIGGER for INFORMIX

#16240 - IndexOutOfBoundsException in DerbyDatabase when <includeExcludeColumns/> excludes a column from an index

#16249 - Avoid allocating DataMap in short lived Scope implementations

#16252 - Cache TableRecord Constructor in TableImpl for use in Tools.recordFactory()

#16261 - Avoid allocating Collections.nCopies in ScopeStack

#16265 - Avoid allocating JoinNode in scope registration of tables if unnecessary

#16269 - Avoid constructing DSL.name() for constant internal names

#16273 - Refactor QualifiedName to improve performance

#16278 - name(null, "") should equal to name("")

#16282 - Result::formatXML should omit type attribute on columns whose type is unknown

#16286 - Meta::ddl generates incorrect queries for SQL Server (max) lengths

#16305 - Can't parse MySQL ALTER TABLE .. DROP .., DROP .. syntax

Version 3.18.11 - February 20, 2024

================================================================================

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

Features and Improvements

-------------------------

#16123 - Add Context.scopeParts(Class<Q>): Iterable<Q> to allow for iterating over the values that are currently in scope

Bug Fixes

---------

#16125 - RenderTable.WHEN_AMBIGUOUS_COLUMNS doesn't cover all ambiguous column name cases

#16127 - RenderTable.WHEN_MULTIPLE_TABLES doesn't work correctly in correlated subqueries

#16130 - Maximum consumed results reached when Hikari close a SQL Server connection, leading to excessive logging

#16182 - %ROWTYPE UDT types generate invalid system columns when underlying table references object types

#16186 - Settings.returnDefaultOnUpdatableRecord and Settings.returnComputedOnUpdatableRecord don't work for replacing embeddables

#16197 - Overall performance improvement in AbstractNamed.hashCode() specialisations by avoiding Name::append

#16205 - Remove internal AbstractContext::toggle utilities

#16211 - AbstractScope::dsl, ::settings, ::dialect, and ::family should avoid unnecessary null-checks on Configuration

#16224 - BatchCRUD implementation should extract bind values with SQL string in one go

#16234 - Wrong Support annotation on CREATE TRIGGER for INFORMIX

#16239 - IndexOutOfBoundsException in DerbyDatabase when <includeExcludeColumns/> excludes a column from an index

#16248 - Avoid allocating DataMap in short lived Scope implementations

#16251 - Cache TableRecord Constructor in TableImpl for use in Tools.recordFactory()

#16260 - Avoid allocating Collections.nCopies in ScopeStack

#16264 - Avoid allocating JoinNode in scope registration of tables if unnecessary

#16268 - Avoid constructing DSL.name() for constant internal names

#16272 - Refactor QualifiedName to improve performance

#16277 - name(null, "") should equal to name("")

#16281 - Result::formatXML should omit type attribute on columns whose type is unknown

#16285 - Meta::ddl generates incorrect queries for SQL Server (max) lengths

#16299 - MULTISET equality is ORDER dependent in dialects without support for correlated derived tables

#16304 - Can't parse MySQL ALTER TABLE .. DROP .., DROP .. syntax

Version 3.19.4 - February 20, 2024

================================================================================

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

Features and Improvements

-------------------------

#16122 - Add Context.scopeParts(Class<Q>): Iterable<Q> to allow for iterating over the values that are currently in scope

Bug Fixes

---------

#16115 - jOOQ-codegen-gradle fails with UnknownDomainObjectException when java plugin isn't applied first

#16116 - Generated implicit join alias collision when child table foreign keys share the same name

#16124 - RenderTable.WHEN_AMBIGUOUS_COLUMNS doesn't cover all ambiguous column name cases

#16126 - RenderTable.WHEN_MULTIPLE_TABLES doesn't work correctly in correlated subqueries

#16129 - Maximum consumed results reached when Hikari close a SQL Server connection, leading to excessive logging

#16134 - jOOQ-codegen-gradle doesn't consider basedir property for its OutputDirectory

#16181 - %ROWTYPE UDT types generate invalid system columns when underlying table references object types

#16185 - Settings.returnDefaultOnUpdatableRecord and Settings.returnComputedOnUpdatableRecord don't work for replacing embeddables

#16196 - Overall performance improvement in AbstractNamed.hashCode() specialisations by avoiding Name::append

#16204 - Remove internal AbstractContext::toggle utilities

#16210 - AbstractScope::dsl, ::settings, ::dialect, and ::family should avoid unnecessary null-checks on Configuration

#16223 - BatchCRUD implementation should extract bind values with SQL string in one go

#16230 - Emulate LIMIT 0 where not supported

#16233 - Wrong Support annotation on CREATE TRIGGER for INFORMIX

#16238 - IndexOutOfBoundsException in DerbyDatabase when <includeExcludeColumns/> excludes a column from an index

#16247 - Avoid allocating DataMap in short lived Scope implementations

#16250 - Cache TableRecord Constructor in TableImpl for use in Tools.recordFactory()

#16256 - JavaGenerator doesn't generate serialVersionUID in Path classes

#16259 - Avoid allocating Collections.nCopies in ScopeStack

#16263 - Avoid allocating JoinNode in scope registration of tables if unnecessary

#16267 - Avoid constructing DSL.name() for constant internal names

#16271 - Refactor QualifiedName to improve performance

#16276 - name(null, "") should equal to name("")

#16280 - Result::formatXML should omit type attribute on columns whose type is unknown

#16284 - Meta::ddl generates incorrect queries for SQL Server (max) lengths

#16294 - Remove unnecessary up-to-date prevention in jOOQ-codegen-gradle plugin

#16295 - Wrong SQL generated for CREATE TABLE in non-default schemas for DuckDB

#16298 - MULTISET equality is ORDER dependent in dialects without support for correlated derived tables

#16303 - Can't parse MySQL ALTER TABLE .. DROP .., DROP .. syntax