Toad World® Forums

SUM overflow?


#1

Toadforsybase 1.3 and 1.4beta

declare @num1 numeric(11, 2), @num2 numeric(12,2)
select @num1 = 5.5, @num2 = 10.0
select @num1 * @num2
select sum(@num1 * @num2)

the sum function not working if the scale is larger than 11. Interactive SQL works.


#2

Hello,

I have tried for it , it really has this problem.
I created CR 107,510.

Thanks.