SQLite

Ticket Change Details
Login
Overview

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

  1. icomment:
    Here is a simplified script to demonstrate the problem:
    
    <blockquote><verbatim>
    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;
    </verbatim></blockquote>
    
  2. login: "drh"
  3. mimetype: "text/x-fossil-wiki"