[V4RB] sum is not working?

[Ruslan Zasukhin]

On 13/5/07 3:27 PM, "Carsten Friehe" <rblists at online.de> wrote:

Hi Carsten,

> I am using V4RB 2.5.6 because that is the last working version for me. But
> there is one thing that drives me crazy. It seems that sum() is not working
> correctly.
> 
> I have a table with one boolean field. I am trying to get a sum() of this
> field.
> I tried:
> select sum(boolfield) from table
> and:
> select sum(if(boolfield = True, 1, 0)) from table
> 
> But I always get 0 as a result. I would expect that he gives me the count
> of records where this value is 1 (or true). I know that I simly call:
> select count(boolfield) where boolfield 0 true from table
> but I also want to get back some other values in parallel. This is only a
> part of my select.

Sounds like a bug related to SUM() on Boolean field.

Please report into Mantis.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]