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:
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:6.2, 6.1 OS:Any (Both mac and windows)
Assigned to: CPU Architecture:Any

[22 Oct 2014 20:32] Craig Macdonald
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.
[23 Oct 2014 12:47] MySQL Verification Team
Thank you for the bug report.
[23 Oct 2014 13:30] Craig Macdonald
Amended linux -> windows in OS text
[11 Feb 2015 14:55] Craig Macdonald
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?

[11 Feb 2015 15:55] Mike Lischke
Craig, it's scheduled for fixing. That will certainly be done till Fall.
[11 Feb 2015 17:11] Craig Macdonald
Thanks Mike, good to hear you guys are on the case. 

[10 Aug 2015 12:19] Craig Macdonald
Pinging...I haven't seen this fixed in the 6.3.x changelog.