Creating Index With Algorithm Inplace Not Working After Upgrading To MySQL 5.6, getting "Cannot change column type INPLACE" error
(Doc ID 1671440.1)
Last updated on OCTOBER 20, 2021
Applies to:MySQL Server - Version 5.6 and later
Information in this document applies to any platform.
After upgrading to 5.6, I am unable to create an index online. It appears to be on tables with a datetime column, which might be because of the new datetime format. However it is confusing that I get a "Cannot change column type INPLACE" error when adding an index.
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