[MDEV-5735] Selecting from SEQUENCE table with negative number hangs server Created: 2014-02-25  Updated: 2014-03-04  Resolved: 2014-03-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.8
Fix Version/s: 10.0.9

Type: Bug Priority: Major
Reporter: Kolbe Kegel (Inactive) Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
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)



 Comments   
Comment by Kolbe Kegel (Inactive) [ 2014-02-25 ]

It'd be neat if the SEQUENCE engine simply supported sequences that included negative values

Comment by Elena Stepanova [ 2014-02-25 ]

I don't think it actually hangs, it just selects from 18446744073709551615 to 10 which isn't going to be easy for the client.

Comment by Kolbe Kegel (Inactive) [ 2014-02-25 ]

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!

Generated at Thu Feb 08 07:06:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.