Version 3.17.32 - December 10, 2024

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


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



Features and Improvements

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

#17569 - Add DataType.getFromType(): Class<?> and DataType.getToType(): 
Class<T>

#17619 - Add more Javadoc to Binding and Converter, discussing when they 
are invoked


Bug Fixes

---------

#17534 - Regression in code generation for MariaDB where 
unsignedTypes=false is ignored

#17540 - Wrong error message with DataTypeException: "Cannot cast [T] to 
[T]"

#17543 - Error when converting String valued but Object typed column to Enum 
type

#17548 - SQLDialect.JAVA renders currentLocalTime() instead of 
currentLocalDateTime() for CURRENT_DATE

#17552 - Add DataType.isRowId() and use it instead of comparing 
Field.getType() == RowId.class internally

#17556 - MySQLDSL encryption functions should work with argument 
Field.getDataType(), not Field.getType()

#17560 - Field::collate should use getDataType().isString() instead of 
getType() == String.class to enable converters

#17564 - The LIKE and SIMILAR TO predicates should use DataType.isString() 
internally to decide whether to auto-cast arguments, not Field.getType() == 
String.class

#17573 - Avoid calling Typed.getType() in jOOQ internals, to be more 
Converter aware

#17577 - MockResultSetMetaData::getColumnClassName returns user type 
instead of database type if MockResult uses converted data types

#17583 - PostgresUtils.toPGString() should use JSONB.data() not 
JSONB.toString()

#17586 - Avoid calling JSONB::toString in jOOQ internals

#17589 - AbstractRecord::compareTo doesn't produce correct ordering

#17604 - Avoid CAST(? AS BLOB) in Oracle and render TO_BLOB(?) instead

#17607 - ORA-22848 thrown if a BLOB or CLOB field is used in comparison 
predicates

#17613 - BINARY, VARBINARY and LONGVARBINARY should be mapped to BLOB in 
SQLite

#17628 - Wrong ON DELETE support annotated for Informix and MemSQL

#17640 - NullPointerException in interpreter when trying to work with 
schema that doesn't exist

#17645 - Interpreter should show current query when there's an error

#17655 - Accept CONSTRAINT_INDEX_ as a possible system index name prefix in 
H2

#17663 - DatePart Javadoc should clarify that @Support doesn't mean the 
DatePart is supported on all functions

#17669 - Inaccurate Javadoc on ExecuteContext setters

#17675 - Misleading warning about configured schemas in code generator, 
when the database doesn't supply any schemata

#17692 - Excess whitespace rendered in DROP SEQUENCE

#17695 - Diff should ignore irrelevant CAST on literals in certain contexts

#17700 - Diff between interpreted Meta and MetaImpl produces unnecessary 
ALTER INDEX .. RENAME statements

#17707 - Diff reports unnecessary ALTER SEQUENCE .. START WITH 1 statement 
between interpreted sequence and MetaImpl sequence

#17711 - Wrong SQL syntax generated for empty inserts of fetched records 
without any touched values

#17717 - KotlinGenerator doesn't respect visibility modifier configuration 
for companion object and its contents

#17720 - Null-encoding converter doesn't work with PostgreSQL nested records

#17723 - ORA-01790 when inserting CLOBs with mixture of null and non-null 
values into a table with auditing active

#17730 - Regression when using expressions in ORDER BY clauses of MULTISET 
subqueries in PostgreSQL

#17737 - Parser expects unsigned integer for sequence flags

#17740 - Diff reports unnecessary ALTER SEQUENCE .. INCREMENT BY 1 MINVALUE 
.. MAXVALUE .. statements between interpreted sequence and HSQLDB MetaImpl 
sequence

#17751 - INSERT .. RETURNING TableRecords attached to wrong Configuration 
when AbstractDMLQuery::emulateOracleReturning is true




Version 3.18.23 - December 10, 2024

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


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



Features and Improvements

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

#17568 - Add DataType.getFromType(): Class<?> and DataType.getToType(): 
Class<T>

#17618 - Add more Javadoc to Binding and Converter, discussing when they 
are invoked


Bug Fixes

---------

#17533 - Regression in code generation for MariaDB where 
unsignedTypes=false is ignored

#17539 - Wrong error message with DataTypeException: "Cannot cast [T] to 
[T]"

#17542 - Error when converting String valued but Object typed column to Enum 
type

#17547 - SQLDialect.JAVA renders currentLocalTime() instead of 
currentLocalDateTime() for CURRENT_DATE

#17551 - Add DataType.isRowId() and use it instead of comparing 
Field.getType() == RowId.class internally

#17555 - MySQLDSL encryption functions should work with argument 
Field.getDataType(), not Field.getType()

#17559 - Field::collate should use getDataType().isString() instead of 
getType() == String.class to enable converters

#17563 - The LIKE and SIMILAR TO predicates should use DataType.isString() 
internally to decide whether to auto-cast arguments, not Field.getType() == 
String.class

#17572 - Avoid calling Typed.getType() in jOOQ internals, to be more 
Converter aware

#17576 - MockResultSetMetaData::getColumnClassName returns user type 
instead of database type if MockResult uses converted data types

#17582 - PostgresUtils.toPGString() should use JSONB.data() not 
JSONB.toString()

#17585 - Avoid calling JSONB::toString in jOOQ internals

#17588 - AbstractRecord::compareTo doesn't produce correct ordering

#17603 - Avoid CAST(? AS BLOB) in Oracle and render TO_BLOB(?) instead

#17606 - ORA-22848 thrown if a BLOB or CLOB field is used in comparison 
predicates

#17612 - BINARY, VARBINARY and LONGVARBINARY should be mapped to BLOB in 
SQLite

#17627 - Wrong ON DELETE support annotated for Informix and MemSQL

#17639 - NullPointerException in interpreter when trying to work with 
schema that doesn't exist

#17644 - Interpreter should show current query when there's an error

#17654 - Accept CONSTRAINT_INDEX_ as a possible system index name prefix in 
H2

#17662 - DatePart Javadoc should clarify that @Support doesn't mean the 
DatePart is supported on all functions

#17668 - Inaccurate Javadoc on ExecuteContext setters

#17674 - Misleading warning about configured schemas in code generator, 
when the database doesn't supply any schemata

#17691 - Excess whitespace rendered in DROP SEQUENCE

#17694 - Diff should ignore irrelevant CAST on literals in certain contexts

#17699 - Diff between interpreted Meta and MetaImpl produces unnecessary 
ALTER INDEX .. RENAME statements

#17706 - Diff reports unnecessary ALTER SEQUENCE .. START WITH 1 statement 
between interpreted sequence and MetaImpl sequence

#17710 - Wrong SQL syntax generated for empty inserts of fetched records 
without any touched values

#17716 - KotlinGenerator doesn't respect visibility modifier configuration 
for companion object and its contents

#17719 - Null-encoding converter doesn't work with PostgreSQL nested records

#17722 - ORA-01790 when inserting CLOBs with mixture of null and non-null 
values into a table with auditing active

#17729 - Regression when using expressions in ORDER BY clauses of MULTISET 
subqueries in PostgreSQL

#17736 - Parser expects unsigned integer for sequence flags

#17739 - Diff reports unnecessary ALTER SEQUENCE .. INCREMENT BY 1 MINVALUE 
.. MAXVALUE .. statements between interpreted sequence and HSQLDB MetaImpl 
sequence

#17750 - INSERT .. RETURNING TableRecords attached to wrong Configuration 
when AbstractDMLQuery::emulateOracleReturning is true

#17754 - Code generator produces wrong ordering of DataType properties for 
nullable and defaulted array types




Version 3.19.16 - December 10, 2024

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


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



Features and Improvements

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

#17567 - Add DataType.getFromType(): Class<?> and DataType.getToType(): 
Class<T>

#17617 - Add more Javadoc to Binding and Converter, discussing when they 
are invoked



Bug Fixes

---------

#17532 - Regression in code generation for MariaDB where 
unsignedTypes=false is ignored

#17538 - Wrong error message with DataTypeException: "Cannot cast [T] to 
[T]"

#17541 - Error when converting String valued but Object typed column to Enum 
type

#17546 - SQLDialect.JAVA renders currentLocalTime() instead of 
currentLocalDateTime() for CURRENT_DATE

#17550 - Add DataType.isRowId() and use it instead of comparing 
Field.getType() == RowId.class internally

#17554 - MySQLDSL encryption functions should work with argument 
Field.getDataType(), not Field.getType()

#17558 - Field::collate should use getDataType().isString() instead of 
getType() == String.class to enable converters

#17562 - The LIKE and SIMILAR TO predicates should use DataType.isString() 
internally to decide whether to auto-cast arguments, not Field.getType() == 
String.class

#17571 - Avoid calling Typed.getType() in jOOQ internals, to be more 
Converter aware

#17575 - MockResultSetMetaData::getColumnClassName returns user type 
instead of database type if MockResult uses converted data types

#17581 - PostgresUtils.toPGString() should use JSONB.data() not 
JSONB.toString()

#17584 - Avoid calling JSONB::toString in jOOQ internals

#17587 - AbstractRecord::compareTo doesn't produce correct ordering

#17594 - Missing Generated annotations on nested Path classes

#17602 - Avoid CAST(? AS BLOB) in Oracle and render TO_BLOB(?) instead

#17605 - ORA-22848 thrown if a BLOB or CLOB field is used in comparison 
predicates

#17611 - BINARY, VARBINARY and LONGVARBINARY should be mapped to BLOB in 
SQLite

#17626 - Wrong ON DELETE support annotated for Informix and MemSQL

#17638 - NullPointerException in interpreter when trying to work with 
schema that doesn't exist

#17643 - Interpreter should show current query when there's an error

#17653 - Accept CONSTRAINT_INDEX_ as a possible system index name prefix in 
H2

#17661 - DatePart Javadoc should clarify that @Support doesn't mean the 
DatePart is supported on all functions

#17667 - Inaccurate Javadoc on ExecuteContext setters

#17673 - Misleading warning about configured schemas in code generator, 
when the database doesn't supply any schemata

#17678 - Add more context information to "Ambiguous key name" warning in 
code generator

#17682 - Compilation error in generated many-to-many paths when turning off 
<implicitJoinPathsToOne/>

#17690 - Excess whitespace rendered in DROP SEQUENCE

#17693 - Diff should ignore irrelevant CAST on literals in certain contexts

#17698 - Diff between interpreted Meta and MetaImpl produces unnecessary 
ALTER INDEX .. RENAME statements

#17705 - Diff reports unnecessary ALTER SEQUENCE .. START WITH 1 statement 
between interpreted sequence and MetaImpl sequence

#17709 - Wrong SQL syntax generated for empty inserts of fetched records 
without any touched values

#17715 - KotlinGenerator doesn't respect visibility modifier configuration 
for companion object and its contents

#17718 - Null-encoding converter doesn't work with PostgreSQL nested records

#17721 - ORA-01790 when inserting CLOBs with mixture of null and non-null 
values into a table with auditing active

#17726 - Map CLOB type to STRING in DuckDB

#17728 - Regression when using expressions in ORDER BY clauses of MULTISET 
subqueries in PostgreSQL

#17735 - Parser expects unsigned integer for sequence flags

#17738 - Diff reports unnecessary ALTER SEQUENCE .. INCREMENT BY 1 MINVALUE 
.. MAXVALUE .. statements between interpreted sequence and HSQLDB MetaImpl 
sequence

#17746 - <globalObjectNames/> should not generate empty classes

#17748 - Wrong Javadoc in <globalObjectNames/> generated classes

#17749 - INSERT .. RETURNING TableRecords attached to wrong Configuration 
when AbstractDMLQuery::emulateOracleReturning is true

#17753 - Code generator produces wrong ordering of DataType properties for 
nullable and defaulted array types

-- 
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 visit 
https://groups.google.com/d/msgid/jooq-user/9d6a9d02-ecee-4b9d-ad92-50be7775e9b2n%40googlegroups.com.

Reply via email to