Bug #47465 HELP SHOW lists outdated option

Submitted:	21 Sep 2009 0:56	Modified:	21 Sep 2009 5:08
Reporter:	Roel Van de Paar	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

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.

Thank you for the report.

Verified as described.

In the "HELP SHOW" output of 5.1.50-enterprise-gpl-advanced "SHOW SCHEDULER STATUS" is listed, but it is not working.

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.