We're updating the issue view to help you get more done.Learn more

Selecting from SEQUENCE table with negative number hangs server

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)

Status