SQLite

View Ticket
Login
2018-11-05
13:42 Fixed ticket [1a84668d]: Assertion fault due to malformed PRIMARY KEY plus 5 other changes (artifact: 4912034c user: drh)
13:35
Fix a assert() in the query planner that can arise when doing row-value operations on a PRIMARY KEY that contains duplicate columns. Ticket [1a84668dcfdebaf12415d]. (check-in: 1309c84a user: drh tags: branch-3.25)
2018-11-03
13:11
Fix a assert() in the query planner that can arise when doing row-value operations on a PRIMARY KEY that contains duplicate columns. Ticket [1a84668dcfdebaf12415d]. (check-in: dcb8c735 user: drh tags: trunk)
12:36 New ticket [1a84668d] Assertion fault due to malformed PRIMARY KEY. (artifact: 25fe2f85 user: drh)

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.