Thanks for the succinct script for reproducing the problem. We are working on it now.
Just curious: Did you find this problem when a larger and more complex query failed in a real application? On Thu, Nov 13, 2014 at 9:05 AM, Igor Stassiy <istas...@gmail.com> wrote: > CREATE TABLE A(id UNSIGNED INT, tag NVARCHAR(256), value NVARCHAR(256)); > CREATE TABLE B(tag NVARCHAR(256), hash NVARCHAR(256)); > > INSERT INTO A VALUES(1, "color", "red"); > INSERT INTO A VALUES(1, "size", "big"); > > INSERT INTO A VALUES(2, "color", "green"); > INSERT INTO A VALUES(2, "size", "small"); > > INSERT INTO B VALUES("color", "color"); > INSERT INTO B VALUES("size", "size"); > > SELECT A.id,B.tag,value FROM A,B WHERE A.id IN (SELECT DISTINCT id FROM A > WHERE id IN (1, 2) limit 2) AND B.hash=A.tag ORDER BY A.id ASC; > > SQLite version 3.8.2 2013-12-06 14:53:30 > 1|color|red > 1|size|big > 2|color|green > 2|size|small > > SQLite version 3.8.7.1 2014-10-29 13:59:56 > 1|color|red > 1|size|big > > the correct output is in the version 3.8.2 > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users