Marios Trivyzas

Add column on an existing & populated table with not null or default constraint

5

### CrateDB version 5.2.0 ### CrateDB setup information _No response_ ### Steps to Reproduce ``` cr> create table test(a int); CREATE OK, 1 row affected (0.179 sec) cr> insert into...

### Problem Statement Currently, `numeric` values are implicitly casted to `double`: ``` cr> select pg_typeof(variance(a)) from unnest([1.0::numeric, 2.0::numeric, 3.0::numeric, 4.0::numeric, 5.0::numeric]) as a; +------------------+ | pg_typeof | +------------------+ | double...

### Problem Statement Currently, `numeric` values are implicitly casted to `double`: ``` cr> select pg_typeof(geometric_mean(a)) from unnest([1.0::numeric, 2.0::numeric, 3.0::numeric, 4.0::numeric, 5.0::numeric]) as a; +------------------+ | pg_typeof | +------------------+ | double...