Re: ROUND discrepancy

[Jon Stephens]

Hi Chris,

In the first case, MySQL treats the value as exact (DECIMAL); in the second, you've declared it as an approximate type (FLOAT). MySQL does not store or handle the two sorts of numbers in quite the same way.

You might find Problems with Floating-Point Values, as well as the Manual sections on DECIMAL and FLOAT, to be relevant here.

cheers,

Jon Stephens
MySQL Documentation Team @ Oracle
Orlando, Florida, USA

MySQL Dev Zone
MySQL Server Documentation
Oracle