Bug #72165 Docs: CREATE INDEX ... KEY_BLOCK_SIZE
Submitted: 30 Mar 2014 17:53 Modified: 4 Jun 2014 17:11
Reporter: Federico Razzoli Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S2 (Serious)
Version: OS:Any
Assigned to: Daniel Price CPU Architecture:Any

[30 Mar 2014 17:53] Federico Razzoli 
Description:
This page:

http://dev.mysql.com/doc/refman/5.6/en/innodb-compression-usage.html

says:

"Table attributes such as ROW_FORMAT and KEY_BLOCK_SIZE are not part of the CREATE INDEX syntax, and are ignored if they are specified"

However, this page:

http://dev.mysql.com/doc/refman/5.6/en/create-index.html

explains KEY_BLOCK_SIZE as if it was perfectly valid (and does not mention ROW_FORMAT at all).

How to repeat:
read the page, i suppose
[30 Mar 2014 18:21] MySQL Verification Team 
Hello Federico,

Thank you for the report.

Thanks,
Umesh
[4 Jun 2014 17:11] Daniel Price 
"KEY_BLOCK_SIZE" is only supported at the table level for "InnoDB". 

The following reference manual pages have been updated:

http://dev.mysql.com/doc/refman/5.1/en/create-index.html
http://dev.mysql.com/doc/refman/5.5/en/create-index.html
http://dev.mysql.com/doc/refman/5.6/en/create-index.html
http://dev.mysql.com/doc/refman/5.7/en/create-index.html