SELECT-UNION-SUM-ROUND question
Hi ,
Could someone please explain this strange behavior of the
SELECT statement :
create table double_test ( sel_key integer, charge float );
insert into double_test values( 2, 5.02);
insert into double_test values( 2, 6.064);
insert into double_test values( 1, 5.02);
insert into double_test values( 1, 6.064);
select sum( round(charge,<VAR>) )
from double_test where sel_key =1
union
select sum( charge )
from double_test where sel_key =2
VAR = 0 Results :
(sum)
11.00
11.08
VAR = 1 Results :
(sum)
11.10
11.08
VAR = 2 Results :
(sum)
11.08
11.08
VAR = 3 Results :
(sum)
11.08 ( only 1 row(s) retrieved. ?! )
VAR = 4 Results :
(sum)
11.08 ( only 1 row(s) retrieved. ?! )
I've checked it on 5.02.UC8 and 7.11.UC1( Solaris 2.4 ) and got
the same results.
I would expect different behavior.
Thanks in advance
Valery