Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
Description
Summary:
|
--------
|
The feature provides a way to set lock wait timeout for some statement.
|
|
Usage:
|
------
|
1.select ... for update [wait [n]|no_wait]
|
2.select ... lock in share mode [wait [n]|no_wait]
|
3.lock table ... [wait [n]|no_wait]
|
|
no_wait: the query not wait for locks, instead of return immeditly, and print
|
"ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction;"
|
|
wait [n]: n is wait time in second, after wait n seconds for locks,
|
return and print errors;
|
https://github.com/alibaba/AliSQL/commit/d7764b5565e3f36e8e49d8bb2238da1a8459e94f
Attachments
Issue Links
- relates to
-
MDEV-25247 CREATE VIEW SELECT ... [NOWAIT|WAIT]
- Open