pbm with SUM - Edouard Vanbelle - com.mysql.lists.bugs

2 messages in com.mysql.lists.bugspbm with SUM

From	Sent On	Attachments
Edouard Vanbelle	15 Jul 2003 08:03
Alexander Keremidarski	15 Jul 2003 11:25

Subject:	pbm with SUM
From:	Edouard Vanbelle (ed...@ovh.net)
Date:	07/15/2003 08:03:33 AM
List:	com.mysql.lists.bugs

When I do:

mysql> select montant from virement_ordres; +---------+ | montant | +---------+ | 1234.4 | | 0.5 | +---------+ 2 rows in set (0.00 sec)

mysql> select sum(montant) from virement_ordres; +-----------------+ | sum(montant) | +-----------------+ | 1234.9000244141 | +-----------------+ 1 row in set (0.00 sec)

Is the error of rounding normal ?

For information, I'm using: Server version: 4.0.13-log The server is running under linux.

And "montant" is a float.

Best regards, Edouard.