| Subject | Re: Re: [firebird-support] Is there any logical difference? |
|---|---|
| Author | liviuslivius |
| Post date | 2019-08-12T07:52:40Z |
>>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
------------------------------------
SELECT
EXISTS() return False
FROM
WHERE
...
------------------------------------
but
SELECT
NOT EXISTS() return NULL!!! instead of True
FROM
WHERE
------------------------------------
i suppose it is an error and should be reported to the tracker?
Regards,
Karol Bieniaszewski