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