Hi,


I know there is a new feature in fb 2.0 which makes expressions like

column = NULL

valid!

But:

If I have a table PERSONS: e.g.


Id Name
----------
0 Hans
1 <NULL>
2 Someone

and I submit
SELECT * FROM PERSONS WHERE "Name" IS NULL;
record Id=1 is returned.

With
SELECT * FROM PERSONS WHERE "Name" = NULL;
no record is returned but also no error message!

Is this expected or is it a bug?
I'd expected either also record Id=1 or an error message but not an
empty result set!



Björn

--
Björn Reimer -- R R Z E -- Datenbanken und DV-Verfahren