MySQL Bugs: #25733: missing index option in syntax description in MySQL Manual

Bug #25733	missing index option in syntax description in MySQL Manual
Submitted:	20 Jan 2007 15:28	Modified:	6 Feb 2007 15:23
Reporter:	Mikael Ronström	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.1	OS:
Assigned to:	Paul DuBois	CPU Architecture:	Any

Description:
In the manual describing the CREATE TABLE syntax
index_option is introduced but nowhere is it
defined.

How to repeat:
x

Suggested fix:
Either add description of index_options if such exists or
remove index_options.
Very much similar to bug 20371 although 20371 was about
index_type and this is about index_option

Thank you for the report.

But there is description of index_option at the http://dev.mysql.com/doc/refman/5.1/en/create-table.html page:

index_option values specify additional options for an index. USING is one such option. For details about allowable index_option values, see Section 13.1.6, “CREATE INDEX Syntax”.

From the page you referred to:

| {INDEX|KEY} [index_name] [index_type] (index_col_name,...)
      [index_option ...]

index_type:
    USING {BTREE | HASH}
From the page at chapter 13.1.6:
index_option:
    KEY_BLOCK_SIZE value
  | index_type
  | WITH PARSER parser_name

So given that even you mixed up index_option and index_type I
think it's a good idea to add index_option also in the description of
the CREATE TABLE syntax.

Thank you for the clarification.

Verified as "Add index_option description in the syntax description part of the page http://dev.mysql.com/doc/refman/5.1/en/create-table.html"

Mikael,

Sveta didn't mix up anything.  The create-table page refers to the
create-index page for the allowable values of index_option.
The create-index page defines both index_option and index_type.

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.