On Thu, 13 Dec 2001, [iso-8859-2] Wojciech Drążek wrote: > > I wonder if it is only question of configuration but my MySQL server has > problems with suming of float values. > > 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'); > . . .
Same problem here viz: select sum(val) from ft; => 4.9400001168251 while select 3.4 + 0.3 + 1.24; => 4.94 According to a previous message on this forum today, there are known problems with the float type. Maybe this is one of them (in the function sum). -- , M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121 A M A D O Rua Campo Alegre, 823 fax 351+226003654 A L V E S P-4150-180 PORTO, Portugal mob 351+939354002 --------------------------------------------------------------------- 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