Thread

in(NULL)

Jose Soares <jose@sferacarta.com> — 2002-05-22T13:38:07Z

Hi all,

I think I found a bug using the IN operator.


I have a table t populated as follow:
a  |  b
---+----
1  | 11
2  | 22
3  | 33
4  | NULL
(4 rows)
select * from t where b in (11,22,NULL);
a  |  b
---+----
1  | 11
2  | 22
(2 rows)
select * from t where b not in (11,22,NULL);
a  |  b
---+----
(0 rows)
-----------------------------------------------
I tried the same quesry in mysql and it give me
a different result. Who are right?
select * from t where b not in (11,22,NULL);
+---+---+
| a | b |
+---+---+
| 3 | 33|
+---+---+
1 row in set (0.00 sec)

please reply to jose@sferacarta.com
jose