>>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
--
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
>>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,
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