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.

Reply via email to