Re: AW: AW: Re: [SQL] behavior of ' = NULL' vs. MySQL vs. S tand ards

Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at> writes:

> Thus it could be, that NULL in "where column = NULL" is not defined
> to have a special meaning according to SQL92.

The way I interpret Celko's interpretation of SQL92, that specific
construct has a meaning; it evaluates to UNKNOWN, thus not to TRUE,
and the WHERE clause becomes useless, as does any other combination of
a theta operator and the explicit constant 'NULL'. This is almost,
but not quite, an argument for allowing "= NULL" for "IS NULL". ;-)

Does anyone out there have the actual text of the standard?

-tih
--
The basic difference is this: hackers build things, crackers break them.