Bug #40408 Foreign Key Options not updated
Submitted: 29 Oct 2008 20:24 Modified: 5 Nov 2008 23:44
Reporter: Melody Zacharias Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0 OS:Windows
Assigned to: CPU Architecture:Any
Tags: foreign, key, on delete, ON UPDATE

[29 Oct 2008 20:24] Melody Zacharias 
Description:
When 2 foreign keys exist for a table.  If the Forein Key options are updated from the default blank to Cascade those values are held but not applied to the next foreign key when you click on it.  It appears to have been updated as well.  No refresh is done.

How to repeat:
Create a table with two foreign keys.  change the first one to Cascade for both "on update" and "on delete" then click on the second foreign key.  It will appear to be updated already.  However the screen has not been refreshed.  Click on a different table then come back to the foreign keys of the original table and click on the second foreign key first.  It will then show that it is not update.

Suggested fix:
Refresh screen when a different field is choosen.
[29 Oct 2008 22:28] MySQL Verification Team 
Could you please test with latest released version 5.0.26. Thanks in advance.
[5 Nov 2008 16:39] Melody Zacharias 
Yes, the new version fixes the problem.  Thanks!
[5 Nov 2008 23:44] MySQL Verification Team 
Closing according last comment from the reporter.