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 -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/jooq-user/23062c6d-0747-4920-b2d2-19a02b180ff5n%40googlegroups.com.
