Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.0.8
-
Fix Version/s: 10.0.9
-
Component/s: None
-
Labels:None
-
Environment:mariadb-10.0.8-linux-x86_64 from tarball on CentOS 6.5
Description
This command causes the connection to hang:
select * from `seq_-1_to_10`; |
It is possible for other threads to connect to the server, but the thread executing the SELECt statement is hung.
mysql 10.0.8-MariaDB (root) [test] db1> show processlist;
|
+----+------+-----------+------+---------+------+----------------+------------------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+----+------+-----------+------+---------+------+----------------+------------------------------+----------+
|
| 2 | root | localhost | test | Query | 154 | Writing to net | select * from `seq_-1_to_10` | 0.000 |
|
| 3 | root | localhost | test | Query | 0 | init | show processlist | 0.000 |
|
+----+------+-----------+------+---------+------+----------------+------------------------------+----------+
|
2 rows in set (0.01 sec)
|