Hi Wang,
select 9000000000000.10*19.80 wrong result 178200000000001.97
if <= 900000000000.10*19.80 right result 17820000000001.98
This is similiar to sum(qty*unitpri) result .
Welcome to the world of floating point arithmetic. If you need such
precision, try MySQL 5.0, as it should be capable of doing that
calculation using its new precision math support.
Regards,
Jeremy
--
Jeremy Cole
MySQL Geek, Yahoo! Inc.
Desk: 408 349 5104
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
