MySQL Bugs: #72112: Wrong error code (1727 instead of 1709) for ER_INDEX_COLUMN_TOO

Bug #72112	Wrong error code (1727 instead of 1709) for ER_INDEX_COLUMN_TOO_LONG in manual
Submitted:	24 Mar 2014 16:54	Modified:	25 Mar 2014 13:17
Reporter:	Valeriy Kravchuk	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.5, 5.6	OS:	Any
Assigned to:	Paul DuBois	CPU Architecture:	Any
Tags:	ER_INDEX_COLUMN_TOO_LONG, innodb_large_prefix

Description:
Manual (http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_large_prefix) says:

"For tables using the REDUNDANT and COMPACT row formats, this option does not affect the allowed key prefix length. It does introduce a new error possibility. When this setting is enabled, attempting to create an index prefix with a key length greater than 3072 for a REDUNDANT or COMPACT table causes an error ER_INDEX_COLUMN_TOO_LONG (1727)."

Note that 1727 is a wrong code, correct one (that you may find out by clicking on the name) is 1709:

http://dev.mysql.com/doc/refman/5.6/en/error-messages-server.html#error_er_index_column_to...

Same problem is in the manual for 5.5: http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_large_prefix

How to repeat:
Try to find details about the error with code 1727 after reading the manual. Note that it has nothing to do with too long index column...

Suggested fix:
Please, fix error code and consider adding example demonstrating this error code (as well as proper use of innodb_large_prefix=ON at http://dev.mysql.com/doc/refman/5.6/en/innodb-restrictions.html, more on that in other bug report).

Thank you for the bug report.

Error codes are taken verbatim from the Server sources, so I guess this needs to be fixed in the code base rather than in the docs.

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly.

There's no need for this description to give an error number, the error name links to the proper error description. Removing the number. Also changing 5.5 manual so error name is a link, not static text.