Bug #107236 Cannot drop column when name is >53 characters long

• Submitted: 8 May 4:56
• Modified: 9 May 5:18
• Reporter: Wesley B
• Status: Verified
• Category: MySQL Server: DDL
• Severity: S3 (Non-critical)
• Version: 8.0.29-0ubuntu0.20.04.3
• OS: Ubuntu
• CPU Architecture: ARM (Apple M1)
• Tags: regression

[8 May 4:56] Wesley B

Description:
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` (
  `id` int NOT NULL AUTO_INCREMENT,
  `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.

regards,
Umesh