Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.8
-
None
-
None
-
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)
|