On Thu, Jun 26, 2008 at 04:35:20PM +0700, Dan wrote: > Do we also have a similar problem with the regular 'IN' operator? In > SQLite at the moment: > > SQLite version 3.6.0 > sqlite> select 1 IN (null, 2, 3), 2 IN (null, 2, 3); > 0, 1 > > Should the leftmost column of the result row should be NULL, not "0"? > Since rule (d) above is not true for "1 IN (null, 2, 3)", do we fall > through to rule (e) and return NULL?
I'd say so, yes - and MySQL and postgres seem to agree too. Cheers, Peter _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
