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 -- 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 jooq-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/dfea15bd-9d5a-40cb-9df0-7aaf11d3b086n%40googlegroups.com.