tursodatabase / tursodatabase/libsql
alter table alter column doesn't work with check constraint containing comma's and parentheses
Open
Nobody has claimed this yet.
- Dominant language
- C
- Stars
- 17.2k
- Forks
- 531
- Avg merge
- 1h 12m
- Merged PRs (30d)
- 1
Description
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')))
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the provided CREATE TABLE and ALTER TABLE SQL example and examining the resulting SQLite error. Trace the ALTER TABLE handling for check constraints containing commas and parentheses, then add a regression test showing that the column alteration succeeds without corrupting the CREATE TABLE statement.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql, sqlite
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 42/100