Bug #11184 | Round() wrong result | ||
---|---|---|---|
Submitted: | 8 Jun 2005 19:54 | Modified: | 8 Jun 2005 20:17 |
Reporter: | Michal Vrchota | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: User-defined functions ( UDF ) | Severity: | S3 (Non-critical) |
Version: | 4.1.12 | OS: | Any (all) |
Assigned to: | CPU Architecture: | Any |
[8 Jun 2005 19:54]
Michal Vrchota
[8 Jun 2005 20:17]
MySQL Verification Team
Please read: http://dev.mysql.com/doc/mysql/en/problems-with-float.html D:\dbs\4112\bin>mysql --defaults-file=d:\d:\dbs\4112\my.ini -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 5.0.6-beta-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select round(2.5); +------------+ | round(2.5) | +------------+ | 3 | +------------+ 1 row in set (0.05 sec) mysql>