MySQL Bugs: #74513: MySQL Workbench Table Editor - drop and add a column of same name doesn't work

Bug #74513	MySQL Workbench Table Editor - drop and add a column of same name doesn't work
Submitted:	22 Oct 2014 20:32	Modified:	10 Aug 2015 12:19
Reporter:	Craig Macdonald	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	6.2, 6.1	OS:	Any (Both mac and windows)
Assigned to:		CPU Architecture:	Any
Tags:	ALTER TABLE

Description:
Using the table editor, for an already present table, delete a column, and then remake a column with the same name but a different datatype. The generated ALTER TABLE SQL is incorrect.

How to repeat:
In Table Editor, do equivalent of:

CREATE TABLE table2(idcol INT PRIMARY KEY, table2col VARCHAR(45));

click Apply. 

Click table2col, click Delete Selected

Create a new col, also named table2col and give type INT.

Click apply. Generated SQL is:
{{{
ALTER TABLE `workbenchtest`.`table2` 
CHANGE COLUMN `` `table3col1` INT NULL ;
}}} 
which is clearly incorrect.

Clicking Apply gives:
{{{
ERROR 1054: Unknown column '' in 'table2'
SQL Statement:
ALTER TABLE `workbenchtest`.`table2` 
CHANGE COLUMN `` `table3col1` INT NULL
}}}

Suggested fix:
Should be a drop and add column, or remember old column name.

Thank you for the bug report.

Amended linux -> windows in OS text

Hi Miguel, all,

I'm looking at what platform to use for my teaching in the Fall, do you see any movement on the Workbench bugs I reported, including this one?

Craig

Craig, it's scheduled for fixing. That will certainly be done till Fall.

Thanks Mike, good to hear you guys are on the case. 

Craig

Pinging...I haven't seen this fixed in the 6.3.x changelog.

Craig