diff --git a/sql/sql_table.cc b/sql/sql_table.cc index 700ce54cf95..5123cfaadf6 100644 --- a/sql/sql_table.cc +++ b/sql/sql_table.cc @@ -11818,6 +11818,9 @@ static bool has_index_def_changed(Alter_inplace_info *ha_alter_info, strcmp(table_key->comment.str, new_key->comment.str))) ha_alter_info->handler_flags |= Alter_inplace_info::ALTER_INDEX_COMMENT; + if(table_key->is_visible != new_key->is_visible) + ha_alter_info->handler_flags |= Alter_info::ALTER_INDEX_VISIBILITY; + /* Check that the key parts remain compatible between the old and new tables.