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

[james wang]

1). mysql> create table testfloat (f1 float default null, f2 float default null);
2). mysql> insert into testfloat (f1) values (0.0052);
3). mysql> insert into testfloat (f2) values (0.0032);
4). mysql> select ifnull(f1,f2) from testfloat;
+-----------------------+
| ifnull(f1,f2) |
+-----------------------+
| 0.005200000014156103 |
| 0.0031999999191612005 |
+-----------------------+