Instant DDL Cannot Properly Handle Column Name Case Inconsistency
Last updated:2025-12-24 16:09:19
Instant DDL Cannot Properly Handle Column Name Case Inconsistency
Last updated: 2025-12-24 16:09:19
Issue
Instant DDL cannot properly handle the inconsistent letter case of column names in DDL statements and CREATE TABLE statements.
Issue Triggering Scenarios
This issue occurs when an instant DDL operation involves an INPLACE rename of a column name and its character set, and the case of the renamed column does not match the case defined in the original table schema.
Affected Kernel Versions
MySQL 8.0 20241005 and earlier versions.
Fixed Kernel Version
MySQL 8.0 20241009.
Check Methods
You can refer to the following commands to check for tables with potential risks.
select replace(name, '/', '.') as 'table_schema.table_name' from information_schema.innodb_tables where TOTAL_ROW_VERSIONS!=0 or INSTANT_COLS!=0;
Fixing Methods
1. Upgrade the kernel version to MySQL 8.0 20241009. For the operation method, see Upgrading the Kernel Minor Version.
2. After a kernel version upgrade, rebuild and repair the corrupted tables. You can use the method
alter table xx engine = innodb; for repair. To avoid business impact caused by table locking, it is recommended to perform the repair during off-peak hours using tools such as pt-osc.Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback