Bug #100982 Official website description error
Submitted: 29 Sep 2020 3:30 Modified: 29 Sep 2020 15:56
Reporter: guotai liu Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.7 and 8.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: Official website description error

[29 Sep 2020 3:30] guotai liu 
Description:
I find an error description on the Official website.

URL: https://dev.mysql.com/doc/refman/5.7/en/innodb-consistent-read.html

Extract part of the content：

---
   If you want to see the “freshest” state of the database, use either the READ COMMITTED isolation level or a locking read:

SELECT * FROM t FOR SHARE;

---

How to repeat:

URL: https://dev.mysql.com/doc/refman/5.7/en/innodb-consistent-read.html
     https://dev.mysql.com/doc/refman/8.0/en/innodb-consistent-read.html
 
The content of "The InnoDB Storage Engine" -> "InnoDB Locking and Transaction Model" -> "InnoDB Transaction Model" -> "Consistent Nonlocking Reads"

Extract part of the content：

---
   If you want to see the “freshest” state of the database, use either the READ COMMITTED isolation level or a locking read:

SELECT * FROM t FOR SHARE;

---

Suggested fix:
Here the "FOR SHARE" is error description,It should be "LOCK IN SHARE MODE" or "FOR UPDATE".
[29 Sep 2020 4:45] MySQL Verification Team 
Hello guotai liu,

Thank you for the report.

regards,
Umesh
[29 Sep 2020 15:56] Daniel Price 
Posted by developer:
 
The referenced content in the MySQL 5.7 manual was corrected. The change should appear online soon.

Thank you for the bug report.