I wonder if it is only question of configuration but my MySQL server has
problems with suming of float values.
Look at that script:
# mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
# ----------------------
create table ft (id INT AUTO_INCREMENT, val FLOAT, PRIMARY KEY(id));
insert ft(val) values('3.4');
insert ft(val) values('0.3');
insert ft(val) values('1.24');
select * from ft;
select sum(val) from ft;
-----------------------------
It will generate this (at the end) :
...
mysql> select sum(val) from ft;
+-----------------+
| sum(val) |
+-----------------+
| 4.9400001168251 | <------------
??????????????????????????????????????????
+-----------------+
1 row in set (0.00 sec)
-----------------------------
Is it repeatable in someone else's MySQL server ?
Wojtek Drazek
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
