VACUUM results in "database disk image is malformed" for PRIMARY KEY with duplicate column
|User & Date:||drh 2019-11-07 13:28:13|
An alternative formulation of the problem: <blockquote><verbatim> CREATE TABLE t0( c0, c1 UNIQUE, PRIMARY KEY(c1, c1) ) WITHOUT ROWID; INSERT INTO t0(c0,c1) VALUES('abc','xyz'); CREATE TABLE t1( c0, c1 UNIQUE, PRIMARY KEY(c1, c1) ) WITHOUT ROWID; INSERT INTO t1 SELECT * FROM t0; </verbatim></blockquote>
- login: "drh"
- mimetype: "text/x-fossil-wiki"
- priority changed to: "Immediate"
- resolution changed to: "Open"
- subsystem changed to: "Unknown"