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)
|
Bug
Major
