Subject | Re: [firebird-support] Is there any logical difference? |
---|---|
Author | liviuslivius |
Post date | 2019-08-09T20:14:53Z |
different version>> but if you're on a
I am on FB3.0.5
case 2 have null in any of the columns compared in the exists?>> So, do the 211 rows returned only in
Both exists in case 1 and 2 are exactly the same without any modifications. And as i am looking for NOT exists than in query inside exists is empty resultset and then exists should return false.
Thank you Set for the help. I must do one more test on monday. I must modify Case to comparision
CASE WHEN EXISTS() IS NULL THEN -1 ...
And we will see if exists can return something else then TRUE or FALSE8
Regards,
Karol Bieniaszewski