Re: Percona MySQL 5.5 and 5.6 IFNULL function changes float data precision

[Peter Brawley]

All I see is normal float rounding junk ...

select f1,f2,ifnull(f1,f2) from testfloat;
+--------+--------+-----------------------+
| f1     | f2     | ifnull(f1,f2)         |
+--------+--------+-----------------------+
| 0.0052 |   NULL |  0.005200000014156103 |
|   NULL | 0.0032 | 0.0031999999191612005 |
+--------+--------+-----------------------+

Usually we hide such with Round().