|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. <blockquote><verbatim> CREATE TABLE t1(aaa, UNIQUE(aaA), UNIQUE(aAa), UNIQUE(aAA), CHECK(Aaa>0)); ALTER TABLE t1 RENAME aaa TO bbb; --- fails </verbatim><blockquote>
drh added on 2019-01-09 02:04:12: (text/x-fossil-wiki)
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.