Bug #47465 HELP SHOW lists outdated option

• Submitted: 21 Sep 2009 0:56
• Modified: 21 Sep 2009 5:08
• Reporter: Roel Van de Paar
• Status: Verified
• Category: MySQL Server: Command-line Clients
• Severity: S3 (Non-critical)
• Version: 5.1.37
• OS: Any
• CPU Architecture: Any

[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.