(text/x-fossil-wiki)
The second SELECT statement below gives an incorrect answer, even though
it is logically identical to the first SELECT statement:
<blockquote><verbatim>
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);
</verbatim></blockquote>
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.
|