Bug #73768 | Problem with indexes and change to UTF8mb4 | ||
---|---|---|---|
Submitted: | 29 Aug 2014 10:16 | Modified: | 29 Sep 2014 11:54 |
Reporter: | John Woodford | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: DDL | Severity: | S2 (Serious) |
Version: | 5.6.20 | OS: | Windows |
Assigned to: | CPU Architecture: | Any | |
Tags: | 1709, 767, 767 bytes, column, Error Code: 1709, INDEX, index column size, large, large, size, the maximum column size is 767 bytes, too |
[29 Aug 2014 10:16]
John Woodford
[29 Aug 2014 10:21]
John Woodford
Using InnoDB as default storage engine
[29 Aug 2014 11:54]
MySQL Verification Team
Thank you for the bug report. Please check http://dev.mysql.com/doc/refman/5.6/en/innodb-restrictions.html regarding " When the innodb_large_prefix configuration option is enabled, this length limit is raised to 3072 bytes, for InnoDB tables that use the DYNAMIC and COMPRESSED row formats.". Thanks.
[30 Sep 2014 1:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".