Re: AW: sum is rounding values when subquerying

Thank you so much,

(BTW, the link 
http://pts:1080/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1133523 points 
to a internal server?!)

Edson Richter



Zabach, Elke escreveu:

> 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
> >
> >    
>
>
>
>  


--
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