On Sun, Jun 28, 2009 at 07:59:54PM -0400, Tim Largy scratched on the wall: > 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. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Our opponent is an alien starship packed with atomic bombs. We have a protractor." "I'll go home and see if I can scrounge up a ruler and a piece of string." --from Anathem by Neal Stephenson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users