|02:04||• Fixed ticket [bc8d94f0]: RENAME COLUMN fails on tables with redundant UNIQUE constraints plus 6 other changes (artifact: 95951a2b user: drh)|
|02:02||Enhance the ALTER TABLE RENAME COLUMN feature so that it works on tables that have redundant UNIQUE and/or PRIMARY KEY constraints. Fix for ticket [bc8d94f0fbd633fd9a051e3] (check-in: f09aa324 user: drh tags: trunk)|
|01:51||• New ticket [bc8d94f0] RENAME COLUMN fails on tables with redundant UNIQUE constraints. (artifact: 0894c0ac user: drh)|
|Title:||RENAME COLUMN fails on tables with redundant UNIQUE constraints|
|Last Modified:||2019-01-09 02:04:12|
|Version Found In:||3.26.0|
drh added on 2019-01-09 01:51:02:
If a CREATE TABLE statement has redundant UNIQUE constraints, then an ALTER TABLE RENAME COLUMN fails.
CREATE TABLE t1(aaa, UNIQUE(aaA), UNIQUE(aAa), UNIQUE(aAA), CHECK(Aaa>0)); ALTER TABLE t1 RENAME aaa TO bbb; --- fails
drh added on 2019-01-09 02:04:12:
The problem was detected by a fuzzer run by the Chrome developers. There have been no reports of this problem causing problems in the wild, perhaps because few applications have redundant UNIQUE constraints.