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. |