Details
-
Type:
Bug
-
Status: Closed
-
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)
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
I don't think it actually hangs, it just selects from 18446744073709551615 to 10 which isn't going to be easy for the client.
Aha! You're right of course. I would've seen that immediately if I'd been running the client with --quick. Sorry for the confusion!
It'd be neat if the SEQUENCE engine simply supported sequences that included negative values