alter table alter column doesn't work with check constraint containing comma's and parentheses
luxint opened this issue · 0 comments
luxint commented
See example below,
→ create table t0(c1 text default 'tb' check(c1 in ('tb','cb','ab')));
→ alter table t0 alter column c1 to c1 text;
Error: failed to execute SQL: alter table t0 alter column c1 to c1 text;
SQLite error: CREATE TABLE t0(c1 text,'cb','ab')))