From: "Alex Keda" <ad...@lissyara.su> To: mysql@lists.mysql.com; 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql