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.
SUM overflow?
Hello,
I have tried for it , it really has this problem.
I created CR 107,510.
Thanks.