SQLite

The second SELECT statement below gives an incorrect answer, even though it is logically identical to the first SELECT statement:

CREATE TABLE t1(a, b);
INSERT INTO t1 VALUES(1, 2);
CREATE TABLE t2(a, b);
INSERT INTO t2 VALUES(3, 4);
SELECT * FROM t1 LEFT JOIN t2 ON t2.a = t1.a AND t2.b = t1.b;
SELECT * FROM t1 LEFT JOIN t2 ON (t2.a, t2.b) = (t1.a, t1.b);

Since row values are a new feature beginning with version 3.15.0, this bug could not have existed in any prior versions.

Reported by Ján Hric on the sqlite-users mailing list.