(text/x-fossil-wiki)
The following SQL yields an incorrect result (zero rows) in all versions
of SQLite between 3.6.14 and 3.7.15.2:
<blockquote><verbatim>
CREATE TABLE t(textid TEXT);
INSERT INTO t VALUES('12');
INSERT INTO t VALUES('34');
CREATE TABLE i(intid INTEGER PRIMARY KEY);
INSERT INTO i VALUES(12);
INSERT INTO i VALUES(34);
SELECT t1.textid AS a, i.intid AS b, t2.textid AS c
FROM t t1, i, t t2
WHERE t1.textid = i.intid
AND t1.textid = t2.textid;
</verbatim></blockquote>
The correct result should be two rows, one with 12|12|12 and the other with 34|34|34. With this bug, no rows are returned. Bisecting shows that this bug
was introduced with check-in [dd4d67a67454] on 2009-04-23.
|