Johannes Faigle

### CrateDB version 4.8.1 ### CrateDB setup information _No response_ ### Steps to Reproduce 1. (Once upon a time...) We first created a table: ``` CREATE TABLE IF NOT EXISTS...

**Use case**: Postgres supports parameter `CASCADE` on `DROP TABLE` to drop dependent object (e.g. views) and foreign-key constraints https://www.postgresql.org/docs/14/sql-droptable.html Some ORMs (for example Hibernate) automatically execute `DROP TABLE` commands with...

Empty partitions are left behind after `DELETE FROM`

10

### CrateDB version 4.7.0 ### CrateDB setup information Single node; docker ### Steps to Reproduce Create table: ``` create table test ( ts timestamp, ts_day generated always as date_trunc('day', ts),...

Improve window aggregation with sub selects

2

### CrateDB version 4.6.4 ### CrateDB setup information _No response_ ### Steps to Reproduce ``` SELECT pos, LAG(pos, 1) OVER w as last_pos FROM( SELECT pos FROM table1 LIMIT 1000...

As a logged in user I want to logout of the current session so that I can login as a different user. --- Currently login is handled by BasicAuth which...