SQLite

Ticket Change Details
Login
Overview

Artifact ID: c77ece6b21e3dae63e7baa8b0fe5cbd654bb73a2a60aea004b2f02af29154a88
Ticket: 302027baf1374498d6092313c65ba09f4e814f74
VACUUM results in "database disk image is malformed" for PRIMARY KEY with duplicate column
User & Date: mrigger 2019-11-07 10:12:44
Changes

  1. foundin changed to: "3.30.0"
  2. icomment:
    The following test case results in an unexpected error:
    
    <pre>
    CREATE TABLE t0(c0, c1 UNIQUE COLLATE NOCASE, PRIMARY KEY(c1, c1)) WITHOUT ROWID;
    INSERT INTO t0(c1) VALUES(0);
    VACUUM; -- unexpected: database disk image is malformed
    </pre>
    
  3. login: "mrigger"
  4. mimetype: "text/x-fossil-wiki"
  5. severity changed to: "Critical"
  6. status changed to: "Open"
  7. title changed to:
    VACUUM results in "database disk image is malformed" for PRIMARY KEY with duplicate column
    
  8. type changed to: "Code_Defect"