|
|
|
A query was returning the wrong numeric value. After running the following commands:
CREATE TABLE MYNUM(fld NUMERIC(10,3));
INSERT INTO MYNUM VALUES(-0.003);
INSERT INTO MYNUM VALUES(0.003);
SELECT TRUNCATE(fld,0) FROM MYNUM;
The following was incorrectly returned:
TRUNCATE(FLD,
-------------
:.0000000E+125
-:.000000E+125
2 records selected
Truncate logic has been updated to correct this error.
