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

[3 Dec 2013 3:25] Ryusuke Kajiyama
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
[3 Dec 2013 4:55] Umesh Shastry
Hello Kajiyama,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh
[3 Dec 2013 4:58] Umesh Shastry
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.
[3 Dec 2013 5:30] Umesh Shastry
// 5.7.3-m13 is also affected
[9 Dec 2013 15:17] Paul Dubois
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.