Bug #32907 refactoring: Foreign key column not updated when referenced column changes
| Submitted: | 2 Dec 2007 8:11 | Modified: | 30 Jul 2009 22:48 |
|---|---|---|---|
| Reporter: | Gerard van Beek | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S4 (Feature request) |
| Version: | 5.0.10 | OS: | Windows (XP SP2) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | key foreign update, refactoring | ||
[2 Dec 2007 8:11]
Gerard van Beek
[2 Dec 2007 11:16]
Sveta Smirnova
Thank you for the report. I can not repeat described behaviour. Just new column name is not changed in my case, all references and foreign key definition is updated.
[2 Dec 2007 22:40]
Gerard van Beek
I've added an example of the result I get. I changed the datatype of the primary key of table b to VARCHAR(20. The foreign key definition in table a still shows MEDIUMINT.
[3 Dec 2007 13:24]
Johannes Taxacher
Workbench doesn't provide this feature (yet). We'll make this a feature request. thanks
[30 Jul 2009 22:47]
Alfredo Kojima
This is a refactoring feature and will be implemented in the future.
[30 Jul 2009 22:48]
Alfredo Kojima
Another feature request for the same functionality has been filed in bug #38801
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.058 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.