Bug #107236 Cannot drop column when name is >53 characters long
Submitted: 8 May 2022 4:56 Modified: 28 Nov 2022 10:00
Reporter: Wesley B Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: DDL Severity:S2 (Serious)
Version:8.0.29-0ubuntu0.20.04.3 OS:Ubuntu
Assigned to: CPU Architecture:ARM (Apple M1)
Tags: regression

[8 May 2022 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 2022 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 2022 5:18] MySQL Verification Team 
Hello Wesley B,

Thank you for the report and feedback.

regards,
Umesh
[9 Sep 2022 15:13] Jorge Martins 
This still happens in 8.0.30 (tested on windows version)
[28 Oct 2022 16:32] Alexander Vinnik 
Is anybody working on it? Waiting for the fix