clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
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. 1044295 fiddles created (9425 in the last week).

select rdb$get_context('SYSTEM', 'ENGINE_VERSION') as version from rdb$database;
VERSION
3.0.5
 hidden batch(es)


recreate table t58096187 ( f1 numeric(10,4), f2 numeric(10,4), f3 numeric(10,4), f4 numeric(10,4) )
 hidden batch(es)


insert into t58096187 values ( 50, 50, 50, 50 )
1 rows affected
 hidden batch(es)


select RDB$GET_CONTEXT('SYSTEM','ENGINE_VERSION') from rdb$database
RDB$GET_CONTEXT
3.0.5
 hidden batch(es)


select coalesce(F1, 0) * coalesce(F2, 0) * ((100 - coalesce(F3, 0)) / 100) * ((100 + coalesce(F4, 0)) / 100) from t58096187
MULTIPLY
Integer overflow. The result of an integer operation caused the most significant bit of the result to carry.
 hidden batch(es)