limit-locking.test
[MDEV-25244] SELECT .. FOR UPDATE NOWAIT doesn't error with another connection (SELECT * FROM t1 FOR UPDATE) LIMIT 1 Created: 2021-03-24 Updated: 2023-04-14 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Locking |
| Affects Version/s: | 10.3.28, 10.6 |
| Fix Version/s: | 10.6 |
| Type: | Bug | Priority: | Major |
| Reporter: | Daniel Black | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | not-10.2 | ||
| Attachments: |
limit-locking.test
|
| Description |
|
With (SELECT * FROM t1 FOR UPDATE) LIMIT 1; In one connection another connection SELECT * FROM t1 FOR UPDATE NOWAIT fails to ER_LOCK_WAIT_TIMEOUT test from https://github.com/mysql/mysql-server/commit/04059bab88cabf3d694cf04bee59d124ec068192 (with lock error mapped to MariaDB) |