Subject Odp: [firebird-support] Bug?
Author liviuslivius@poczta.onet.pl
Post date 2014-05-05T12:19:24Z
Hi,

Thanks you confirm this
I add this as "bug?" with question mark becouse Ingres server return in this query wrong result and my boss think that i do something wrong in migration process...

Regards,
Karol Bieniaszewski

----- Reply message -----
Od: "Ivan Přenosil" <Ivan.Prenosil@...>
Do: <firebird-support@yahoogroups.com>
Temat: [firebird-support] Bug?
Data: pon., maj 5, 2014 13:44


 

> this query return 0
>
> SELECT count(*) FROM RDB$DATABASE WHERE ((CAST(NULL AS INTEGER) IS NULL AND CAST(123 AS INTEGER) IS NULL) OR
> (CAST(NULL AS INTEGER)=1))
>
> when i add "NOT" this query return also 0
>
> SELECT count(*) FROM RDB$DATABASE WHERE NOT ((CAST(NULL AS INTEGER) IS NULL AND CAST(123 AS INTEGER) IS NULL) OR
> (CAST(NULL AS INTEGER)=1))
>
>
> is this a bug?

No. Where clause of the first select is
True and False or Null -> Null
So the second select is
Not Null -> Null

Ivan