Niklas Schmidtmer

Array overlap/intersect function

8

### Problem Statement Given two arrays, I want to know if they overlap or not. Example: ```sql CREATE TABLE t1 ( id INTEGER PRIMARY KEY, my_array ARRAY(INTEGER) ); INSERT INTO...

`OutOfMemoryError` when querying table with large vector field

4

### CrateDB version 5.10.7 ### CrateDB setup information CrateDB Cloud single-node S4 ### Problem description When querying a large result set with vectors of length 1152, there is an `OutOfMemoryError`...

Support hash join execution strategy for `FULL JOIN`

1

### Problem Statement `FULL JOIN`s result in a nested loop join execution strategy and are therefore slow on large data sets. Example: ```sql CREATE TABLE IF NOT EXISTS "doc"."t1" (...

Support partition pruning for indirect references to partition column

1

### Problem Statement _Not sure if bug or feature request_ Consider the following data model: ```sql CREATE TABLE metrics ( "ts" TIMESTAMP WITH TIME ZONE NOT NULL, "ts_month" TIMESTAMP WITH...

Improve `SQLParseException` indicating which expression caused a casting error

1

### Problem Statement When there is a type casting error, an `SQLParseException` is thrown. The exception mentions which value failed to be casted, but not which column or expression caused...

Support `ALTER TABLE x ALTER COLUMN y SET DEFAULT`

3

### Problem Statement Users occasionally want to change a columns' default value. Either to retrospectively add a new default value to an existing column that didn't have a default value...

Improve observability of circuit breakers

1

### Problem Statement We have recently observed a case of circuit breaker accounting not releasing memory correctly (https://github.com/crate/crate/issues/18688). With this particular issue addressed, we may still face the same symptoms...

Cluster not recovering due to `obtaining shard lock for [read metadata snapshot] timed out`

2

### CrateDB version 5.10.14 ### CrateDB setup information Number of nodes: 12 + 3 master ### Problem description We have observed cases where the cluster doesn't fully recover after initiating...

### Problem Statement When using Grafana's query builder tool, the following SQL is generated to populate the dropdown of columns: ```sql SELECT quote_ident(column_name) AS "column", data_type AS "type" FROM information_schema.columns...