ROUND discrepancy

[Chris Thorley]

Why don’t these two mysql operations give me the same answer.


##### Operation 1 - SQL #####

SELECT ROUND(2.56789, 2) FROM DUAL;

Gives Answer = 2.57


##### Operation 2 - Function #####

BEGIN
DECLARE r FLOAT;
SET r = ROUND(2.56789, 2);
RETURN r;
END

Gives Answer = 2.5699999332428

Just wanted your take on this.

Thanks
Chris