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

> You don't mean me, no ? My comment was intended to give an argument *for*
> allowing "= NULL" to behave like "IS NULL", by saying that the "= NULL"
> syntax is not defined directly (which Tom Ivar corrected), and would thus
> only be an extension.
> Tom Lane on the other hand said, that the standard only states NULL as a
> constant for a comparison when properly cast to a datatype.

:) That's the great thing about a long discussion: at the end I'm
confused about who wants what! Anyway, istm that until we have a
comprehensive solution for the original problem (badly formed queries
from Access going through ODBC) there is more downside to removing the
extension than there is in keeping it.

Does anyone know what other ODBC drivers look like internally? Do some
of them do extensive parsing of input queries (to reliably detect the "=
NULL" construct), or are they "lightweight" like ours seems to be?

- Thomas