Bug #75810 | Crash while renaming a column of table via gui | ||
---|---|---|---|
Submitted: | 6 Feb 2015 16:23 | Modified: | 16 Mar 2015 8:13 |
Reporter: | Lorenzo Sequi | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Workbench: Modeling | Severity: | S2 (Serious) |
Version: | 6.2.3.12312 build 2280 | OS: | Windows (Windows 7 Pro sp1 64bit) |
Assigned to: | CPU Architecture: | Any | |
Tags: | crash, DML, modeling, windows |
[6 Feb 2015 16:23]
Lorenzo Sequi
[6 Feb 2015 16:24]
Lorenzo Sequi
crash_editing_table_model
Attachment: crash_editing_table_model.png (image/png, text), 112.59 KiB.
[6 Feb 2015 18:10]
MySQL Verification Team
Please try version 6.2.4. Thanks.
[9 Feb 2015 8:45]
Lorenzo Sequi
I've tried aso version 6.2.4.12437 buil 2426 (64 bits) but I had the same problem while changing the name of PK column via gui.
[9 Feb 2015 8:49]
Lorenzo Sequi
The only way doing the raname was by removing the PK and AI from the column, then executing the script as folloqing: alter table db_name.my_table_name CHANGE COLUMN `id_before` `id_new_name` int(11) PRIMARY KEY AUTO_INCREMENT;
[13 Mar 2015 0:48]
MySQL Verification Team
Thank you for the feedback. I couldn't repeat with my own tables for example using tables from Sakila database with 6.2.4 or 6.2.5. Are you able to provide the create table statement which provoke this issue?. Thanks.
[16 Mar 2015 8:13]
Lorenzo Sequi
In version 6.2.5 build 397 it seems to be resolved: I tried to rename a pk column in the table view (the table with names, datatypes, etc.) and in the normal text-box below and I successfully applied the modifications flawlessly.