Details
Minor Description
I know that passing a negative timeout to GET_LOCK() makes no sense. But if you do it by mistake (perhaps with dynamic sql) there are 2 cases:
- If the number is high, it is like passing 0:
MariaDB [(none)]> SELECT GET_LOCK('x', -100);+---------------------+| GET_LOCK('x', -100) |+---------------------+| 0 |+---------------------+1 row in set (0.01 sec) - if number is very low, it considers it as a positive number (you will need to kill the query):
SELECT GET_LOCK('x', -1500000000);In both cases, I get no errors or warnings.
Attachments
Issue Links
- links to
Activity
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Elena Stepanova [ elenst ] |
It's an upstream issue, except that in MySQL up to and including 5.6 even GET_LOCK('x', -10) hangs seemingly forever (as well as in MariaDB 5.1/5.2).
| Fix Version/s | 10.1.0 [ 12200 ] | |
| Affects Version/s | 5.1.66 [ 10801 ] | |
| Affects Version/s | 5.2.13 [ 10800 ] | |
| Affects Version/s | 5.3.11 [ 11700 ] | |
| Affects Version/s | 5.5.28a [ 11701 ] | |
| Affects Version/s | 10.0.0 [ 10000 ] | |
| Assignee | Elena Stepanova [ elenst ] | |
| Labels | upstream |
| Description |
I know that passing a negative timeout to GET_LOCK() makes no sense. But if you do it by mistake (perhaps with dynamic sql) there are 2 cases: * If the number is high, it is like passing 0: MariaDB [(none)]> SELECT GET_LOCK('x', -100); +---------------------+ | GET_LOCK('x', -100) | +---------------------+ | 0 | +---------------------+ 1 row in set (0.01 sec) * if number is very low, it considers it as a positive number (you will need to kill the query): SELECT GET_LOCK('x', -1500000000); In both cases, I get no errors or warnings. |
I know that passing a negative timeout to GET_LOCK() makes no sense. But if you do it by mistake (perhaps with dynamic sql) there are 2 cases: * If the number is high, it is like passing 0: {noformat} MariaDB [(none)]> SELECT GET_LOCK('x', -100); +---------------------+ | GET_LOCK('x', -100) | +---------------------+ | 0 | +---------------------+ 1 row in set (0.01 sec) {noformat} * if number is very low, it considers it as a positive number (you will need to kill the query): {noformat} SELECT GET_LOCK('x', -1500000000); {noformat} In both cases, I get no errors or warnings. |
| Fix Version/s | 5.5.38 [ 15400 ] | |
| Fix Version/s | 10.1.0 [ 12200 ] |
| Fix Version/s | 10.0.11 [ 15200 ] |
| Fix Version/s | 10.0.12 [ 15201 ] | |
| Fix Version/s | 10.0.11 [ 15200 ] |
| Fix Version/s | 5.5.39 [ 15800 ] | |
| Fix Version/s | 5.5.38 [ 15400 ] |
| Workflow | defaullt [ 25793 ] | MariaDB v2 [ 44275 ] |
| Fix Version/s | 10.0.13 [ 16000 ] | |
| Fix Version/s | 10.0.12 [ 15201 ] |
| Workflow | MariaDB v2 [ 44275 ] | MariaDB v3 [ 63775 ] |
| Assignee | Sergey Vojtovich [ svoj ] |
| Assignee | Sergey Vojtovich [ svoj ] | Alexander Barkov [ bar ] |
| Status | Open [ 1 ] | In Review [ 10002 ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Assignee | Alexander Barkov [ bar ] | Sergey Vojtovich [ svoj ] |
| Component/s | OTHER [ 10125 ] | |
| Fix Version/s | 10.0.21 [ 19406 ] | |
| Fix Version/s | 10.1.7 [ 19604 ] | |
| Fix Version/s | 5.5.45 [ 19405 ] | |
| Fix Version/s | 10.0 [ 16000 ] | |
| Fix Version/s | 5.5 [ 15800 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Remote Link | This issue links to "Github revision (Web Link)" [ 24204 ] |
| Workflow | MariaDB v3 [ 63775 ] | MariaDB v4 [ 146318 ] |
Of course the first case is ok, but I think that the second case (very low negatives considered as positive) is a bug.