Like in any language, a FLOAT has complicated semantics for precision. This sometimes causes stored numbers to be slightly off their original value.
Please consider using DECIMAL instead. Decimals have well-defined behavior for rounding and range overflows.
Posted by Henning Koch to makandra dev (2014-02-24 11:51)