Re: [Firebird-test] [FB-Tracker] Resolved: (CORE-3337) problem in performing case statement

[mauro r. <m....@un...>]

...sorry to have been to fast in submit the report.

At least I learned how to interface with firebird developer group.

Thank you for very fast answer.
Mauro.


----- Original Message ----- 
From: "Adriano dos Santos Fernandes (JIRA)" <tr...@fi...>
To: "Russo Mauro" <usn...@ma...>
Sent: Saturday, February 05, 2011 3:06 PM
Subject: [FB-Tracker] Resolved: (CORE-3337) problem in performing case 
statement


>
>     [ 
> http://tracker.firebirdsql.org/browse/CORE-3337?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
>
> Adriano dos Santos Fernandes resolved CORE-3337.
> ------------------------------------------------
>
>    Resolution: Won't Fix
>
> There is no problem here.
>
> The first form compares NULL = NULL, which is obviously false.
>
> The first form equivalent is:
>  select distinct (case when NULL = NULL then 0 else 1 end) as v from 
> RDB$DATABASE
>
>
>> problem in performing case statement
>> ------------------------------------
>>
>>                 Key: CORE-3337
>>                 URL: http://tracker.firebirdsql.org/browse/CORE-3337
>>             Project: Firebird Core
>>          Issue Type: Bug
>>          Components: Engine
>>    Affects Versions: 2.1.1
>>            Reporter: mauro russo
>>
>> the query
>> select distinct (case NULL when NULL then 0 else 1 end) as v from 
>> RDB$DATABASE
>> wrongly returns 1
>> whereas the query
>> select distinct (case when NULL is NULL then 0 else 1 end) as v from 
>> RDB$DATABASE
>> correctly returns 0
>
> -- 
> This message is automatically generated by JIRA.
> -
> If you think it was sent incorrectly contact one of the administrators: 
> http://tracker.firebirdsql.org/secure/Administrators.jspa
> -
> For more information on JIRA, see: http://www.atlassian.com/software/jira
>
>
>