Lukas Eder
Lukas Eder
The newly introduced `DOMAIN` types (#681) should support `COLLATE` clauses, as supported e.g. by Firebird and PostgreSQL.
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...
CockroachDB 20.1 (?) has introduced : https://www.cockroachlabs.com/docs/dev/as-of-system-time.html
### 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. ###...
### 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...
### 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...
### 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