[MDEV-25388] SKIP LOCKED should skip table level locked Created: 2021-04-12 Updated: 2021-05-18 Resolved: 2021-05-18 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Locking |
| Affects Version/s: | None |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Daniel Black | Assignee: | Daniel Black |
| Resolution: | Incomplete | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
A thread doing table level locking - LOCK TABLES or ALTER TABLES and if another thread is doing SELECT ... SKIP LOCKED then these entire tables should be skipped. |
| Comments |
| Comment by Daniel Black [ 2021-04-19 ] |
|
Asked for user feedback in |
| Comment by Daniel Black [ 2021-05-18 ] |
|
current behaviour matches MySQL, table level locks are still locks and SKIPPED LOCKED will still lockwait on a table level lock. Please state the case if you think a different behaviour is better. |