MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: Sum of doubles giving incorrect value
Posted by: Peter Brawley
Date: January 04, 2011 01:37PM

Quote

I know it's almost 0, but that's gotta be a bug, right?

Wrong. Floating point numbers have rounding errors, so should never be used where exactness is required.

Use DECIMAL.

PB

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Sum of doubles giving incorrect value
Matthew Jenkins
January 04, 2011 12:18PM
Re: Sum of doubles giving incorrect value
Matthew Jenkins
January 04, 2011 12:31PM
Re: Sum of doubles giving incorrect value
Peter Brawley
January 04, 2011 01:37PM
Re: Sum of doubles giving incorrect value
Matthew Jenkins
January 04, 2011 01:42PM
Re: Sum of doubles giving incorrect value
Peter Brawley
January 04, 2011 01:55PM
Re: Sum of doubles giving incorrect value
Rick James
January 04, 2011 11:13PM
Re: Sum of doubles giving incorrect value
Matthew Jenkins
January 05, 2011 03:52AM
Re: Sum of doubles giving incorrect value
Rick James
January 05, 2011 09:28AM
Re: Sum of doubles giving incorrect value
Matthew Jenkins
January 05, 2011 10:43AM
Re: Sum of doubles giving incorrect value
Rick James
January 06, 2011 12:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.