(text/x-fossil-wiki)
The SELECT statements in the following SQL provoke a NULL pointer deference:
<blockquote><verbatim>
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;
</verbatim></blockquote>
This problem was originally reported against System.Data.SQLite at
[https://system.data.sqlite.org/index.html/info/dd30ecb89d423c4c].
|