Take a look at http://speleotrove.com/decimal/ for a workaround
On Thu, Sep 23, 2010 at 2:06 PM, simpleLinux <2fz...@gmail.com> wrote: > Have you reported this bug to the Community? > > On Sun, Sep 5, 2010 at 1:18 PM, Walter Heck - OlinData.com < > walterh...@olindata.com> wrote: > >> Yep, that is why MySQL for instance has the data type NUMERIC/DECIMAL >> as opposed to FLOAT and DOUBLE (See: >> http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html) >> Also, a lot of programming languages have special datatypes used for >> storing financial values as they are particularly nasty for rounding >> errors. Never seen a 0.01 cent difference when Adding a number of >> items on an invoice programmatically? >> >> Walter >> >> On Sun, Sep 5, 2010 at 12:37, Aizuddin a.k.a ak47suk1 >> <kaibatheleg...@gmail.com> wrote: >> > Hmmm... >> > >> > Tested on my lappy, AMD Turion64 X2, Ubuntu Lucid Lynx 64-bit. >> > >> > OpenOffice Calc: >> > >> > Input: =161001.165-100000.009-60000.7-1000.456 >> > Output: 0.00000000000557065504835919 >> > >> > Input: =161001.165+(-100000.009-60000.7-1000.456) >> > Output: 0 >> > >> > Input: =((161001.165-100000.009)-60000.7)-1000.456 >> > Output: 0.00000000000557065504835919 >> > >> > MySQL: >> > >> > mysql> >> > mysql> CREATE TABLE `sumtest` ( >> > -> >> > -> `numbers` double NOT NULL, >> > -> >> > -> `group` varchar(3) NOT NULL DEFAULT 'all' >> > -> >> > -> ); >> > Query OK, 0 rows affected (0.14 sec) >> > >> > mysql> >> > mysql> >> > mysql> >> > mysql> INSERT INTO `sumtest` (`numbers`, `group`) VALUES >> > -> >> > -> (161001.165, 'all'), >> > -> >> > -> (-100000.009, 'all'), >> > -> >> > -> (-60000.7, 'all'), >> > -> >> > -> (-1000.456, 'all'); >> > Query OK, 4 rows affected (0.10 sec) >> > Records: 4 Duplicates: 0 Warnings: 0 >> > >> > mysql> >> > mysql> >> > mysql> >> > mysql> SELECT SUM( `numbers` ) >> > -> >> > -> FROM `sumtest` >> > -> >> > -> WHERE `group` = 'all' >> > -> >> > -> GROUP BY `group`; >> > +----------------------+ >> > | SUM( `numbers` ) | >> > +----------------------+ >> > | 5.57065504835919e-12 | >> > +----------------------+ >> > 1 row in set (0.04 sec) >> > >> > >> > 2010/9/5 Raja Iskandar Shah <rajaiskand...@gmail.com> >> >> >> >> cool ;-) >> >> >> >> i wonder if the bug is identical across all 32bit and 64bit cpu ? or >> intel >> >> treats them differently than amd, than sunsparc, than arm ? >> >> >> >> >> >> On Sun, Sep 5, 2010 at 10:55 AM, Walter Heck - OlinData.com >> >> <walterh...@olindata.com> wrote: >> >>> >> >>> Usually the programming languages used for those kind of programs have >> >>> their own datatypes for ultra-high precision floating points. A 32 or >> >>> 64 bit datatype is not enough for them anyway. They use all kinds of >> >>> tricks/smart-assing to get around floating point rounding errors. >> >>> >> >>> Walter >> >> >> >> -- >> >> Join Open Source Developers Club Malaysia http://www.osdc.my/ >> >> >> >> Facebook Fan page >> >> >> >> http://www.facebook.com/group.php?gid=98685301577 >> >> >> >> http://www.facebook.com/OSDC.my >> >> >> >> You received this message because you are subscribed to the Google >> >> >> >> Groups "OSDC.my Mailing List" group. >> >> To post to this group, send email to osdcmy-list@googlegroups.com >> >> To unsubscribe from this group, send email to >> >> osdcmy-list+unsubscr...@googlegroups.com<osdcmy-list%2bunsubscr...@googlegroups.com> >> >> For more options, visit this group at >> >> http://groups.google.com/group/osdcmy-list?hl=en >> > >> > -- >> > Join Open Source Developers Club Malaysia http://www.osdc.my/ >> > >> > Facebook Fan page >> > >> > http://www.facebook.com/group.php?gid=98685301577 >> > >> > http://www.facebook.com/OSDC.my >> > >> > You received this message because you are subscribed to the Google >> > >> > Groups "OSDC.my Mailing List" group. >> > To post to this group, send email to osdcmy-list@googlegroups.com >> > To unsubscribe from this group, send email to >> > osdcmy-list+unsubscr...@googlegroups.com<osdcmy-list%2bunsubscr...@googlegroups.com> >> > For more options, visit this group at >> > http://groups.google.com/group/osdcmy-list?hl=en >> >> >> >> -- >> Walter Heck >> Founder @ OlinData (http://olindata.com) >> >> -- >> Join Open Source Developers Club Malaysia http://www.osdc.my/ >> >> Facebook Fan page >> >> http://www.facebook.com/group.php?gid=98685301577 >> >> http://www.facebook.com/OSDC.my >> >> You received this message because you are subscribed to the Google >> >> Groups "OSDC.my Mailing List" group. >> To post to this group, send email to osdcmy-list@googlegroups.com >> To unsubscribe from this group, send email to >> osdcmy-list+unsubscr...@googlegroups.com<osdcmy-list%2bunsubscr...@googlegroups.com> >> For more options, visit this group at >> http://groups.google.com/group/osdcmy-list?hl=en >> > > > > -- > Fariz Luqman > The Chairman of SimpleLinux > Visit: http://www.simplelinux.tk > > "There IS a Malaysian Linux Distro" > > > -- > Join Open Source Developers Club Malaysia http://www.osdc.my/ > > Facebook Fan page > > http://www.facebook.com/group.php?gid=98685301577 > > http://www.facebook.com/OSDC.my > > You received this message because you are subscribed to the Google > > Groups "OSDC.my Mailing List" group. > To post to this group, send email to osdcmy-list@googlegroups.com > To unsubscribe from this group, send email to > osdcmy-list+unsubscr...@googlegroups.com<osdcmy-list%2bunsubscr...@googlegroups.com> > For more options, visit this group at > http://groups.google.com/group/osdcmy-list?hl=en -- Join Open Source Developers Club Malaysia http://www.osdc.my/ Facebook Fan page http://www.facebook.com/group.php?gid=98685301577 http://www.facebook.com/OSDC.my You received this message because you are subscribed to the Google Groups "OSDC.my Mailing List" group. To post to this group, send email to osdcmy-list@googlegroups.com To unsubscribe from this group, send email to osdcmy-list+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/osdcmy-list?hl=en
