Re: [FB-Tracker] Commented: (CORE-3565) Uncorrect calculation of Select with 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] Commented: (CORE-3565) Uncorrect calculation of Select with case statement

Dmitry Lendel
Good morning,

>You haven't said specifically what the expected results should be for a
>given condition.

Yes, you right. I am blond, I am sorry. :-)

Further, although the database will be appreciated, should it be needed, you
need to provide specific details to reproduce, the current details are not
enough for that purpose.

I`ll prepare today and send you link

It seems that you believe that if a REM.{field} is NULL that the results
should have a non-NULL value, you are mistaken.  SQL defines very specific
rules for the handling of NULLs.

No.  Problem in calculation while field has null and non null values. If all
values are null result will Ok. if all values are not null result will ok.
If values mixed and case is presented and Sum is present result is not ok in
sum


Dmytro Lendel
Pink Elephant
(+38) 0312 612136
www.bagel.com.ua
www.pidkova.biz


------------------------------------------------------------------------------
FREE DOWNLOAD - uberSVN with Social Coding for Subversion.
Subversion made easy with a complete admin console. Easy
to use, easy to manage, easy to install, easy to extend.
Get a Free download of the new open ALM Subversion platform now.
http://p.sf.net/sfu/wandisco-dev2dev
_______________________________________________
Firebird-test mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-test
Loading...