Re: MySQL 5.1: incorrect arithmetic calculation

[misiaq]

From: "Alex Keda" <admin@stripped>
To: mysql@stripped; 
Sent: 6:37 Piątek 2013-02-15
Subject: MySQL 5.1: incorrect arithmetic calculation

( ... cut ...)
> 
> but, my desktop calculator gives the result 548.60
> 

1. your desktop calculator is wrong
2. correct result is 548.595, variations (548.59 and 548.594985) are related to various
data types and rounding related issues while multiplying and dividing by 100

http://dev.mysql.com/doc/refman/5.1/en/problems-with-float.html 

Regards,
m