Hi,
It seems there's a problem with 3.8.5 and its affinity behavior.
It's quite critical.
--- CUT ---
sqlite> CREATE TABLE T (v text);
sqlite> insert into T values('1');
sqlite> insert into T values('2');
sqlite> select v from T where v=1;
1
sqlite> select v from T where v='1';
1
sqlite> select v from T where v IN(1);
sqlite> select v from T where v IN('1');
1
sqlite> select v from T where v IN(1,2);
1
2
sqlite> select v from T where v IN('1','2');
1
2
--- /CUT ---
It must be linked to this change:
"Render expressions of the form "x IN (?)" (with a single value in the list on
the right-hand side of the IN operator) as if they where "x==?", Similarly
optimize "x NOT IN (?)""
Best regards,
--
Guillaume FOUGNIES
Eulerian Technologies
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
