Lukas Eder

The newly introduced `DOMAIN` types (#681) should support `COLLATE` clauses, as supported e.g. by Firebird and PostgreSQL.

Add NOT NULL support to DOMAINs in DDL

2

The newly introduced `DOMAIN` types (#681) should support `NOT NULL` constraints, as supported e.g. by Firebird, PostgreSQL, and SQL Server. There is probably a lot of synergy in implementing this...

With #8948, we have started emulating `JSONB` types in many dialects that do not have native support for it (unlike e.g. PostgreSQL). The idea is that `JSONB` is stored as...

The SQL standard and some implementations support the `MATCH` clause in foreign key specifications: https://dba.stackexchange.com/q/58894/2512 Example: ```sql CREATE TABLE foo (a int, b int, PRIMARY KEY (a,b)); CREATE TABLE t_full...

Add support for CockroachDB SYSTEM_TIME versioning

5

CockroachDB 20.1 (?) has introduced : https://www.cockroachlabs.com/docs/dev/as-of-system-time.html

Can't truncate table containing self references

4

### What happens? When working with a table containing self-references (e.g. to model a tree or graph), then I can't truncate the table, or delete all of its contents. ###...

UPDATE .. RETURNING doesn't work if there's a PRIMARY KEY or UNIQUE constraint on the table

4

### What happens? I can't use `UPDATE .. RETURNING` on a table with `PRIMARY KEY` ### To Reproduce ```sql create table t (i int primary key, j int); insert into...

DUCKDB_COLUMNS.DATA_TYPE_ID should reference actual STRUCT type, not generic STRUCT type

9

### What happens? In my opinion, this is a "bug", but feel free to re-classify as a change request if you think this works as expected, though I don't find...

NullPointerException when reading JDBC ResultSet.getDate() from a Timestamp column

2

### What happens? This error occurs: ``` Exception in thread "main" java.lang.NullPointerException: Cannot load from object array because "this.varlen_data" is null at org.duckdb.DuckDBVector.getLazyString(DuckDBVector.java:224) at org.duckdb.DuckDBVector.getDate(DuckDBVector.java:280) at org.duckdb.DuckDBResultSet.getDate(DuckDBResultSet.java:366) at org.jooq.testscripts.JDBC.main(JDBC.java:42) ```...

The documentation about the `SELECT` statement doesn't list the `WINDOW` clause, though it's clearly supported and documented elsewhere: - https://clickhouse.com/docs/en/sql-reference/statements/select - https://clickhouse.com/docs/en/sql-reference/window-functions