MySQL Forums
Forum List  »  Quality Assurance

POW returns different results on different versions of MySQL
Posted by: Brad Jauron
Date: May 30, 2013 08:32AM

Have two MySQL servers one is running 5.0.86 the other is running 5.528

On MySQL 5.0: SELECT 47050 *POW(10,(-3)); returns 47.05

On MySQL 5.5: SELECT 47050 *POW(10,(-3)); returns 47.050000000000004

Just curious if anyone has seen this before, or know what might cause it.

Thanks,
Brad

Options: ReplyQuote


Subject
Views
Written By
Posted
POW returns different results on different versions of MySQL
3095
May 30, 2013 08:32AM


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.