Re: [sqlite] BUGREPORT: LIMIT in a subquery has effect on the entire select

The ticket describing the cause of this problem is https://www.sqlite.org/src/tktview/db872294979b The problem should be fixed in 3.8.7.2 (due early next week) and in the next main release 3.8.8, and later today on trunk and on the branch-3.8.7 branch. On Fri, Nov 14, 2014 at 9:45 AM, Igor

Re: [sqlite] BUGREPORT: LIMIT in a subquery has effect on the entire select

this was found in a larger query during testing (the number of ids was larger in the IN statement, however the query was the same) the bug was found with version 3.8.7.1 on: Linux 3.13.0-39-generic #66-Ubuntu x86_64 GNU/Linux on 3.8.2 the error did not occur on Ubuntu, but occured on Darwin

Re: [sqlite] BUGREPORT: LIMIT in a subquery has effect on the entire select

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 wrote: > CREATE TABLE A(id

[sqlite] BUGREPORT: LIMIT in a subquery has effect on the entire select

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");