| Bug #20173 | ALTER TABLE Syntaxdoes not explain index_type | ||
|---|---|---|---|
| Submitted: | 31 May 2006 17:50 | Modified: | 27 Jul 2006 3:48 |
| Reporter: | Nick Gaugler | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Documentation | Severity: | S4 (Feature request) |
| Version: | 4.0/5.0/5.1 | OS: | N/A |
| Assigned to: | Paul DuBois | CPU Architecture: | Any |
[31 May 2006 21:23]
Valeriy Kravchuk
Thank you for a reasonable documentation request. Page http://dev.mysql.com/doc/refman/5.0/en/alter-table.html should include information about index_type (or a reference to its description).
[27 Jul 2006 3:48]
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.
Description: The ALTER TABLE Syntax page does not properly explain index_type. Infact there is no reference anywhere else on that page. | ADD [CONSTRAINT [symbol]] UNIQUE [INDEX|KEY] [index_name] [index_type] (index_col_name,...) How to repeat: N/A Suggested fix: Add proper documentation that is similiar to that on the CREATE INDEX Syntax page or properly link to the section within the CREATE INDEX Syntax page from the ALTER TABLE Syntax page. It would also be beneficial to refer to index_type as the same thing on the CREATE INDEX Syntax page, instead of type_name if this is linked.