clear markdown compare help donate or buy diddy dollings comments/suggestions/bugs a leap of faith? bible365
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 582796 fiddles created (13395 in the last week).

create table t ( f1 numeric(10,3), f2 numeric(10,3), f3 numeric(10,3), f4 numeric(10,3) )
 hidden batch(es)


insert into t values ( 60, 60, 60, 60 );
1 rows affected
 hidden batch(es)


select * from t;
F1 F2 F3 F4
60.000 60.000 60.000 60.000
 hidden batch(es)


select f1*f2*f3 as product from t union all select f1*f2*f3*(cast (1 as integer)) as product from t union all select f1*f2*f3*f4 as product from t union all select f1*f2*f3*f4 as product from t;
PRODUCT
216000.000000000000
216000.000000000000
Integer overflow. The result of an integer operation caused the most significant bit of the result to carry.
 hidden batch(es)


select f1*f2*f3*f4 as product from t union all select f1*f2*f3 as product from t union all select f1*f2*f3*(cast (1 as integer)) as product from t union all select f1*f2*f3*f4 as product from t;
PRODUCT
Integer overflow. The result of an integer operation caused the most significant bit of the result to carry.
 hidden batch(es)