| Subject | Re: [firebird-support] it´s a bug? |
|---|---|
| Author | Dmitry Yemanov |
| Post date | 2007-01-10T17:26:42Z |
Paul Vinkenoog wrote:
of them mention "<> ANY" and "ALL", but it's the same as "NOT IN".
The standard require NOT IN to treat NULL as UNKNOWN, so it should
return different result from NOT EXISTS.
Dmitry
>Look at the tracker for CORE-115, CORE-142, CORE-85 and CORE-925. Some
> Couldn't find it the 2.0 notes
of them mention "<> ANY" and "ALL", but it's the same as "NOT IN".
The standard require NOT IN to treat NULL as UNKNOWN, so it should
return different result from NOT EXISTS.
Dmitry