[ ANNOUNCEMENT ] 3.14.16, 3.15.11 and 3.16.7 patch releases with minor improvements and bug fixes

[Lukas Eder]

Version 3.14.16 - June 16, 2022
================================================================================


Features and Improvements
-------------------------
#12490 - Log warning in code generator when wrong runtime version is used


Bug Fixes
---------
#12483 - DSL.arrayGet() does not generate required parentheses
#12497 - Ignored COMMENT ON CONSTRAINT syntax should support qualified object identifiers
#12504 - NPE in Query.equals() when Query isn't attached - Merge [#12502
#12571 - Connection leak when ExecuteListener::fetchEnd throws an exception
#12614 - SQLDataType.null generated when using XMLDatabase with lower case array type
#12616 - Generated column in table valued function of type TIMESTAMP without precision is generated using precision zero
#12618 - Codegeneration fails with case sensitive data types in postgres 9.0 or less
#12624 - H2 enums which contain brackets are not generated in Java enum
#12642 - OracleDatabase doesn't produce correct CYCLE sequence flag information in code generation
#12652 - Parser parses and ignores NOT keyword after column expression
#12746 - Loader.onDuplicateKeyIgnore doesn't work on tables that don't have a PRIMARY KEY
#13229 - Wrong escaping of string literals in doubly nested EXECUTE IMMEDIATE blocks for DDL emulations
#13628 - Wrong code generated for Oracle package procedure SYS.DBMS_STATS.GATHER_DATABASE_STATS

Version 3.15.11 - June 16, 2022
================================================================================

Features and Improvements
-------------------------
#13527 - Improve Documentation for DSLContext.fetchStream() and related methods
#13584 - DefaultRecordMapper should check whether user is attempting to map into an inner class


Bug Fixes
---------
#13470 - Work around SQLite INSERT .. SELECT .. ON CONFLICT bug
#13475 - SQLException when calling oracle.jdbc.driver.ArrayDataResultSet.getMetaData()
#13491 - ArrayIndexOutOfBoundsException when rendering PostgreSQL plain SQL template containing ?@
#13493 - org.jooq.SQL and manual should document plain SQL templating's capability of recognising :named parameters
#13501 - Improve implementation of QualifiedName.hashCode()
#13505 - Parser meta lookups don't work for INSERT .. SELECT .. RETURNING
#13512 - MySQL, MariaDB, SQL Server may ignore MULTISET subquery ORDER BY clause
#13515 - LoaderLoadStep.execute() shouldn't have @CheckReturnValue annotation
#13568 - INSERT .. RETURNING emulations shouldn't acquire multiple connections from ConnectionProvider when using ThreadLocalTransactionProvider
#13570 - Field::likeIgnoreCase should cast lhs operand just like Field::like and Field::similarTo
#13623 - UnsupportedOperationException when selecting single nested row with JSON column
#13627 - Wrong code generated for Oracle package procedure SYS.DBMS_STATS.GATHER_DATABASE_STATS
#13645 - Wrong result column type for requested conversion when reading JSONB_ARRAY nested in ROW in DB2
#13649 - DefaultRecordUnmapper should cache AbstractRow and record type
#13662 - PostgreSQL ON CONFLICT .. WHERE .. DO NOTHING generates not valid SQL
#13675 - Settings.returnAllOnUpdatableRecord doesn't work for UPDATE queries in HSQLDB
#13678 - Improve <inputCatalog/> warning message in code generator
#13683 - Cannot use scalar subquery originating from MULTISET in JSON_OBJECT() VALUE clause in Db2

Version 3.16.7 - June 16, 2022
================================================================================

Features and Improvements
-------------------------
#13526 - Improve Documentation for DSLContext.fetchStream() and related methods
#13529 - Replace internal usage of DatatypeConverter::parseBase64Binary by java.util.Base64
#13531 - Support converting from java.sql.Array to Object[] types
#13583 - DefaultRecordMapper should check whether user is attempting to map into an inner class


Bug Fixes
---------
#13466 - Expressions based on computed columns must not retain computation reference
#13469 - Work around SQLite INSERT .. SELECT .. ON CONFLICT bug
#13474 - SQLException when calling oracle.jdbc.driver.ArrayDataResultSet.getMetaData()
#13490 - ArrayIndexOutOfBoundsException when rendering PostgreSQL plain SQL template containing ?@
#13492 - org.jooq.SQL and manual should document plain SQL templating's capability of recognising :named parameters
#13500 - Improve implementation of QualifiedName.hashCode()
#13504 - Parser meta lookups don't work for INSERT .. SELECT .. RETURNING
#13511 - MySQL, MariaDB, SQL Server may ignore MULTISET subquery ORDER BY clause
#13514 - LoaderLoadStep.execute() shouldn't have @CheckReturnValue annotation
#13532 - ARRAY_AGG cannot aggregate array columns in H2
#13561 - Invalid SQL generated for Oracle when selecting multiple unaliased rows
#13566 - MySQL / MariaDB generated columns with enum type are not generated as readonly
#13567 - INSERT .. RETURNING emulations shouldn't acquire multiple connections from ConnectionProvider when using ThreadLocalTransactionProvider
#13569 - Field::likeIgnoreCase should cast lhs operand just like Field::like and Field::similarTo
#13622 - UnsupportedOperationException when selecting single nested row with JSON column
#13626 - Wrong code generated for Oracle package procedure SYS.DBMS_STATS.GATHER_DATABASE_STATS
#13644 - Wrong result column type for requested conversion when reading JSONB_ARRAY nested in ROW in DB2
#13648 - DefaultRecordUnmapper should cache AbstractRow and record type
#13661 - PostgreSQL ON CONFLICT .. WHERE .. DO NOTHING generates not valid SQL
#13674 - Settings.returnAllOnUpdatableRecord doesn't work for UPDATE queries in HSQLDB
#13677 - Improve <inputCatalog/> warning message in code generator
#13682 - Cannot use scalar subquery originating from MULTISET in JSON_OBJECT() VALUE clause in Db2