MySQL Bugs: #71054: `HELP SHOW` still contains removed statements

Bug #71054	`HELP SHOW` still contains removed statements
Submitted:	3 Dec 2013 3:25	Modified:	9 Dec 2013 15:17
Reporter:	Ryusuke Kajiyama	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Packaging	Severity:	S3 (Non-critical)
Version:	5.6.14, 5.7.3-m13	OS:	Any
Assigned to:	Paul DuBois	CPU Architecture:	Any

Description:
`HELP SHOW` contains some removed statements such as SHOW AUTHORS
 and SHOW CONTRIBUTORS.
This is related to #54089

Reference manual is properly saying "This statement is removed as of MySQL 5.6.8."
http://dev.mysql.com/doc/refman/5.6/en/show-authors.html

How to repeat:
mysql> SELECT VERSION();
+-----------+
| VERSION() |
+-----------+
| 5.6.14    |
+-----------+
1 row in set (0.00 sec)

mysql> HELP SHOW;
Name: 'SHOW'
Description:
SHOW has many forms that provide information about databases, tables,
columns, or status information about the server. This section describes
those following:

SHOW AUTHORS
SHOW {BINARY | MASTER} LOGS
SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count]
SHOW CHARACTER SET [like_or_where]
SHOW COLLATION [like_or_where]
SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [like_or_where]
SHOW CONTRIBUTORS
SHOW CREATE DATABASE db_name
SHOW CREATE EVENT event_name
<snip>

Suggested fix:
Remove those removed statements from result of HELP SHOW

Hello Kajiyama,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh

How to repeat:

// GA - 5.6.14

mysql> select version();
+-------------------------------------------+
| version()                                 |
+-------------------------------------------+
| 5.6.14-enterprise-commercial-advanced-log |
+-------------------------------------------+
1 row in set (0.00 sec)

mysql> HELP SHOW;
Name: 'SHOW'
Description:
SHOW has many forms that provide information about databases, tables,
columns, or status information about the server. This section describes
those following:

SHOW AUTHORS
.
SHOW CONTRIBUTORS
<snip>
.
.

// Statement no longer works

mysql> SHOW AUTHORS;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AUTHORS' at line 1

mysql> SHOW CONTRIBUTORS;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONTRIBUTORS' at line 1

Imho, these statements are deprecated as of MySQL 5.5.29 and are removed in MySQL 5.6 and hence it is not longer recognized.
So, `HELP SHOW` should not show deprecated/removed statements.

// 5.7.3-m13 is also affected

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

Content for the HELP command for MySQL 5.6.x is generated from the 5.6 manual. That is, it is specific to a particular release series, not a particular version within the series. The 5.6 HELP content will continue to include entries for SHOW AUTHORS and SHOW CONTRIBUTORS as long as new 5.6 releases are issued, because the 5.6 manual includes entries for those statements.

If you run HELP SHOW AUTHORS or HELP SHOW CONTRIBUTORS, the result indicates that these statements are removed, and in what version:

mysql> help show authors
Name: 'SHOW AUTHORS'
Description:
Syntax:
SHOW AUTHORS

The SHOW AUTHORS statement displays information about the people who
work on MySQL. For each author, it displays Name, Location, and Comment
values.

This statement is removed as of MySQL 5.6.8.

URL: http://dev.mysql.com/doc/refman/5.6/en/show-authors.html

mysql> help show contributors
Name: 'SHOW CONTRIBUTORS'
Description:
Syntax:
SHOW CONTRIBUTORS

The SHOW CONTRIBUTORS statement displays information about the people
who contribute to MySQL source or to causes that we support. For each
contributor, it displays Name, Location, and Comment values.

This statement is removed as of MySQL 5.6.8.

URL: http://dev.mysql.com/doc/refman/5.6/en/show-contributors.html

However, the 5.7 manual still contained some remaining traces of those two statements, and it should not. I have now removed those from the 5.7 manual, and the HELP content will contain no reference to them for the next MySQL 5.7 release. Thanks for pointing this out.