MySQL Bugs: #23999: MySql Administrator does not show current restrict/cascade values on foreign key

Bug #23999	MySql Administrator does not show current restrict/cascade values on foreign key
Submitted:	6 Nov 2006 6:02	Modified:	23 Nov 2006 14:57
Reporter:	Matthew Morrissette	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.2.5rc	OS:	MacOS (Mac OS X 10.4/Windows)
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any
Tags:	cascade, foreign key, restrict

Description:
Viewing a foreign key on any Innodb table in My SQL administrator shows the wrong type of delete and update function.

How to repeat:
Steps to reproduce.

Create two innoDB tables with a single column in both that is the primary key with integer, not null, auto inc, and unsigned set.

Add a foreign key constraint on one of the tables columns to the other table's columns and set the update and delete to "CASCADE".

Save. Go to console, log in and type, "show create table %tablename%" replacing %tablename% with the table you added the foreign key constraints too.  You see correctly that the foreign key constraint is set to CASCADE.

Now open the table in My SQL Administrator and click on the Foreign Key tab.  Then click on the foreign key.  You will see both delete and update set to "RESTRICT".

Suggested fix:
The drop downs should show the correct update and delete type.

Thank you for the bug report. Same behavior on Windows version.

I can confirm this bug. Reproduced with MySQL Administrator 1.2.6 rc6, Windows XP.