Double add double get wrong result

[yangjiajun]

Hello.I do simple add operation but get wrong result.

Here is a reproduce step:

CREATE TABLE PUBLIC.TEST (
        A DOUBLE,
        B DOUBLE,
        K VARCHAR,
        CONSTRAINT K PRIMARY KEY (K)
);

INSERT INTO test(A,B,K)values(-11674.46,11674.67,'1')

SELECT to_char(A+B) FROM test

The result:.21000000000094587.But it obviously should be .21.

Do u have any ideas about this?



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/