Bug #49286 Changing column name fails in ALTER TABLE wizard
| Submitted: | 1 Dec 2009 18:18 | Modified: | 12 Mar 2010 18:51 |
|---|---|---|---|
| Reporter: | Todd Farmer (OCA) | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S1 (Critical) |
| Version: | 5.2 r4643 | OS: | Windows (XP) |
| Assigned to: | Johannes Taxacher | CPU Architecture: | Any |
[1 Dec 2009 18:18]
Todd Farmer
[4 Dec 2009 12:30]
Johannes Taxacher
this was fixed and included in 5.2.10
[8 Dec 2009 10:58]
Tony Bedford
An entry has been added to the 5.2.10 changelog: When using Alter Table in the SQL Editor, if a column name was changed, and the Apply button clicked, the Apply Object Changes wizard was launched. The Review changes page indicated that the script that would be applied would drop the altered column then add a new column with the new name. This led to column data being lost, as the script should instead have used CHANGE COLUMN, to change the name of the column.
[5 Mar 2010 7:04]
Susanne Ebrecht
Bug #51726 is a regression of this bug here.
[12 Mar 2010 18:51]
Johannes Taxacher
can't confirm the regression - not repeatable for me in current version
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.054 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.