Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
5.5.33
-
None
-
None
-
None
-
VMware Workstation, Fedora Core 19 vanilla install
mysql Ver 15.1 Distrib 5.5.32-MariaDB, for Linux (x86_64) using readline 5.1
Description
SELECT SLEEP(4), ID FROM Region; |
The above statement hangs indefinitely instead of 4 seconds like intended.
EXPLAIN also doesn't show too much information.
EXPLAIN SELECT SLEEP(4), ID FROM Region; |
+------+-------------+--------+-------+---------------+---------+---------+------+------+-------------+ |
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | |
+------+-------------+--------+-------+---------------+---------+---------+------+------+-------------+ |
| 1 | SIMPLE | Region | index | NULL | PRIMARY | 4 | NULL | 1 | Using index | |
+------+-------------+--------+-------+---------------+---------+---------+------+------+-------------+ |
|
|
SHOW CREATE TABLE Region output: |
|
|
CREATE TABLE `Region` ( |
`ID` int(11) NOT NULL AUTO_INCREMENT, |
`Name` varchar(45) COLLATE utf8_unicode_ci NOT NULL, |
PRIMARY KEY (`ID`) |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |