Lukas Eder
Lukas Eder
In SQLite, the type is completely ignored (type affinity) when we use `AS` for computed columns. For example, this is valid: ```sql create table t (i int, j geeeenerattteeeeed as...
In Oracle, it is possible to declare a column without a data type if the data type can be derived from the primary key: ```sql create table par ( c1...
In PostgreSQL, `TIMESTAMP` literals don't have to follow the ISO `YYYY-MM-DD HH24:MI:SS` format. It seems that abbreviated forms are possible as well, e.g. this is `TRUE`: ```sql SELECT TIMESTAMP '2000-01-01'...
Teradata bends the rules of the logical order of SQL operations quite a bit, see: https://blog.jooq.org/a-beginners-guide-to-the-true-order-of-sql-operations/ In Teradata, it seems that these are possible: **Referencing column alias from `WHERE`**: ```java...
Starting from jOOQ 3.17 and https://github.com/jOOQ/jOOQ/issues/4727, we support projecting table expressions in `SELECT` in all dialects, with some native support in PostgreSQL. From an API point of view, it is...
jOOQ 3.18 introduces emulation support for `GROUP BY ` using substitution via https://github.com/jOOQ/jOOQ/issues/13769 E.g. ```sql SELECT first_name || ' ' || last_name AS name FROM actor GROUP BY 1 ORDER...
PostgreSQL 15 has some useful extension to the standard SQL `MERGE` statement: It is possible in both types of `WHEN` clauses to append a `DO NOTHING` clause instead of the...
The following test fails: ```java @Test public void testPlainSQLParamRenderingRepeatedParams() { ResultQuery q1 = resultQuery( "select :first as a1, coalesce(:second, :second) as b1, :second as b2, :first as a2", param("first", 1),...
SQL:2011 has introduced a much overlooked but cool feature called "nested window functions", see ISO/IEC 9075-2:2016(E) 6.11 <nested window function>. So far, I haven't seen any implementations of it in...
In 12c, recursive subquery factoring (CTE, WITH clause) has received a new feature specifying how the recursive search should handle cycles: ![image](https://cloud.githubusercontent.com/assets/734593/25141848/2a41e604-2465-11e7-9bbd-03d9dba14a7b.png) https://docs.oracle.com/database/121/SQLRF/img_text/cycle_clause.htm