Groups keyboard shortcuts have been updated
Dismiss
See shortcuts

[ ANNOUNCEMENT ] jOOQ 3.17.35, 3.18.26, and 3.19.19 patch releases with minor improvements and bug fixes

17 views
Skip to first unread message

Lukas Eder

unread,
Feb 19, 2025, 7:23:27 AMFeb 19
to jOOQ User Group

Version 3.17.35 - February 19, 2025

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


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



Features and Improvements

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

#17969 - Add more Javadoc related to reference vs declaration to relevant API, such as Field::as and Table::as



Bug Fixes

---------

#17894 - ORA-22848 thrown if a BLOB or CLOB field is used in IN and NOT IN list predicates

#17897 - ORA-22848 thrown if a BLOB or CLOB field is used row value comparison predicates

#17903 - Incomplete dialect support for SQLDialect.LONGVARCHAR and similar esoteric String / binary types

#17908 - Improve Javadoc and log DEBUG message on RETURNING clauses, stressing that they can't return any rows for tables without identity in some dialects

#17925 - Add new AbstractDelegatingResultQuery internal type to avoid excessive default method bytecode generation at JVM startup time

#17937 - Generated Javadoc should reference qualified output name of generated objects, not input name

#17942 - ALTER TABLE .. DROP DEFAULT doesn't work for SQL Server quoted column identifiers

#17951 - Nesting row 3 times in a SELECT .. ORDER BY .. LIMIT query leads to wrong results with dialects that emulate LIMIT or LIMIT .. WITH TIES with NestedCollectionEmulation.XML

#17957 - QUALIFY emulation shouldn't use HAVING in the absence of aggregate functions

#17963 - DefaultConverterProvider should attempt to load Jackson's JavaTimeModule, if found on the classpath

#17975 - Wrong FOR UPDATE emulation on SQL Server when tables are aliased

#17978 - Invalid SQL generated when using .forUpdate() in combination with implicit joins when using SQL Server

#17984 - Combining nested rows with the WITH TIES syntax leads to runtime exception in CockroachDB, YugabyteDB, PostgreSQL 12 and less

#17989 - Wrong combination of DISTINCT ON and QUALIFY emulations

#17996 - ArrayStoreException when using Converters::forArrayComponents

#17999 - Regression: Field::contains shouldn't auto-cast citext type to varchar on PostgreSQL

#18012 - Temporal table versioning columns are not generated as computed columns

#18019 - Compilation error in generated code when UDT attribute name conflicts with getter procedure

#18026 - Let SchemaImpl and TableImpl avoid traversal and replacement recursion




Version 3.18.26 - February 19, 2025

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


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



Features and Improvements

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

#17968 - Add more Javadoc related to reference vs declaration to relevant API, such as Field::as and Table::as



Bug Fixes

---------

#17893 - ORA-22848 thrown if a BLOB or CLOB field is used in IN and NOT IN list predicates

#17896 - ORA-22848 thrown if a BLOB or CLOB field is used row value comparison predicates

#17902 - Incomplete dialect support for SQLDialect.LONGVARCHAR and similar esoteric String / binary types

#17905 - SQLExceptionLoggerListener logs wrong message on table with IDENTITY column and UNIQUE key

#17907 - Improve Javadoc and log DEBUG message on RETURNING clauses, stressing that they can't return any rows for tables without identity in some dialects

#17924 - Add new AbstractDelegatingResultQuery internal type to avoid excessive default method bytecode generation at JVM startup time

#17936 - Generated Javadoc should reference qualified output name of generated objects, not input name

#17941 - ALTER TABLE .. DROP DEFAULT doesn't work for SQL Server quoted column identifiers

#17950 - Nesting row 3 times in a SELECT .. ORDER BY .. LIMIT query leads to wrong results with dialects that emulate LIMIT or LIMIT .. WITH TIES with NestedCollectionEmulation.XML

#17956 - QUALIFY emulation shouldn't use HAVING in the absence of aggregate functions

#17962 - DefaultConverterProvider should attempt to load Jackson's JavaTimeModule, if found on the classpath

#17974 - Wrong FOR UPDATE emulation on SQL Server when tables are aliased

#17977 - Invalid SQL generated when using .forUpdate() in combination with implicit joins when using SQL Server

#17983 - Combining nested rows with the WITH TIES syntax leads to runtime exception in CockroachDB, YugabyteDB, PostgreSQL 12 and less

#17988 - Wrong combination of DISTINCT ON and QUALIFY emulations

#17995 - ArrayStoreException when using Converters::forArrayComponents

#17998 - Regression: Field::contains shouldn't auto-cast citext type to varchar on PostgreSQL

#18011 - Temporal table versioning columns are not generated as computed columns

#18018 - Compilation error in generated code when UDT attribute name conflicts with getter procedure

#18025 - Let SchemaImpl and TableImpl avoid traversal and replacement recursion




Version 3.19.19 - February 19, 2025

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


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



Features and Improvements

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

#17919 - Add a debug mode to static type registry warnings

#17967 - Add more Javadoc related to reference vs declaration to relevant API, such as Field::as and Table::as



Bug Fixes

---------

#17892 - ORA-22848 thrown if a BLOB or CLOB field is used in IN and NOT IN list predicates

#17895 - ORA-22848 thrown if a BLOB or CLOB field is used row value comparison predicates

#17901 - Incomplete dialect support for SQLDialect.LONGVARCHAR and similar esoteric String / binary types

#17904 - SQLExceptionLoggerListener logs wrong message on table with IDENTITY column and UNIQUE key

#17906 - Improve Javadoc and log DEBUG message on RETURNING clauses, stressing that they can't return any rows for tables without identity in some dialects

#17918 - Avoid optional org.jetbrains.annotations annotations on code generation base classes due to javac annotation processing flaw

#17923 - Add new AbstractDelegatingResultQuery internal type to avoid excessive default method bytecode generation at JVM startup time

#17935 - Generated Javadoc should reference qualified output name of generated objects, not input name

#17940 - ALTER TABLE .. DROP DEFAULT doesn't work for SQL Server quoted column identifiers

#17949 - Nesting row 3 times in a SELECT .. ORDER BY .. LIMIT query leads to wrong results with dialects that emulate LIMIT or LIMIT .. WITH TIES with NestedCollectionEmulation.XML

#17955 - QUALIFY emulation shouldn't use HAVING in the absence of aggregate functions

#17961 - DefaultConverterProvider should attempt to load Jackson's JavaTimeModule, if found on the classpath

#17973 - Wrong FOR UPDATE emulation on SQL Server when tables are aliased

#17976 - Invalid SQL generated when using .forUpdate() in combination with implicit joins when using SQL Server

#17982 - Combining nested rows with the WITH TIES syntax leads to runtime exception in CockroachDB, YugabyteDB, PostgreSQL 12 and less

#17987 - Wrong combination of DISTINCT ON and QUALIFY emulations

#17994 - ArrayStoreException when using Converters::forArrayComponents

#17997 - Regression: Field::contains shouldn't auto-cast citext type to varchar on PostgreSQL

#18002 - Path based policy produces wrong SQL query when used on INSERT .. ON DUPLICATE KEY UPDATE emulation using MERGE

#18010 - Temporal table versioning columns are not generated as computed columns

#18016 - SQLDialect.ORACLE lists 21 as required version, instead of 23

#18017 - Compilation error in generated code when UDT attribute name conflicts with getter procedure

#18023 - ZIP file download contains a copy of a gradle cache directory in jooq-3.x.y-all-sources.zip

Reply all
Reply to author
Forward
0 new messages