Georg Traar

Eligible filters are not pushed down if any are ineligible, resulting in none being pushed down

3

### CrateDB version 5.7.3 ### CrateDB setup information Local 5.7.3 Remote Postgres 16 ### Problem description While not strictly defined as supported: > WHERE clauses can in some circumstances be...

### Problem Statement A cluster admin currently cannot adjust the default session settings, such as `search_path`, `error_on_unknown_object_key`, or others. However [Crate Issue #16074](https://github.com/crate/crate/issues/16074) will allow setting defaults for a user/role....

Cluster-Level JWT Configuration

6

### Problem Statement Currently, CrateDB allows [JWT configuration on a per-user basis](https://cratedb.com/docs/crate/reference/en/latest/sql/statements/create-user.html#with). Each user must be set up individually with specific JWT settings, such as the issuer (iss), audience (aud),...

Improve allocation of shards for partitioned tables

5

### Problem Statement There's a noticeable concern with the current method of allocating shards to nodes. Right now, there appears to be no randomness in how shards are assigned (see...

Expose Type Mapping for Object Columns in System Tables (e.g., information_schema.columns)

2

### Problem Statement Currently, there is no direct way to retrieve the mapping type (ignored, dynamic, or strict) of object columns from system tables like information_schema.columns. The only way to...

Support for Stored Procedures / Functions (plpgsql)

5

**Use case**: For certain longer running maintenance queries (e.g. automated data retention) it would be good to support simple (non-blocking) sequential execution of queries. In theory one could manage that...

Local checkpoint on replica not progressing

4

### CrateDB version 5.10.6 (and previous versions) > [!note] > ~~Could not reproduce on build from~~ master (6.0.0 May 24th) 🤔 > Also reproduceable, though due to the statement size...

Ability to add generated columns on non-empty tables

5

**Use case**: As I user I want to be able to add generated columns also after a table already has been filled. **Feature description**: Add a generated column on a...

Ability to provide session settings in HTTP request

8

### Problem Statement Session settings are increasingly used to influence CrateDB’s behavior during query execution. For queries over the PostgreSQL wire protocol, session management is handled at the protocol level....

Interval addition / summation in CrateDB does not normalize time units.

4

### CrateDB version 5.10 ### CrateDB setup information local single node ### Problem description CrateDB does not normalize interval arithmetic results, leading to non-standard representations. Adding two intervals can produce...