hlcianfagna

Expressions evaluated for automatic column names when constant

2

### CrateDB version 5.0.1 ### CrateDB setup information _No response_ ### Steps to Reproduce create table testexpeval (a int); insert into testexpeval select 1; select a/2 from testexpeval; select 1.0/2...

Deduce the inner type of a dynamic array that can satisfy mixed types

4

### CrateDB version 5.6.1 and 5.5.3 ### CrateDB setup information `CRATE_HEAP_SIZE=1g` and `discovery.type=single-node` ### Problem description I came across this importing some complex JSON data. Strings with JSON containing arrays...

System view for open sessions

2

### Problem Statement When debugging issues with connection pooling, `connections` in `sys.nodes` allows to see the number of open connections, but there are no further details. ### Possible Solutions It...

Ability to `ALTER COLUMN` changing data type

2

### Problem Statement After a system has been live and ingesting real data for a while, it may become desirable to change the data types on a table. We may...

Support Azure AD integrated authentication

3

### Problem Statement In a large organization there is people joining, leaving, and moving teams all the time. The permissions people should have on data depend on the teams they...

### Problem Statement In certain defense and financial use cases, ISO 15408 ("Common Criteria") compliance may require all queries to be logged in a fail-secure fashion (logging is guaranteed to...

### Problem Statement In some use cases, it is useful to provide a user with access to a table but hiding or masking certain records/fields within the table. ### Possible...

Make it easier to identify what led to node crashes

8

### Problem Statement When a node crashes it is difficult to identify what was running at the time. Configuring `stats.jobs_log_persistent_filter` results on statements being logged, but only once they complete....

Implement `DROP SCHEMA`

4

### Problem Statement For improved compatibility, it could be useful to implement `DROP SCHEMA` ### Possible Solutions Without `CASCADE`, check if anything exists on the schema and if so return...

Implement a session id and expose it in sys.jobs[_log]

3

### Problem Statement When implementing ETL logic: - sometimes is useful to have access to the outcome of the previous command in the batch purely through SQL commands, PL/pgSQL has...