Versions 5.6.16 to 5.6.23 Cause Unavoidable Table Rebuild If Old Temporal Columns Exist (Doc ID 1988519.1)

Last updated on APRIL 14, 2016

Applies to:

MySQL Server - Version 5.6 to 5.6 [Release 5.6]
Information in this document applies to any platform.

Symptoms


In versions of MySQL 5.6.16 to 5.6.23 inclusive, tables containing old temporal column format (before fractional time support was invented, so created in 5.5), an
operation that should use 'fast alter table' would require a complete rebuild since the server detected it should upgrade the table to new temporal format columns.

This was unexpected, and could result in a downtime for large tables, as rebuilds are disk intensive.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms