Bug #12256 Mysql 5.0.7 Function ceiling() and ceil()

• Submitted: 29 Jul 2005 1:40
• Modified: 29 Jul 2005 2:05
• Reporter: stangly wrong
• Status: Closed
• Category: MySQL Server
• Severity: S2 (Serious)
• OS: Windows (Windows Server 2003)
• CPU Architecture: Any

[29 Jul 2005 1:40] stangly wrong

Description:
Hi  !

I find a bug in mysql 5.0.7 !

I get a result is 2 when I use ceiling(121/2), but it's run ok on Mysql 4.0.x Server ! 

============== Mysql 5.0.7 =======================
mysql> select ceiling(121/60);
+-----------------+
| ceiling(121/60) |
+-----------------+
|               2 |
+-----------------+
1 row in set (0.00 sec)

==============Mysql 4.0.x ========================
mysql> select ceiling(121/60);
+-----------------+
| ceiling(121/60) |
+-----------------+
|               3 |
+-----------------+
1 row in set (0.00 sec)

How to repeat:
============== Mysql 5.0.7 =======================
mysql> select ceiling(121/60);
+-----------------+
| ceiling(121/60) |
+-----------------+
|               2 |
+-----------------+
1 row in set (0.00 sec)

==============Mysql 4.0.x ========================
mysql> select ceiling(121/60);
+-----------------+
| ceiling(121/60) |
+-----------------+
|               3 |
+-----------------+
1 row in set (0.00 sec)

[29 Jul 2005 2:05] MySQL Verification Team

Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

Additional info:

c:\mysql\bin>mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.10a-beta-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select ceiling(121/60);
+-----------------+
| ceiling(121/60) |
+-----------------+
|               3 |
+-----------------+
1 row in set (0.08 sec)

mysql>