Bug #28548 Spelling mistake in online documentation: 'OCTET_LENGTH'
Submitted: 21 May 2007 6:29 Modified: 24 May 2007 8:40
Reporter: Asuka Kenji Siu Ching Pong (Basic Quality Contributor) (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.1.18-beta, 5.0.x OS:Any
Assigned to: Paul DuBois CPU Architecture:Any
Tags: Help, OCTET_LENGTH, OCTETLENGTH

[21 May 2007 6:29] Asuka Kenji Siu Ching Pong
Description:
The "help" table is incorrect.

The function Octet Length should be spelt like "OCTET_LENGTH", but not "OCTETLENGTH".

How to repeat:
mysql> help string functions;
You asked for help about help category: "String Functions"
For more information, type 'help <item>', where <item> is one of the following
topics:
   ASCII
   BIN
   BINARY OPERATOR
   BIT_LENGTH
   CAST
   CHAR FUNCTION
   CHARACTER_LENGTH
   CHAR_LENGTH
   CONCAT
   CONCAT_WS
   CONV
   ELT
   EXPORT_SET
   EXTRACTVALUE
   FIELD
   FIND_IN_SET
   FORMAT
   HEX
   INSERT FUNCTION
   INSTR
   LCASE
   LEFT
   LENGTH
   LIKE
   LOAD_FILE
   LOCATE
   LOWER
   LPAD
   LTRIM
   MAKE_SET
   MATCH AGAINST
   MID
   NOT LIKE
   NOT REGEXP
   OCT
   OCTETLENGTH
   ORD
   POSITION
   QUOTE
   REGEXP
   REPEAT FUNCTION
   REPLACE
   REVERSE
   RIGHT
   RPAD
   RTRIM
   SOUNDEX
   SOUNDS LIKE
   SPACE
   STRCMP
   SUBSTRING
   SUBSTRING_INDEX
   TRIM
   UCASE
   UNHEX
   UPDATEXML
   UPPER

mysql> help OCTET_LENGTH;

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

mysql> help OCTETLENGTH;
Name: 'OCTETLENGTH'
Description:
Syntax:
OCTET_LENGTH(str)

OCTET_LENGTH() is a synonym for LENGTH().

URL: http://dev.mysql.com/doc/refman/5.1/en/string-functions.html

mysql> select OCTETLENGTH('123');
ERROR 1046 (3D000): No database selected

mysql> select OCTET_LENGTH('123');
+---------------------+
| OCTET_LENGTH('123') |
+---------------------+
|                   3 |
+---------------------+
1 row in set (0.03 sec)

Suggested fix:
Fix the "help data" source file.
[21 May 2007 8:03] Valeriy Kravchuk
Thank you for a bug report. Verified just as described.
[24 May 2007 8:40] Paul DuBois
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.