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

Selecting from SEQUENCE table with negative number hangs server

Description

This command causes the connection to hang:

1 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.

1 2 3 4 5 6 7 8 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)

Environment

mariadb-10.0.8-linux-x86_64 from tarball on CentOS 6.5

Status

Assignee

Sergei Golubchik

Reporter

Kolbe Kegel

Labels

None

External issue ID

None

External issue ID

None

Fix versions

Affects versions

10.0.8

Priority

Major