Bug #86126 unclear error message for nowait
Submitted: 28 Apr 2017 7:25 Modified: 9 May 2017 13:08
Reporter: Martin Hansson Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S3 (Non-critical)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any

[28 Apr 2017 7:25] Martin Hansson 
Description:
The error message for a FOR UPDATE NOWAIT query encountering a locked row reads:

ERROR HY000: Do not wait for lock.

This message is way too brief and is grammatically incorrect.

How to repeat:
SELECT * FROM t1 FOR UPDATE NOWAIT;
ERROR HY000: Do not wait for lock.

Suggested fix:
Change the error message to something informative, using correct English.
[9 May 2017 13:08] Paul DuBois 
Posted by developer:
 
Fixed in 8.0.2.

Cosmetic change. No changelog entry needed.

Well, perhaps a little more than cosmetic. But I still judge no changelog entry needed. :-)