I have several double precision columns in a table and a select on a server running 5.1.63 would return a number like 12.0. I upgraded to the latest Percona 5.5 (5.5.27-28.0 at the time), same hardware, and the select now returns 12.00000001. Why would this be the case? I understand floating point cannot represent certain numbers, but would expect the stored value to be represented the same way on both distributions.
No announcement yet.
double precision column returning different values after upgrade to 5.5