Bug #47465 HELP SHOW lists outdated option
Submitted: 21 Sep 2009 0:56 Modified: 21 Sep 2009 5:08
Reporter: Roel Van de Paar (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:5.1.37 OS:Any
Assigned to: CPU Architecture:Any
Triage: Triaged: D4 (Minor)

[21 Sep 2009 0:56] Roel Van de Paar
Description:
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 [FULL] EVENTS
[...]

mysql> HELP SHOW EVENTS;
Name: 'SHOW EVENTS'
Description:
Syntax:
SHOW EVENTS [{FROM | IN} schema_name]
    [LIKE 'pattern' | WHERE expr]
[...]

--------

Notice '[FULL]' in 'HELP SHOW', which is not there in 'HELP SHOW EVENTS', nor in the manual:

'SHOW FULL EVENTS was removed in MySQL 5.1.12.'
http://dev.mysql.com/doc/refman/5.1/en/show-events.html

How to repeat:
HELP SHOW;

Suggested fix:
Remove '[FULL] ' from HELP SHOW help text.
[21 Sep 2009 5:08] Sveta Smirnova
Thank you for the report.

Verified as described.
[27 Aug 2010 14:25] Daniƫl van Eeden
In the "HELP SHOW" output of 5.1.50-enterprise-gpl-advanced "SHOW SCHEDULER STATUS" is listed, but it is not working.