Hello I would like to report a bug in the latest version of SQLite (3.15.0).
Description: If comparison of row-values is used in the expression of a LEFT JOIN clause and no mach is found, instead of one row with values from the left-hand table, no rows are returned. Example code: 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); The first SELECT returns one row, the second returns no rows. Ján Hric _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
