Details
-
Type:
Task
-
Status: Open (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
Description
As being discussed in MDEV-13115. It would be great if the UPDATE syntax would allow for the SKIP LOCKED instruction similar on how it's implemented for SELECT * FROM x FOR UPDATE SKIP LOCKED.
For example:
UPDATE tableX SET col1=1 SKIP LOCKED
|
Which would update all records in tableX which rows aren't currently locked.
Attachments
Issue Links
- relates to
-
MDEV-13115 Implement SELECT [FOR UPDATE|LOCK IN SHARED MODE] SKIP LOCKED
-
- Closed
-