Quantcast

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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

mauro russo
...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)" <[hidden email]>
To: "Russo Mauro" <[hidden email]>
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
>
>
>


------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
Firebird-test mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-test
Loading...