Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.8
-
None
-
None
-
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)
|
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Fix Version/s | 10.0.9 [ 14400 ] |
| Assignee | Sergei Golubchik [ serg ] |
I don't think it actually hangs, it just selects from 18446744073709551615 to 10 which isn't going to be easy for the client.
| 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) |
This command causes the connection to hang: {code:sql} select * from `seq_-1_to_10`; {code} It is possible for other threads to connect to the server, but the thread executing the SELECt statement is hung. {noformat} 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) {noformat} |
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!
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | defaullt [ 34917 ] | MariaDB v2 [ 42530 ] |
| Workflow | MariaDB v2 [ 42530 ] | MariaDB v3 [ 61497 ] |
| Workflow | MariaDB v3 [ 61497 ] | MariaDB v4 [ 147546 ] |
It'd be neat if the SEQUENCE engine simply supported sequences that included negative values