It looks like the issue does not exists.
I have thinked that i compare
NOT
(
EXISTS()
OR
EXISTS()
)
but this was really NOT EXISTS AND SOMETHING or EXISTS
and logic table for "NOT EXISTS AND SOMETHING" is:
false and NULL = false
but
true and NULL = NULL
which
On 2019-08-12 10:55, Svein Erling Tysvær setys...@gmail.com
[firebird-support] wrote:
> I certainly agree with you that if EXISTS returns false, then NOT
> EXISTS should return true. It could make some sense if both EXISTS and
> NOT EXISTS returned (though it should be documented somewhere),
> bu
>>I certainly agree with you that if EXISTS returns false, then NOT EXISTS
>>should return true.
>>It could make some sense if both EXISTS and NOT EXISTS returned
>>(though it should be documented somewhere), but not that one returns false
>>and the other .
>>When you write this in the tracker,
I certainly agree with you that if EXISTS returns false, then NOT EXISTS
should return true. It could make some sense if both EXISTS and NOT EXISTS
returned (though it should be documented somewhere), but not that
one returns false and the other . When you write this in the tracker,
I think it wou
>>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 FALSE
i have tested it now and i suppose result is wrong
--
On 9-8-2019 11:04, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> PS. I resend my email as previous from Thu, 08 Aug 2019 15:00:25 +0200
> is still not visible on the group
It looks like your email was stuck between your provider and Yahoo for a
day:
X-Received: from 127.
>> but if you're on a
different versionI am on FB3.0.5
>> So, do the 211 rows returned only in
case 2 have null in any of the columns compared in the exists?Both exists
in case 1 and 2 are exactly the same without any modifications. And as i am
looking for NOT exists tha
Well, Karol, I would say that logically speaking they may be thought of
as different. Though on this computer, running an old 2.5 Firebird
version, I'm not capable of making two such statements differ in results
and a very superficial internet search indicates that EXISTS always
return true or