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
