| Subject | [FB 1.5] Integer Overflow bug? |
|---|---|
| Author | mk_delphi |
| Post date | 2005-01-04T13:58:24Z |
Try this:
CREATE TABLE TEST (
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
Marco
CREATE TABLE TEST (
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
Marco