SQLite

View Ticket
Login
Ticket Hash: e8d439c77685eca6503ffbe8995b8945d8a80f55
Title: Crash on transitive WHERE constraint and undefined collation
Status: Fixed Type: Code_Defect
Severity: Severe Priority: Immediate
Subsystem: Unknown Resolution: Open
Last Modified: 2016-07-01 20:12:54
Version Found In: 3.13.0
User Comments:
drh added on 2016-07-01 20:08:28:

The SELECT statements in the following SQL provoke a NULL pointer deference:

CREATE TABLE t1(a INTEGER PRIMARY KEY);
CREATE TABLE t2(b INTEGER PRIMARY KEY, x1 INT COLLATE NOCASE);
CREATE TABLE t3(x2 INT);
SELECT * FROM t3, t2, t1 WHERE x2=b AND x1=a AND a=1;
SELECT * FROM t3, t2, t1 WHERE b=x2 AND a=x1 AND 1=a;

This problem was originally reported against System.Data.SQLite at https://system.data.sqlite.org/index.html/info/dd30ecb89d423c4c.