Subject | Re: [firebird-support] [FB 1.5] Integer Overflow bug? |
---|---|
Author | Ivan Prenosil |
Post date | 2005-01-04T14:21:14Z |
> CREATE TABLE TEST (Resulting type of your multiplication is DECIMAL(18,12)
> V1 DECIMAL(18,4),
> V2 DECIMAL(18,4),
> V3 DECIMAL(18,4)
> );
>
> INSERT INTO TEST (V1, V2, V3) VALUES (10000000, 1, 1);
>
> SELECT V1*V2*V3 FROM TEST
>
> The select statement generate an unespected INTEGER OVERFLOW
(because you use exact numerics), and as you can see,
the value 10000000 does not fit in.
Ivan