SQLite

The following SQL yields an incorrect result (zero rows) in all versions of SQLite between 3.6.14 and 3.7.15.2:

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;

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.