SQLite
Ticket Change Details
Not logged in
Overview

Artifact ID: 131ac5b2324808bc65fe8be687b9c893eb68558ffb58ce103bfe8a0c89ee07ae
Ticket: 79cad5e4b2e219dd197242e9e5f4ef950f554684
UPSERT results in a corrupt database
User & Date: drh 2018-07-11 12:50:58
Changes

  1. Change icomment to:

    Here is a simplified script to demonstrate the problem:

    CREATE TABLE t1(b UNIQUE, a INT PRIMARY KEY) WITHOUT ROWID;
    INSERT INTO t1(a) VALUES('1'),(1) ON CONFLICT(a) DO NOTHING;
    PRAGMA integrity_check;
    
  2. Change login to "drh"
  3. Change mimetype to "text/x-fossil-wiki"