MySQL Bugs: #89994: INDEX DIRECTORY shown as valid option for InnoDB table creation

Bug #89994	INDEX DIRECTORY shown as valid option for InnoDB table creation
Submitted:	9 Mar 2018 17:17	Modified:	4 Jun 2018 18:34
Reporter:	Claudio Nanni	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.7	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
The page: https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html

Claims:

"DATA DIRECTORY and INDEX DIRECTORY are not supported for individual partitions or subpartitions of MyISAM tables on Windows. They are supported for individual partitions and subpartitions of InnoDB tables (as on all platforms)."

But InnoDB doesn't have separate files for INDEX.

mysql> SELECT VERSION();
+------------+
| VERSION()  |
+------------+
| 5.7.10-log |
+------------+
1 row in set (0.00 sec)

mysql> CREATE TABLE t( a INT, b INT ) ENGINE=InnoDB PARTITION BY RANGE( a ) SUBPARTITION BY HASH( b ) SUBPARTITIONS 5 ( PARTITION p101 VALUES LESS THAN (102) DATA DIRECTORY = '/tmp/data' INDEX DIRECTORY = '/tmp/index' );
ERROR 1031 (HY000): Table storage engine for 't' doesn't have this option

mysql> show warnings;                                                                                                                                 +---------+------+--------------------------------------------------------+
| Level   | Code | Message                                                |
+---------+------+--------------------------------------------------------+
| Warning | 1478 | InnoDB: INDEX DIRECTORY is not supported               |
| Error   | 1031 | Table storage engine for 't' doesn't have this option |
+---------+------+--------------------------------------------------------+
2 rows in set (0.00 sec)

How to repeat:
Read the manual

Suggested fix:
Update the manual

Thank you for the bug report.

Posted by developer:
 
The referenced documentation has been updated. The change should appear online soon.

Thank you for the bug report.