Overview
Artifact ID: | 1f6bc01c5a786684b8f369458f17727ef45de8392123c346b8e002d8f3c8481b |
---|---|
Ticket: | 302027baf1374498d6092313c65ba09f4e814f74
VACUUM results in "database disk image is malformed" for PRIMARY KEY with duplicate column |
User & Date: | drh 2019-11-07 13:28:13 |
Changes
- icomment:
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"