Lukas Eder
Lukas Eder
jOOQ 3.18.0 introduces support for a `SQLDialect.POSTGRES_15` dialect (https://github.com/jOOQ/jOOQ/issues/13358). This means we can now generate standard SQL/JSON functions for PostgreSQL, which look nicer than some of the PG specific stuff....
While the example project contains two configurations (see below Maven profiles), the manual only explains how the checker framework is configured. Might be worth documenting both. ```xml checker-framework org.apache.maven.plugins maven-dependency-plugin...
Currently, generated `DEFAULT` expressions are generated as plain SQL expressions, which contain vendor specific SQL strings. It would be much better to generate a parse call that parses this vendor...
Oracle PL/SQL supports a multi table `INSERT ALL` statement, which can be emulated in other databases by sending individual insert statements to the servers. The statement is only available in...
The SQL standard ISO/IEC 9075-2:2016(E) 8.18 <set predicate> is specified as follows: ``` ::= IS [ NOT ] A SET ``` In other words, for any `Multiset` expression, it should...
The `JDBCDatabase` currently does not support fetching routines, although this should be possible via JDBC's `DatabaseMetaData.getProcedures()`, `getProcedureColumns()`, `getFunctions()`, `getFunctionColumns()`. Historically, these methods were poorly supported by a number of JDBC...
Currently, all "unknown" data types are serialised by calling `toString()` simply. Deserialisation of such values is currently not possible. Users should be able to intercept this with `Converter` SPIs that...
Currently, users cannot omit `` or `` in a ``, when they provide a ``. But in many cases, we do support auto-conversion between the `T` type and some user...
H2 seems to support `MIN` and `MAX` aggregate functions for row value expressions, which is a *very* useful feature (https://github.com/jOOQ/jOOQ/issues/9113#issuecomment-526925653). They can be emulated. - In most RDBMS with `ORDER...
We currently cannot `CREATE`, `ALTER`, or `DROP` materialized views. Supporting these statements is a prerequisite for being able to export them using `Meta.ddl()`: https://github.com/jOOQ/jOOQ/issues/6412 A syntax and vendor support analysis...