Overview
Artifact ID: | 131ac5b2324808bc65fe8be687b9c893eb68558ffb58ce103bfe8a0c89ee07ae |
---|---|
Ticket: | 79cad5e4b2e219dd197242e9e5f4ef950f554684
UPSERT results in a corrupt database |
User & Date: | drh 2018-07-11 12:50:58 |
Changes
- 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>
- login: "drh"
- mimetype: "text/x-fossil-wiki"