Version 3.19.15 - November 4, 2024

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

Features and Improvements

#17471 - Add <description/> to all pom.xml files

Bug Fixes

#17467 - IndexOutOfBoundsException when calling PostgreSQL table valued function returning empty result, with <tableValuedFunction/> turned off
#17478 - Bad code generated when activating <springDao/> but not <springAnnotations/>
#17484 - Parser should support SQL Server's NTEXT type and parse it into NCLOB
#17490 - Invalid constraint type "n" in jOOQ-meta query on PostgreSQL 17 when trying to fetch pg_get_constraintdef for a NOT NULL constraint on a domain
#17499 - GenerationTool should be more clear about commercial dependencies, when lookups don't work
#17509 - ORA-00904: invalid identifier when trying to insert into tables with lower case identifier in Oracle
#17519 - NullPointerException when using AutoConverter with a custom ConverterProvider
#17522 - Suppressed NoSuchElementException from ThreadLocalTransactionProvider.rollback prevents rollback when commit fails
#17526 - Oracle RETURNING emulation doesn't use configured ConverterProvider from an AutoConverter

Version 3.18.22 - November 4, 2024

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

Features and Improvements

#17472 - Add <description/> to all pom.xml files

Bug Fixes

#17468 - IndexOutOfBoundsException when calling PostgreSQL table valued function returning empty result, with <tableValuedFunction/> turned off
#17479 - Bad code generated when activating <springDao/> but not <springAnnotations/>
#17485 - Parser should support SQL Server's NTEXT type and parse it into NCLOB
#17491 - Invalid constraint type "n" in jOOQ-meta query on PostgreSQL 17 when trying to fetch pg_get_constraintdef for a NOT NULL constraint on a domain
#17500 - GenerationTool should be more clear about commercial dependencies, when lookups don't work
#17510 - ORA-00904: invalid identifier when trying to insert into tables with lower case identifier in Oracle
#17520 - NullPointerException when using AutoConverter with a custom ConverterProvider
#17523 - Suppressed NoSuchElementException from ThreadLocalTransactionProvider.rollback prevents rollback when commit fails
#17527 - Oracle RETURNING emulation doesn't use configured ConverterProvider from an AutoConverter

Version 3.17.31 - November 4, 2024

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

Features and Improvements

#17473 - Add <description/> to all pom.xml files

Bug Fixes

#17469 - IndexOutOfBoundsException when calling PostgreSQL table valued function returning empty result, with <tableValuedFunction/> turned off
#17480 - Bad code generated when activating <springDao/> but not <springAnnotations/>
#17486 - Parser should support SQL Server's NTEXT type and parse it into NCLOB
#17492 - Invalid constraint type "n" in jOOQ-meta query on PostgreSQL 17 when trying to fetch pg_get_constraintdef for a NOT NULL constraint on a domain
#17501 - GenerationTool should be more clear about commercial dependencies, when lookups don't work
#17511 - ORA-00904: invalid identifier when trying to insert into tables with lower case identifier in Oracle
#17524 - Suppressed NoSuchElementException from ThreadLocalTransactionProvider.rollback prevents rollback when commit fails

Version 3.19.14 - October 21, 2024

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

Bug Fixes

#17391 - Javadoc typos on trigger related methods
#17393 - Generated trigger names aren't escaped
#17394 - Meta.ddl() includes synonyms or aliases as tables for some dialects
#17398 - IN-list padding truncates row IN lists to 1000 elements in Oracle pre 23ai
#17403 - DefaultGeneratorStrategy should guard against path classes receiving the same name as their enclosing class
#17409 - Wrong XML import in InformationSchemaMetaImpl for trigger table schemas
#17415 - NUMERIC bind values passed to SQL Server VALUES constructor may lose scale if not explicit DataType is supplied
#17422 - VALUES types decimal and int cannot be matched when inlining NUMERIC types in CockroachDB
#17430 - DSLContext::fetchCount for selects with nested records causes DataAccessException
#17436 - Cannot call Record.reset(Field), Record.original(Field), Record.changed(Field) with embeddable field arguments
#17442 - ClassCastException during invocation of double-wrapped ConvertedDataType
#17445 - Wrong field indexes in code generated in record getters and setters for non-replacing embeddables when database reports non-consecutive column ordinals
#17448 - CREATE TABLE and other DDL statements don't qualify tables in BigQuery
#17454 - Diff doesn't export COMMENT ON MATERIALIZED VIEW statements correctly
#17456 - Converter<byte[], U> for binary columns doesn't work from within MULTISET expressions

Version 3.18.21 - October 21, 2024

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

Bug Fixes

#17395 - Meta.ddl() includes synonyms or aliases as tables for some dialects
#17399 - IN-list padding truncates row IN lists to 1000 elements in Oracle pre 23ai
#17416 - NUMERIC bind values passed to SQL Server VALUES constructor may lose scale if not explicit DataType is supplied
#17423 - VALUES types decimal and int cannot be matched when inlining NUMERIC types in CockroachDB
#17431 - DSLContext::fetchCount for selects with nested records causes DataAccessException
#17437 - Cannot call Record.reset(Field), Record.original(Field), Record.changed(Field) with embeddable field arguments
#17443 - ClassCastException during invocation of double-wrapped ConvertedDataType
#17446 - Wrong field indexes in code generated in record getters and setters for non-replacing embeddables when database reports non-consecutive column ordinals
#17449 - CREATE TABLE and other DDL statements don't qualify tables in BigQuery
#17457 - Converter<byte[], U> for binary columns doesn't work from within MULTISET expressions

Version 3.17.30 - October 21, 2024

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

Bug Fixes

#17396 - Meta.ddl() includes synonyms or aliases as tables for some dialects
#17400 - IN-list padding truncates row IN lists to 1000 elements in Oracle pre 23ai
#17417 - NUMERIC bind values passed to SQL Server VALUES constructor may lose scale if not explicit DataType is supplied
#17424 - VALUES types decimal and int cannot be matched when inlining NUMERIC types in CockroachDB
#17432 - DSLContext::fetchCount for selects with nested records causes DataAccessException
#17438 - Cannot call Record.reset(Field), Record.original(Field), Record.changed(Field) with embeddable field arguments
#17444 - ClassCastException during invocation of double-wrapped ConvertedDataType
#17447 - Wrong field indexes in code generated in record getters and setters for non-replacing embeddables when database reports non-consecutive column ordinals
#17450 - CREATE TABLE and other DDL statements don't qualify tables in BigQuery
#17458 - Converter<byte[], U> for binary columns doesn't work from within MULTISET expressions

Version 3.19.13 - September 26, 2024

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

Features and Improvements

#17334 - MetaImpl exceptions should indicate table and column if applicable, which caused the exception
#17377 - Add a link to DSL::coerce from DSL::cast and Field::cast

Bug Fixes

#17324 - Upgrade Spring dependency from jOOQ-meta-extensions-hibernate to 5.3.39 due to CVE-2024-38808
#17327 - Upgrade jOOQ-checker's transitive guava dependency to 32.1.3-jre due to CVE-2023-2976
#17330 - R2DBC Connection leak when cancelling pending connection with ConnectionPool
#17338 - ORA-17068: Invalid arguments in call when calling OracleDatabaseMetaData.getIndexInfo() with quoted object names
#17345 - MetaImpl and code generator should ignore MySQL's dummy REMARKS column on DatabaseMetaData::getTables for views
#17350 - Meta::ddl re-ordering logic cannot parse views from MetaImpl in certain dialects
#17356 - Regression when generating DDL from certain generated views
#17360 - DDL::applyAsPlainSQL should trim plain SQL string to check if it starts with CREATE
#17366 - UserImpl::$replace produces a RoleImpl instance
#17371 - Oracle PL/SQL %ROWTYPE references should be declared as such in anonymous blocks when calling procedures

Version 3.18.20 - September 26, 2024

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

Features and Improvements

#17335 - MetaImpl exceptions should indicate table and column if applicable, which caused the exception
#17378 - Add a link to DSL::coerce from DSL::cast and Field::cast

Bug Fixes

#17300 - SQLite's binding of BigDecimal through PreparedStatement.setString() doesn't work for predicates
#17325 - Upgrade Spring dependency from jOOQ-meta-extensions-hibernate to 5.3.39 due to CVE-2024-38808
#17328 - Upgrade jOOQ-checker's transitive guava dependency to 32.1.3-jre due to CVE-2023-2976
#17331 - R2DBC Connection leak when cancelling pending connection with ConnectionPool
#17339 - ORA-17068: Invalid arguments in call when calling OracleDatabaseMetaData.getIndexInfo() with quoted object names
#17346 - MetaImpl and code generator should ignore MySQL's dummy REMARKS column on DatabaseMetaData::getTables for views
#17357 - Regression when generating DDL from certain generated views
#17361 - DDL::applyAsPlainSQL should trim plain SQL string to check if it starts with CREATE
#17367 - UserImpl::$replace produces a RoleImpl instance
#17372 - Oracle PL/SQL %ROWTYPE references should be declared as such in anonymous blocks when calling procedures

Version 3.17.29 - September 26, 2024

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

Features and Improvements

#17336 - MetaImpl exceptions should indicate table and column if applicable, which caused the exception
#17379 - Add a link to DSL::coerce from DSL::cast and Field::cast

Bug Fixes

#17301 - SQLite's binding of BigDecimal through PreparedStatement.setString() doesn't work for predicates
#17326 - Upgrade Spring dependency from jOOQ-meta-extensions-hibernate to 5.3.39 due to CVE-2024-38808
#17329 - Upgrade jOOQ-checker's transitive guava dependency to 32.1.3-jre due to CVE-2023-2976
#17332 - R2DBC Connection leak when cancelling pending connection with ConnectionPool
#17340 - ORA-17068: Invalid arguments in call when calling OracleDatabaseMetaData.getIndexInfo() with quoted object names
#17347 - MetaImpl and code generator should ignore MySQL's dummy REMARKS column on DatabaseMetaData::getTables for views
#17358 - Regression when generating DDL from certain generated views
#17362 - DDL::applyAsPlainSQL should trim plain SQL string to check if it starts with CREATE
#17368 - UserImpl::$replace produces a RoleImpl instance
#17373 - Oracle PL/SQL %ROWTYPE references should be declared as such in anonymous blocks when calling procedures

Version 3.19.12 - September 23, 2024

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

Features and Improvements

#17101 - Add DataType.isTimestampWithTimeZone() for INSTANT and OFFSETDATETIME and isTimeWithTimeZone() for OffsetTime
#17209 - Revert deprecation of serialization support
#17248 - Log warnings when Java record constructor has more than 254 parameters
#17275 - Add Converter.fromSupported() and Converter.toSupported() default methods
#17295 - Document the fact that org.jooq.Binding does not necessarily have to implement a complete org.jooq.Converter
#17302 - Add new DataType.isDecimal() method to check if DataType.isNumeric() and it has a decimal representation

Bug Fixes

#17049 - Upgrade pgjdbc dependency to 42.7.3 to mitigate CVE-2024-1597
#17064 - Update DataType.isXYZ() Javadoc with new types
#17071 - TIME(0), LOCALTIME(0), OFFSETDATETIME(0), and INSTANT(0) don't work in DDL statements as the datetime precision is simply omitted
#17076 - Redundant unique index on primary key makes foreign keys disappear in PostgreSQL
#17084 - HANA's WITH ORDINALITY emulation doesn't maintain correct ordering of ORDINALITY
#17091 - Fix R2DBC support for TIMESTAMP WITH TIME ZONE types
#17096 - Fix support for special float values NaN, Infinity in MULTISET usage
#17108 - Implicit path correlation produces correlation predicate in ON clause rather than WHERE clause in some cases
#17109 - Invalid SQL generated for INSERT .. ON DUPLICATE KEY IGNORE or ON DUPLICATE KEY UPDATE emulations using MERGE
#17114 - KotlinGenerator contains incomplete list of Kotlin forbidden identifier characters
#17118 - Bad code generated for enum values containing backslash character
#17121 - CASE expression on BOOLEAN type emulation in JSON constructor causes ORA-40590: invalid format on Oracle XE 18
#17127 - MySQL boolean type information isn't maintained across expressions when embedded into JSON
#17136 - flag doesn't work outside of MySQLDatabase
#17151 - Join paths don't work when embeddable keys or domains on keys are present
#17160 - Meta::ddl produces incorrect DDL for SQLite, when there are FOREIGN KEY constraints
#17166 - Using embedded domains with POJO generation results in duplicate getters
#17172 - Overload resolution ambiguity in KotlinGenerator generated code for embeddable domains
#17191 - Multiset Result and Records are attached to derived configuration, not original one
#17197 - ScalaGenerator produces wrong code when generated interfaces (traits) extend multiple other interfaces
#17204 - IllegalAccessException when creating DSL.table(R...) from list of Kotlin generated TableRecords
#17213 - NPE while reading timestamp data type value for SAP SQL Anywhere 17 with jconn4
#17217 - Error in SybaseDatabase when generating code for routines
#17228 - Missing Support and NotNull annotations in ConstraintForeignKeyReferencesStepN
#17237 - Improve error message in GeneratorWriter when brackets mismatch, including the offending file
#17253 - Error when generating code for DuckDB user defined types from non-main schema
#17256 - Parser should accept qualified field references in MERGE .. INSERT statement
#17260 - Meta::filterCatalogs is applied too late for internal MetaImpl queries executed by Meta::ddl
#17264 - NullPointerException in MetaImpl::lookupTable when Schema isn't available for lookup of cross-schema foreign keys
#17267 - Exception when accessing MetaImpl::ddl with a user that lacks privileges to access certain databasese in SQL Server
#17277 - TableRecord null value has its changed flag reset despite a Converter encoding the null value as a non-null value
#17281 - Work around DERBY-7170 when fetching sources for tables in MetaImpl or DerbyDatabase
#17285 - Cannot parse default expression in Derby using MetaImpl when computed column is reported as DEFAULT
#17289 - NullPointerException in MetaImpl.getUniqueKeys() query when unique key cannot look up column references due to missing privileges
#17299 - SQLite's binding of BigDecimal through PreparedStatement.setString() doesn't work for predicates
#17305 - Records.mapping() implementations should handle null records
#17312 - JPADatabase should throw Hibernate's exceptions when there is anything going wrong with the SchemaExport
#17316 - Upgrade jOOQ-checker's protobuf-java transitive dependency due to CVE-2024-7254