Version 3.19.30 - January 29, 2026

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

Bug Fixes

#19485 - Work around DuckDB limitation where RETURNING clauses don't support bind values #19488 - DuckDB doesn't support the ON CONFLICT .. WHERE clause, only the DO UPDATE .. WHERE clause #19496 - Error with DuckDB DECIMAL bind value cast for large decimals #19503 - JSON parser should be able to handle non-standard JSON NaN and Infinity values #19507 - Confusing warning about dialect version support #19511 - DuckDB doesn't support binding lobs in ClobBinding #19514 - DuckDBDatabase produces both identity flags and DEFAULT expression #19518 - Multiset JSON emulation should use explicit JSON_ARRAYAGG .. ORDER BY clause where derived table ordering is unstable #19521 - Bad DuckDB interval bind values formatting #19523 - Bad decoding of spatial data from DuckDB database #19526 - Bad cast type for DuckDB INTERVAL DAY TO SECOND type #19536 - Optimistic locking may produce unsupported FOR UPDATE clause in DuckDB #19539 - DuckDB NestedCollectionEmulation.JSON emulation can't nest MULTISET expressions in ROW expressions #19542 - Add support for DuckDB TIMESTAMP_NS, TIMESTAMP_MS, TIMESTAMP_S types #19553 - Upgrade log4j-core dependency to mitigate CVE-2025-68161 #19560 - Error when using IS [NOT] DISTINCT FROM with LOB columns in Oracle #19565 - Meta.getTables(Name) should allow for partially qualified lookups #19574 - HSQLDBDatabase doesn't correctly implement includeSystemCheckConstraints when identifiers are quoted #19581 - Bad formatting of CAST() function content #19586 - QOM.Array should implement SimpleCheckQueryPart, and return true if there are only few elements #19596 - Improve formatting of PARTITION BY and ORDER BY clauses in window functions #19599 - SQLExceptionLoggerListener logs incorrect message about precision when truncated numeric value cannot be inserted for some other reason #19604 - Support emulating EXCLUDED in MySQL, when used in expressions #19608 - MULTISET returns invalid JSONB for JSON string scalar values #19612 - Inlined JSON should be rendered as JSON literal in DuckDB #19623 - jOOQ-bom pom.xml should be published using packaging=pom