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" <[email protected]> Do: <[email protected]> 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
