A fix is checked in at http://www.sqlite.org/src/info/1128575d0a now. You can download new prerelease snapshots containing the fix from http://www.sqlite.org/draft/download.html or you can manually patch whatever version SQLite you prefer to use by adding the second term of the conditional shown on line 4754 of http://www.sqlite.org/src/info/1128575d0a?sbs=0#chunk2
On Thu, May 9, 2013 at 10:08 AM, Richard Hipp <d...@sqlite.org> wrote: > > > On Thu, May 9, 2013 at 8:48 AM, Romulo Ceccon <romulocec...@gmail.com>wrote: > >> >> The following script demonstrates the problem: >> >> (test.sql) >> CREATE TABLE t(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, >> a INTEGER, b INTEGER); >> CREATE TABLE mutex(i INTEGER); >> INSERT INTO mutex(i) VALUES (0); >> INSERT INTO mutex(i) VALUES (1); >> INSERT INTO t(a, b) VALUES (1, 2); >> SELECT * FROM t; >> SELECT 'not found (1)' >> FROM mutex LEFT JOIN t >> ON a = 1 AND b = 2 >> WHERE i = 1 AND id IS NULL; >> SELECT 'not found (2)' >> FROM mutex LEFT JOIN t >> ON a = 1 OR b = 2 >> WHERE i = 1 AND id IS NULL; >> > > Simpler demonstration here: http://www.sqlite.org/src/info/f2369304e4 > > > -- > D. Richard Hipp > d...@sqlite.org -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users