Bug #105886 InnoDB support SELECT FOR UPDATE WAIT N
Submitted: 14 Dec 2021 1:30 Modified: 14 Dec 2021 4:18
Reporter: Shaohua Wang (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: Contribution

[14 Dec 2021 1:30] Shaohua Wang 
Description:
currently innodb support SELECT FOR UPDATE/SHARE SKIP LOCKED/NOWAIT, but it doesn't support WAIT N, which is a common request.

How to repeat:
https://dev.mysql.com/worklog/task/?id=3597
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-reads.html
[14 Dec 2021 1:31] Shaohua Wang 
Contributed patch

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: select_for_update_wait_n.patch (application/octet-stream, text), 34.60 KiB.
[14 Dec 2021 4:18] MySQL Verification Team 
Hello Shaohua,

Thank you for the report and contribution.

regards,
Umesh