From: misiaq
Date: February 15 2013 8:32am
Subject: Re: MySQL 5.1: incorrect arithmetic calculation
List-Archive: http://lists.mysql.com/mysql/228983
Message-Id: <yrbspldoyxslhssludbq@oiwv>
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable



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

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

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

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

Regards,
m