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.