MySQL Bugs: #37753: InnoDB key size limitation is not documented on the InnoDB limitations page

Bug #37753	InnoDB key size limitation is not documented on the InnoDB limitations page
Submitted:	1 Jul 2008 1:20	Modified:	11 Jul 2008 20:14
Reporter:	Mikiya Okuno	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	any	OS:	Any
Assigned to:	Paul DuBois	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Since there is a limitation regarding to InnoDB key (prefix) length, which it may have up to 767 bytes long, it is documented in the CREATE TABLE syntax page:
http://dev.mysql.com/doc/refman/5.0/en/create-table.html

However, this is not documented on the InnoDB restrictions page:
http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html

That limitation should be documented on the latter page as well.

How to repeat:
See the pages above.

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.