Lukas Eder
Lukas Eder
PostgreSQL, and probably a few other RDBMS, have the notion of an "OWNER", a user or role which "owns" an object. In Oracle, there is also an "OWNER", which corresponds...
The current emulation of `FOR XML AUTO` and `FOR JSON AUTO` is unable to produce the sam ordering and nesting semantics as that of SQL Server. Consider ```sql select t.a,...
SQL Server supports the very useful `MERGE` extension `WHEN NOT MATCHED BY { SOURCE | TARGET }`. While `BY TARGET` is the default behaviour and corresponds to what all other...
Some users may want to use jOOQ's type safety only *to some extent*, e.g. for their joins, predicates, etc., but not for their projections. That way, they can fetch columns...
Some emulations of string functions need to know the `LENGTH(s)` of some string value. For example, when emulating `OVERLAY()`, we might emulate this using `INSERT()` in MySQL: ```sql -- Standard...
Some dialects (e.g. Oracle) support named `NOT NULL` constraints in DDL statements: ```sql create table t ( i int constraint i_nn not null, j int ); alter table t modify...
#1571 introduces two new functions `REGEXP_REPLACE_ALL` and `REGEXP_REPLACE_FIRST`. The distinction is made explicitly, such that the distinction between PostgreSQL dialects (replace first, by default), and others (replace all, by default)...
jOOQ 3.14 introduced support for SQL Server's `FOR XML` and `FOR JSON` clauses: #9923. The initial implementation omitted a few subclauses, which should be added, including: - [ ] `XMLDATA`...
We can currently only compare `RowN` with `Select`, not `Select` with `Select` types. For example, these are possible in some SQL dialects (specifically H2 and MySQL): ```sql select (select 1,...
We can calculate the `EPOCH` of a timestamp in Firebird, e.g. using: ```sql SELECT DATEDIFF(second, TIMESTAMP'1970-01-01 00:00', CURRENT_TIMESTAMP) FROM RDB$DATABASE ``` ---- See: https://stackoverflow.com/a/27858817/521799