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
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
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
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