MySQL Bugs: #35636: HELP SELECT contains incorrect reference

Bug #35636	HELP SELECT contains incorrect reference
Submitted:	28 Mar 2008 9:26	Modified:	11 Nov 2008 20:20
Reporter:	Philip Stoev	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.0.56sp1/5.1	OS:	Any
Assigned to:	Paul DuBois	CPU Architecture:	Any

Description:
executing HELP SELECT produces:

...
  In the WHERE clause, you can use any of the functions and operators
  that MySQL supports, except for aggregate (summary) functions. See
  [HELP =].
...

However, "HELP =" is about the comparison operator itself, not about the WHERE clause. Also, it is a bit confusing to use = as the name of a HELP topic.

How to repeat:
Run HELP SELECT

Thank you for the bug report.

HELP = seems to be a valid command in the mysql command-line client:

astraia~> mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 32
Server version: 5.1.23-rc-log MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> help =
Name: '='
Description:
=

Equal:

URL: http://dev.mysql.com/doc/refman/5.1/en/comparison-operators.html

Examples:
mysql> SELECT 1 = 0;
        -> 0
mysql> SELECT '0' = 0;
        -> 1
mysql> SELECT '0.0' = 0;
        -> 1
mysql> SELECT '0.01' = 0;
        -> 0
mysql> SELECT '.01' = 0.01;
        -> 1

mysql>                                       

Please explain what the Manual/the help table entry should say instead of pointing to HELP =.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Resettting to Verified.  "HELP =" is indeed a valid help command, but [HELP =] isn't the correct reference for aggregate functions.

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.

Modified the method for mapping cross references to HELP topics. It turns out there were a number of incorrect mappings.

See also Bug#7162.