Bug #51262 No update after change of Referenced Table when creating Foreign Key
Submitted: 18 Feb 2010 0:54 Modified: 13 May 2010 13:10
Reporter: Shaolin 1 Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S4 (Feature request)
Version:5.2.16 Beta OS:Any (Windows 7 32b)
Assigned to: Alfredo Kojima CPU Architecture:Any

[18 Feb 2010 0:54] Shaolin 1 
Description:
When I create new Foreign key (when it works) and then change Referenced Table, the Column and Referenced Column is not updated. I will report it as another bug.

How to repeat:
SQL Editor/Overview/Alter table/Foreign Key tab

1. fill Foreign Key Name
2. select Referenced Table
3. check Column and Referenced Column
4. change Referenced Table

Column and Referenced Column are not updated (I can see in Referenced Column a column which is not in Referenced Table)

Suggested fix:
after change of Referenced Table click on checkbox in Column
[18 Feb 2010 7:36] Valeriy Kravchuk 
Thank you for the bug report (this is a bug, I think, not just a feature request, as wrong SQL is generated). Verified just as described.
[24 Apr 2010 2:18] Alfredo Kojima 
Fixed (note: not specific to any platform)
[10 May 2010 23:40] Johannes Taxacher 
fix confirmed in repository
[13 May 2010 13:10] Tony Bedford 
An entry has been added to the 5.2.21 changelog:

In the Alter Table dialog of the SQL Editor, the Column and Referenced Column were not updated when a foreign key was created in the Foreign Keys tab.