Bug #114945 Some added reserved words not shown in Manual
Submitted: 9 May 2024 14:32 Modified: 29 Aug 2024 23:52
Reporter: Jay Yuan Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: Documentation Bug

[9 May 2024 14:32] Jay Yuan
Description:
Words ROW and ROWS are shown on https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-8-0-detailed-R  as added reserved words for Mysql 8.0:
ROW (R); became reserved in 8.0.2
ROWS (R); became reserved in 8.0.2

Yet these two words are not listed as Mysql 8.0 added reserved words on https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-new-in-current-series.  I copy all add reserved and keywords for R as follows in which I expect these two words should have been there : 

R
RANDOM
RANK (R)
RECURSIVE (R)
REFERENCE
REGISTRATION
REPLICA
REPLICAS
REQUIRE_ROW_FORMAT
RESOURCE
RESPECT
RESTART
RETAIN
RETURNING
REUSE
ROLE
ROW_NUMBER (R)

How to repeat:
It is repeatable by checking the Mysql 8.0 documentation.
[9 May 2024 14:36] MySQL Verification Team
HI Mr. Yuan,

Thank you for your bug report.

This is a small bug in our documentation, but still a bug.

Verified as reported.

Thank you for your contribution.
[29 Aug 2024 23:52] Jon Stephens
Not a bug.

ROW and ROWS have been keywords since MySQL 3.23.58.

They became *reserved* keywords in MySQL 8.0.2.

Thus the information on the indicated page is correct.

Thanks for using MySQL!
[16 Sep 2024 9:43] MySQL Verification Team
Thank you, Jon.