Bug #25218 Not able to implement on delete cascade in MYSQL Query Browser
Submitted: 20 Dec 2006 13:48 Modified: 20 Jan 2007 14:30
Reporter: Amrish Kumar Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Query Browser Severity:S1 (Critical)
Version:5.0 OS:Any (Any)
Assigned to: MySQL Verification Team CPU Architecture:Any

[20 Dec 2006 13:48] Amrish Kumar 
Description:
I created a table name 'test' having just one field id(long) as primary key.
I then created another table 'test1' having two field id(primary key) and testid both declared long. Now this testid is foreign key referring id of test table. I have created these through MYSQL Query Browser. While creating second table test1, i was creating a constraint on this table. I select foreign key tab while creating the test1 table. I select "Cascade" for on delete and "restrict" for on update. When i pressed Apply changes/Save button what i saw the values for "On Update" and "On Delete" combo reset to "Restrict" which is default.I thought may be my database using MYISAM engine but it was using INNODB.

How to repeat:
Just create the two simple tables as above u in My SQL Browse by write clicking on the database. Don't write queries.Just do all through MY SQL GUI.
[20 Dec 2006 14:30] MySQL Verification Team 
Thank you for the bug report. Could you please show the output of
show create table test. Thanks in advance.
[21 Jan 2007 0:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".