Bug #107236 Cannot drop column when name is >53 characters long
Submitted: 8 May 4:56 Modified: 9 May 5:18
Reporter: Wesley B Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version:8.0.29-0ubuntu0.20.04.3 OS:Ubuntu
Assigned to: CPU Architecture:ARM (Apple M1)
Tags: regression

[8 May 4:56] Wesley B
I am able to create columns with names more than 53 characters long, but attempting to drop such columns leads to: 

"Error Code: 3507. Failed to update columns dictionary object."

I think this is a regression with MySQL 8.0.29.

- Error on Apple M1 running Ubuntu 20.04 (Parallels) with MySQL 8.0.29
- Success on Intel i7-1065G7 running Ubuntu 20.04 (WSL2) with MySQL 8.0.28
- Error on Intel i7-1065G7 running Ubuntu 20.04 (WSL2) with MySQL 8.0.29

How to repeat:
DROP TABLE IF EXISTS `test_table`;

CREATE TABLE `test_table` (
  `a_column_with_a_long_enough_name_to_refuse_to_be_remov` int,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

ALTER TABLE `test_table` DROP COLUMN `a_column_with_a_long_enough_name_to_refuse_to_be_remov`;

-- It works if you remove the final "v" from the column name.
[8 May 5:01] Wesley B
Renaming the column beforehand with an ALTER TABLE `test_table` RENAME COLUMN `x` TO `y`; and then dropping the column does work.

So it does not seem to affect RENAME COLUMN, but does affect DROP COLUMN.
[9 May 5:18] MySQL Verification Team
Hello Wesley B,

Thank you for the report and feedback.