Bug #71730 Help files list obsolete SHOW CONTRIBUTORS
Submitted: 15 Feb 2014 10:20 Modified: 15 Feb 2014 13:17
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.7.3-m13, 5.6.15 OS:Any
Assigned to: CPU Architecture:Any

[15 Feb 2014 10:20] Daniël van Eeden
Description:
The obsolete 'SHOW CONTRIBUTORS' command is still listed in the help files.

According to this page the command was removed in 5.6
https://dev.mysql.com/doc/refman/5.5/en/show-contributors.html

How to repeat:
mysql> pager grep CONTRIB
PAGER set to 'grep CONTRIB'
mysql> HELP SHOW
SHOW CONTRIBUTORS
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

Suggested fix:
Update the help files.
[15 Feb 2014 11:23] MySQL Verification Team
Hello Daniel,

Thank you for the report.
However, this issue has been addressed as part of Bug #71054. 

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.

// latest from trunk - As per change log, new release of 5.6 still list those

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

mysql> pager grep CONTRIB
PAGER set to 'grep CONTRIB'
mysql> HELP SHOW
SHOW CONTRIBUTORS
mysql>
mysql> help show contributors
Name: 'SHOW CONTRIBUTORS'
SHOW CONTRIBUTORS
The SHOW CONTRIBUTORS statement displays information about the people
mysql>
mysql> pager grep AUTHORS
PAGER set to 'grep AUTHORS'
mysql> HELP SHOW
SHOW AUTHORS
mysql> help show AUTHORS
Name: 'SHOW AUTHORS'
SHOW AUTHORS
The SHOW AUTHORS statement displays information about the people who

In the latest 5.7, I see it is no longer repeatable..

// 5.7.4 - This issue is fixed as part of Bug #71054

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

mysql> pager grep CONTRIB
PAGER set to 'grep CONTRIB'
mysql> HELP SHOW
mysql>
mysql> pager grep AUTHORS
PAGER set to 'grep AUTHORS'
mysql> HELP SHOW
mysql> help show AUTHORS

Nothing found
Please try to run 'help contents' for a list of all accessible topics

mysql> help show CONTRIBUTORS

Nothing found
Please try to run 'help contents' for a list of all accessible topics

Thanks,
Umesh
[15 Feb 2014 13:17] Daniël van Eeden
I consider this bug to be a dupliate of Bug #71054.