On 10/26/16, Ján Hric <janhri...@gmail.com> wrote: > Hello > I would like to report a bug in the latest version of SQLite (3.15.0).
Thanks for a very clear and succinct bug report. Well done! The ticket is here: https://www.sqlite.org/src/tktview/fef4bb4bd9185ec8f18d9912abb444da61d02ff2 > > 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 > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
