Hello!

I have few servers with Firebird versions. On some servers live
version 2.0.4 on others 2.1.0

I need to round one column with precision 4 digits. It is done via
trigger. Column is defined as DOUBLE PRECISION

On 2.1.0 I do
new.TOTAL = ROUND(new.TOTAL, 4);

On 2.0.4 I do
new.TOTAL = ROUND(CAST(new.TOTAL * 10000 AS INTEGER)) / 10000;

Both worked fine till today new.TOTAL hit 1482835105.6 in one row,
which gave me 0.0000 on v2.1.0 and `arithmetic exception, numeric
overflow, or string truncation` on v2.0.4

Someone may test it
v2.1.0
SELECT ROUND(1482835105.6, 4)
FROM RDB$DATABASE

v.2.0.4
SELECT ROUND(CAST(1482835105.6 * 10000 AS INTEGER)) / 10000
FROM RDB$DATABASE

My question is - how to round such large numbers?

Thank you!