Bug #14779 round(100.5) return 100
Submitted: 9 Nov 2005 8:14 Modified: 15 Dec 2005 13:24
Reporter: ArPin Su Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.26-log OS:FreeBSD (FreeBSD port: mysql-server-4.0.2)
Assigned to: CPU Architecture:Any

[9 Nov 2005 8:14] ArPin Su 
Description:
mysql> select round(100.5);
+--------------+
| round(100.5) |
+--------------+
|          100 |
+--------------+
1 row in set (0.00 sec)

mysql> select round(101.5);
+--------------+
| round(101.5) |
+--------------+
|          102 |
+--------------+
1 row in set (0.00 sec)

mysql> select round(1000.5);
+---------------+
| round(1000.5) |
+---------------+
|          1000 |
+---------------+
1 row in set (0.00 sec)

How to repeat:
english is very bad.. so ....

Suggested fix:
english is very bad.. so ....
[15 Dec 2005 12:45] Aleksey Kishkin 
it doesn't look loke feature request but rather as bug report. Changing Severity to S3
[15 Dec 2005 13:24] Valeriy Kravchuk 
Thank you for a problem report. It is a duplicate of http://bugs.mysql.com/bug.php?id=10515 (and many more reports). Please, read the explanation there.