>> Can someone explain what is going on in the third select statement >> below? I would have expected it to return a row because the number is >> quoted. >> >> sqlite> select 'foo' where 1 in (1, '2', 'three'); >> foo >> sqlite> select 'foo' where 2 in (1, '2', 'three'); >> sqlite> select 'foo' where '2' in (1, '2', 'three'); >> sqlite> select 'foo' where 'three' in (1, '2', 'three'); >> foo > > The third select does return 'foo' for me. > > Tested on 3.6.11 and 3.4.0, Mac OS X Intel.
I'm using SQLite version 3.3.7 on a Debian-based OS. I'm stuck with this version, so I hope I can find a work around. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users