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 DECEMBER 12, 2017

Applies to:

MySQL Server - Version 5.6 and later
Information in this document applies to any platform.

Goal

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.

 

Solution

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
Goal
Solution
References


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