Michael,
>Are you saying that "1" below doesn't show up in the first query result?
>
>sqlite> create table t(i int,name string);
>sqlite> insert into t values(1,NULL);
>sqlite> insert into t values(2,'two');
>sqlite> select * from t where i in (1,2,3,null);
>i|name
>1|
>2|two
>sqlite> select * from t where i in (1,2,3) or i is NULL;
>i|name
>1|
>2|two
The query is more likely:
select * from t where name in ('two',null);
i|name
2|two
In your example there is no null in the i column.
--
<mailto:j...@q-e-d.org>j...@antichoc.net
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
