My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.