List:General Discussion« Previous MessageNext Message »
From:misiaq Date:February 15 2013 8:32am
Subject:Re: MySQL 5.1: incorrect arithmetic calculation
View as plain text  

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


Thread
MySQL 5.1: incorrect arithmetic calculationAlex Keda15 Feb
  • Re: MySQL 5.1: incorrect arithmetic calculationJohan De Meersman15 Feb
    • Re: MySQL 5.1: incorrect arithmetic calculationAlex Keda15 Feb
      • Re: MySQL 5.1: incorrect arithmetic calculationAlex Keda15 Feb
        • Re: MySQL 5.1: incorrect arithmetic calculationJohan De Meersman15 Feb
  • Re: MySQL 5.1: incorrect arithmetic calculationmisiaq15 Feb
  • RE: MySQL 5.1: incorrect arithmetic calculationRick James21 Feb