SQLite

View Ticket
Login
Ticket Hash: 1a84668dcfdebaf12415d8c549d67029f0e2faba
Title: Assertion fault due to malformed PRIMARY KEY
Status: Fixed Type: Code_Defect
Severity: Critical Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2018-11-05 13:42:03
Version Found In: 3.25.2
User Comments:
drh added on 2018-11-03 12:36:31:

The following SQL results in an assertion fault:

CREATE TABLE t1(a,b,PRIMARY KEY(b,b));
SELECT * FROM t1 WHERE (a,b) IN (VALUES(1,2));

The problem seems to be associated with the duplicate columns in the PRIMARY KEY. Detailed analysis of the problem is pending.