Some Compact/Redundant Format Tables Cannot be Accessed After Upgrade to MYSQL 8.0: ERROR 1709 (HY000): Index column size too large. The maximum column size is 767 bytes
(Doc ID 2926073.1)
Last updated on DECEMBER 12, 2023
Applies to:
MySQL Server - Version 8.0 and laterInformation in this document applies to any platform.
Symptoms
After upgrade from 5.6.x/5.7.x to 8.0.x some tables cannot be opened at all, yielding
Check Table <SCHEMA>.<TABLE> fails like this :
Changes
Server was upgraded to 8.0.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |