AW: sum is rounding values when subquerying

Edson Carlos Ericksson Richter wrote:
> 
> Hi!
> 
> I'm using 7.5.0.19 on Win32 and I've relative complex query, similar to
> 
> select M.id
>        , M.name
>        , (select sum(orderValue) from orders where customerId=M.id and
> printDate between '2004-01-01' and '2004-12-31') as orderTotal
>   from mainTable M
> where M.id > 1000 and M.id < 10000
> 
> The problem is the sum(orderValue) is rouding values (even orderValue
> being a decimal(18,2)), and each result have always a .0 just after the
> integer part.
> 
> There is something worng with what I made?
> 
> Thanks for any tips.

Oops, sorry so much, your original mail was lost or so.
Yes, doing a 1.0 * (select...) will help
or the next version of the kernel (>= 7.5.00.24).
see http://pts:1080/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1133523

Sorry to let you wait that long.

Elke
SAP Labs Berlin
> 
> --
> Edson Carlos Ericksson Richter
> MGR Informática Ltda.
> Fones: 3347-0446 / 9259-2993
> 


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx