/ 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. Change icomment to:

    An alternative formulation of the problem:

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