[ ANNOUNCEMENT ] jOOQ 3.17.32, 3.18.23, and 3.19.16 patch releases with minor improvements and bug fixes

26 views
Skip to first unread message

Lukas Eder

unread,
Dec 10, 2024, 8:37:50 AM12/10/24
to jOOQ User Group

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

Reply all
Reply to author
Forward
0 new messages