(text/x-fossil-wiki)
In the following SQL command sequence, query 3 returns no results when it
should return "1":
<blockquote><verbatim>
CREATE TABLE t1(v text);
INSERT INTO t1 VALUES('1'),('2');
SELECT 1, v FROM t1 WHERE v=1;
SELECT 2, v FROM t1 WHERE v='1';
SELECT 3, v FROM t1 WHERE v IN (1);
SELECT 4, v FROM t1 WHERE v IN ('1');
SELECT 5, v FROM t1 WHERE v IN (1,2);
SELECT 6, v FROM t1 WHERE v IN ('1','2');
</verbatim></blockquote>
This problem was reported on the mailing list by Guillaume Fougnies.
It appears to have been introduced by check-in [2ea4a9f75f46eaa928ba]
on [2014-03-20] and was released in version 3.8.5.
|