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: (text/x-fossil-wiki)
The following SQL results in an assertion fault:

<blockquote><verbatim>
CREATE TABLE t1(a,b,PRIMARY KEY(b,b));
SELECT * FROM t1 WHERE (a,b) IN (VALUES(1,2));
</verbatim></blockquote>

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