[ ANNOUNCEMENT ] jOOQ 3.12.2 patch release with minor improvements and bug fixes

[Lukas Eder]

Version 3.12.2 - October 22, 2019

================================================================================

This is a 3.12 patch release with bug fixes

Features and Improvements

-------------------------

#9139 - Parser errors from DDLDatabase should hint at jOOQ's parser ignore comment syntax

#9172 - Add Javadoc to DSL::execute

#9173 - Add support for parsing MySQL FULLTEXT KEY inline declaration in CREATE TABLE

#9245 - Render DROP TEMPORARY TABLE in MySQL

#9282 - Add JSON.data() and JSONB.data()

#9286 - Add a link from the dialect family to the latest dialect version in each SQLDialect

#9290 - Add Javadoc to Configuration.dsl() explaining that it is just convenience

#9306 - Support parsing Vertica's TEMP table syntax

#9373 - Improve SEMI / ANTI JOIN documentation

#9377 - Java generator always uses LF line terminator for import statements

Breaking changes

----------------

#9284 - DefaultBinding should return null on null JSON values, instead of JSON[B].valueOf(null)

Bug Fixes

---------

#9135 - Wrong rendering of [ FROM { FIRST | LAST } ] clause for NTH_VALUE()

#9137 - 404s on /latest Javadoc

#9143 - Translation of USE command should result in SET SCHEMA command in dialects that do not support catalogs

#9148 - ParserCLI --from-dialect is not case insensitive

#9149 - ParserCLI -h parameter throws a RuntimeException

#9152 - Compilation error in generated code when Oracle OBJECT type contains index_of(varchar2) member procedure

#9175 - ParserCLI "-f" flag does not work as shortcut for "--from-dialect"

#9178 - H2: SelectLimitPercentStep#percent() not working properly

#9199 - Only first value added to date time appears in rendered SQL

#9208 - Negative intervals not rendered properly for PostgreSQL

#9215 - SQLDialect.MEMSQL lacks Pro annotation

#9220 - Regression in Extract(QUARTER) on Postgres in 3.12.1

#9226 - Postgres: FILTER clause no longer rendered

#9228 - Regression for "= ANY(?::int[])" no longer produces array bind variable

#9232 - Wrong Javadoc on org.jooq.Source

#9249 - Regression: DSLContext#nextval() broken for H2

#9253 - H2's WITH TIES support broken in OSS edition

#9258 - LEFT [ ANTI | SEMI ] JOIN ... USING not implemented

#9275 - AttributeConverterExtractor should receive custom Hibernate configuration properties

#9278 - Improve error message when AttributeConverters cannot be loaded due to NoClassDefFoundError

#9281 - Consistently document all commercial SQLDialects

#9287 - Parser cannot handle enum literals that are invalid java identifiers

#9292 - Sequences are generated as tables in MariaDB

#9299 - DSL.field(Name) fields should support schema mapping

#9334 - Postgres 12 exception in code generation output: "column c.consrc does not exist"

#9339 - Parse ignore comments not parsed correctly if stop comment is last token of file, prior to a newline

#9348 - Wrong SQL generation for PostgreSQL function calls having arguments with custom data types.

#9349 - Fix Support annotations for CREATE SEQUENCE flags

#9356 - LoggingConnection does not log static statements

#9385 - DataType.getDataType(Configuration) turns this on dialect specific data types

#9387 - RenderMapping is not applied to DSL.schema(Name)

#9390 - CREATE INDEX commands created from DSLContext.ddl() based on Meta contain illegal WHERE clause

#9402 - Java 8 distribution references JAXB 2.3.0, which doesn't work pre JDK 9

#9412 - Firebird generated code contains "DEFAULT" keyword in default expressions

#9416 - Emulate RETURNING * in Firebird

#9419 - Regression in Firebird's SUBSTRING() implementation

#9422 - When using org.jooq.Meta, UniqueKey.getReferences throws NPE in Firebird