SQLite

Ticket Change Details
Login
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

  1. 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>
    
  2. login: "drh"
  3. mimetype: "text/x-fossil-wiki"
  4. priority changed to: "Immediate"
  5. resolution changed to: "Open"
  6. subsystem changed to: "Unknown"