Bug #14095 SLEEP() on Windows 2003 cannot handle fractional part

• Submitted: 18 Oct 2005 0:07
• Modified: 18 Oct 2005 2:20
• Reporter: Tobias Asplund
• Status: Can't repeat
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.13-rc
• OS: Windows (Windows 2003 Server)
• Assigned to: MySQL Verification Team
• CPU Architecture: Any

[18 Oct 2005 0:07] Tobias Asplund

Description:
SLEEP(1.5) should sleep for 1.5 seconds, not 15.

tigger> SELECT SLEEP(1.5);
+------------+
| SLEEP(1.5) |
+------------+
|          0 |
+------------+
1 row in set (15.52 sec)

tigger> SELECT SLEEP(1.5);
+------------+
| SLEEP(1.5) |
+------------+
|          0 |
+------------+
1 row in set (15.65 sec)

How to repeat:
SELECT SLEEP(1.5);

[18 Oct 2005 2:20] MySQL Verification Team

I was unable to repeat on Windows 2003 Server with latest Windows
BK source server:

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

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.16-nt

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

mysql> SELECT SLEEP(1.5);
+------------+
| SLEEP(1.5) |
+------------+
|          0 |
+------------+
1 row in set (2.38 sec)

mysql>

[18 Oct 2005 3:36] Tobias Asplund

What kind of hardware on that machine?

Mine's a Dual Opteron running 32-bit windows, wondering if that can have anything with this to do.