Bug #13519 can't change value 'on delete' of FK
Submitted: 27 Sep 2005 10:59 Modified: 3 Aug 2006 18:29
Reporter: Mickael Besson Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.1.3 OS:Windows (Windows XP pro SP2)
Assigned to: Michael G. Zinner CPU Architecture:Any
Tags: Object Editors

[27 Sep 2005 10:59] Mickael Besson
Description:
In MySQL Table Editor/Foreign key, it's impossible to change the value of listbox named 'on delete'.
Indeed, when we click 'Apply changes' /Execute, we've got the message 'Can't create table...'
We're obliged to delete the FK and create another one with another value on 'on delete'.

How to repeat:
Catalogs
double click on a table which contains FK(s)
try to change the value 'on delete' (ex : cascade instead of restrict)
Apply Changes

Suggested fix:
Problem in ALTER TABLE (mysql server) or problem in the request, that is the question...
[3 Aug 2006 18:29] Michael G. Zinner
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://www.mysql.com/doc/en/Installing_source_tree.html