Bug #9514 Provide a way to select a lock status of a row or rows
Submitted: 31 Mar 2005 7:49 Modified: 8 Aug 2005 0:25
Reporter: Lachlan Mulcahy
Status: Verified
Category:Server: InnoDB Severity:S4 (Feature request)
Version:4.1 OS:Any (Any)
Assigned to: Heikki Tuuri Target Version:
Triage: Triaged: D5 (Feature request)

[31 Mar 2005 7:49] Lachlan Mulcahy 
Description:
The customer would like a feature which allows them to check the lock status of a record
without waiting for the lock wait timeout to expire.

Eg. SELECT ... FOR UPDATE NOWAIT;

or.

Eg. SELECT LOCK_STATUS(id) FROM t1 WHERE id=1;

Could return 1 for the record is locked and 1 otherwise.

How to repeat:
N/a

Suggested fix:
n/a
[4 Apr 2005 7:32] Heikki Tuuri 
Hi!

Jan should implement NOWAIT locks for InnoDB.

Regards,

Heikki
[25 Oct 2006 22:16] Daniel Liljebaldh 
Yes we would like to have the NOWAIT functionality. MSSQL and Oracle have it so MySQL
should also have it!
[19 Mar 21:54] Bob Hansen 
We would like to have it too. Thanks.