Bug #7663 Error when deleting a foreign key
Submitted: 4 Jan 2005 15:25 Modified: 30 May 2005 19:04
Reporter: Gernot Brandl Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.0.18 OS:Windows (Windows 2000)
Assigned to: Michael G. Zinner CPU Architecture:Any

[4 Jan 2005 15:25] Gernot Brandl 
Description:
When i try to delete a foreign key i get an error message (Access violation ... in module 'libmysqlx.dll' see attached screenshot) after pushing the 'Apply Changes' button. The FK isn't deleted

How to repeat:
In my example the table has two columns that refer to different rows from the same table. I tried to delete one of these FK's when the error occured.
[4 Jan 2005 15:26] Gernot Brandl 
screensht of error message

Attachment: ma_err_5.gif (image/gif, text), 5.14 KiB.
[4 Jan 2005 15:32] Gernot Brandl 
I found out, that the error only occures when i try to delete the FIRST FK of the existing TWO FK's.
If i delete only the second one or delete BOTH at once everything works fine.
[30 May 2005 19:04] 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 bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html