[ ANNOUNCEMENT ] jOOQ 3.17.27, 3.18.18, and 3.19.11 patch releases with minor improvements and bug fixes

39 views
Skip to first unread message

Lukas Eder

unread,
Aug 13, 2024, 7:35:12 AM8/13/24
to jOOQ User Group

Version 3.17.27 - August 13, 2024

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


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



Features and Improvements

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

#16887 - Improve DataTypeException error message when encountering internal UnknownType

#16921 - Clarify in manual and Javadoc that NoXYZ QueryParts are to be used only with the DSL API, not with the QOM API


Bug Fixes

---------

#16848 - Correctly implement numerous Oracle specific ST_Geometry spatial functions

#16856 - MySQL error "BLOB, TEXT, GEOMETRY or JSON column can't have a default value" when running DDL from generated code

#16860 - SQLite's MetaImpl can't distinguish between multiple unnamed UNIQUE constraints

#16863 - Avoid static members in jOOQ-meta Definition classes to avoid stale build caching

#16881 - Wrong cast syntax used for BigQuery ARRAY types

#16895 - Invalid link in Fields javadoc

#16899 - TIMESTAMP(0) doens't work in DDL statements as the datetime precision is simply omitted

#16905 - Wrong replacement output when emulating data change delta tables in CockroachDB

#16915 - Wrong syntax rendered for SQL Server UNION queries with LIMIT in their subqueries

#16931 - Wrong SQL generated in SQL Server when using UNION .. LIMIT without OFFSET

#16937 - SQL Server MULTISET subquery ORDER BY clause doesn't work with UNION

#16941 - Work around SQL Server's peculiar UNION with ORDER BY .. OFFSET .. FETCH implementation in derived tables

#16945 - Bad OFFSET emulation in UNION queries when OFFSET contains an expression

#16949 - Wrong emulation of DISTINCT ON with UNION

#16952 - Wrong combination of emulations: DISTINCT ON with UNION and LIMIT with expressions

#16957 - Empty window definition in WINDOW clause isn't emulated correctly in SQLDialect.ORACLE18C

#16960 - Wrong WITH TIES emulation when combined with QUALIFY if QUALIFY is supported natively

#16971 - Force inline bind values after 2536 in Teradata

#16991 - Correctly name Apache-2.0 everywhere

#17002 - Code generation order provider isn't being applied to TableDefinition.getXYZ() methods

#17008 - Error when trying to delay DataType inference for scalar SQL type converted to user array type

#17012 - SQLite unnamed unique constraints are listed in a non-deterministic order by code generator

#17016 - Exception when doing Meta.ddl() export with tables that have USE or GO or similar field or table aliases

#17029 - Repeated WHERE FALSE clause in CREATE TABLE AS SELECT .. WITH NO DATA emulation, when query is nested

#17033 - JDBCUtils.dialect() detects wrong MySQL dialect for versions > 8.1

#17043 - SQLDialect.JAVA warning message about derived tables not being supported is misleading




Version 3.18.18 - August 13, 2024

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


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



Features and Improvements

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

#16886 - Improve DataTypeException error message when encountering internal UnknownType

#16920 - Clarify in manual and Javadoc that NoXYZ QueryParts are to be used only with the DSL API, not with the QOM API


Bug Fixes

---------

#16847 - Correctly implement numerous Oracle specific ST_Geometry spatial functions

#16857 - MySQL error "BLOB, TEXT, GEOMETRY or JSON column can't have a default value" when running DDL from generated code

#16859 - SQLite's MetaImpl can't distinguish between multiple unnamed UNIQUE constraints

#16862 - Avoid static members in jOOQ-meta Definition classes to avoid stale build caching

#16880 - Wrong cast syntax used for BigQuery ARRAY types

#16894 - Invalid link in Fields javadoc

#16898 - TIMESTAMP(0) doens't work in DDL statements as the datetime precision is simply omitted

#16904 - Wrong replacement output when emulating data change delta tables in CockroachDB

#16914 - Wrong syntax rendered for SQL Server UNION queries with LIMIT in their subqueries

#16930 - Wrong SQL generated in SQL Server when using UNION .. LIMIT without OFFSET

#16936 - SQL Server MULTISET subquery ORDER BY clause doesn't work with UNION

#16940 - Work around SQL Server's peculiar UNION with ORDER BY .. OFFSET .. FETCH implementation in derived tables

#16944 - Bad OFFSET emulation in UNION queries when OFFSET contains an expression

#16948 - Wrong emulation of DISTINCT ON with UNION

#16951 - Wrong combination of emulations: DISTINCT ON with UNION and LIMIT with expressions

#16956 - Empty window definition in WINDOW clause isn't emulated correctly in SQLDialect.ORACLE18C

#16959 - Wrong WITH TIES emulation when combined with QUALIFY if QUALIFY is supported natively

#16967 - org.jooq.impl.Alias not Serializable, due to Lambda wrapInParantheses

#16970 - Force inline bind values after 2536 in Teradata

#16990 - Correctly name Apache-2.0 everywhere

#17001 - Code generation order provider isn't being applied to TableDefinition.getXYZ() methods

#17007 - Error when trying to delay DataType inference for scalar SQL type converted to user array type

#17011 - SQLite unnamed unique constraints are listed in a non-deterministic order by code generator

#17015 - Exception when doing Meta.ddl() export with tables that have USE or GO or similar field or table aliases

#17023 - Row[N].in(Row[N]...), Row[N].between(...), and Row[N].is[Not]DistinctFrom(...) should apply data type bindings if necessary

#17028 - Repeated WHERE FALSE clause in CREATE TABLE AS SELECT .. WITH NO DATA emulation, when query is nested

#17032 - JDBCUtils.dialect() detects wrong MySQL dialect for versions > 8.1

#17042 - SQLDialect.JAVA warning message about derived tables not being supported is misleading




Version 3.19.11 - August 13, 2024

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


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



Features and Improvements

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

#16885 - Improve DataTypeException error message when encountering internal UnknownType

#16919 - Clarify in manual and Javadoc that NoXYZ QueryParts are to be used only with the DSL API, not with the QOM API


Bug Fixes

---------

#16838 - Wrong DuckDB binary literals generated when inlining bind values

#16846 - Correctly implement numerous Oracle specific ST_Geometry spatial functions

#16851 - jOOQ-codegen-gradle 3.19.10 assumes presence of a "main" source set, which isn't always the case

#16855 - MySQL error "BLOB, TEXT, GEOMETRY or JSON column can't have a default value" when running DDL from generated code

#16858 - SQLite's MetaImpl can't distinguish between multiple unnamed UNIQUE constraints

#16864 - Avoid static members in jOOQ-meta Definition classes to avoid stale build caching

#16870 - Cannot generate DuckDB code due to wrong qualification of system.main objects

#16879 - Wrong cast syntax used for BigQuery ARRAY types

#16883 - BigQuery DELETE statements contain unnecessary AND TRUE clause in WHERE clause

#16893 - Invalid link in Fields javadoc

#16897 - TIMESTAMP(0) doens't work in DDL statements as the datetime precision is simply omitted

#16903 - Wrong replacement output when emulating data change delta tables in CockroachDB

#16913 - Wrong syntax rendered for SQL Server UNION queries with LIMIT in their subqueries

#16923 - Invalid SQL generated when UNION subselects contain ORDER BY

#16929 - Wrong SQL generated in SQL Server when using UNION .. LIMIT without OFFSET

#16935 - SQL Server MULTISET subquery ORDER BY clause doesn't work with UNION

#16939 - Work around SQL Server's peculiar UNION with ORDER BY .. OFFSET .. FETCH implementation in derived tables

#16943 - Bad OFFSET emulation in UNION queries when OFFSET contains an expression

#16947 - Wrong emulation of DISTINCT ON with UNION

#16950 - Wrong combination of emulations: DISTINCT ON with UNION and LIMIT with expressions

#16955 - Empty window definition in WINDOW clause isn't emulated correctly in SQLDialect.ORACLE18C

#16958 - Wrong WITH TIES emulation when combined with QUALIFY if QUALIFY is supported natively

#16964 - Remove TERADATA support for CREATE MATERIALIZED VIEW

#16966 - org.jooq.impl.Alias not Serializable, due to Lambda wrapInParantheses

#16969 - Force inline bind values after 2536 in Teradata

#16989 - Correctly name Apache-2.0 everywhere

#17000 - Code generation order provider isn't being applied to TableDefinition.getXYZ() methods

#17006 - Error when trying to delay DataType inference for scalar SQL type converted to user array type

#17010 - SQLite unnamed unique constraints are listed in a non-deterministic order by code generator

#17014 - Exception when doing Meta.ddl() export with tables that have USE or GO or similar field or table aliases

#17022 - Row[N].in(Row[N]...), Row[N].between(...), and Row[N].is[Not]DistinctFrom(...) should apply data type bindings if necessary

#17027 - Repeated WHERE FALSE clause in CREATE TABLE AS SELECT .. WITH NO DATA emulation, when query is nested

#17031 - JDBCUtils.dialect() detects wrong MySQL dialect for versions > 8.1

#17041 - SQLDialect.JAVA warning message about derived tables not being supported is misleading

#17044 - jOOQ-codegen-gradle plugin doesn't work with Gradle's configuration cache feature

Reply all
Reply to author
Forward
0 new messages