MySQL Bugs: #10515: round function

Bug #10515	round function
Submitted:	10 May 2005 14:57	Modified:	10 May 2005 15:22
Reporter:	trogir	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	4.0.24	OS:	Linux (Linux Slackware 10.1 (current))
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
round function sometimes up and sometimes down number.
For :
SELECT round( 1.425, 2 ) , round( 5.555, 2 ) 
I have got 
1.42  	5.56

How to repeat:
SELECT round( 1.425, 2 ) , round( 5.555, 2 )

Currently this an expected behavior when handling float point numbers.
Regarding issues with float point number you can read:

http://dev.mysql.com/doc/mysql/en/problems-with-float.html