Bug #36902 Invalid pointer operation creating foreign key
Submitted: 23 May 2008 3:06 Modified: 7 Oct 2008 9:10
Reporter: Geoff Hart Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.2.12 OS:Windows (Vista 64-bit)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: foreign key, Invalid pointer operation

[23 May 2008 3:06] Geoff Hart 
Description:
Invalid pointer operation is generated when you remove a column from a foreign key. 100% reproducible.

How to repeat:
1) Create two tables that share a common field that can be joined using a foreign key
2) Edit one table in MySQL Admin
3) Select 'Foreign Keys' tab
4) Add a new foreign key
5) Choose a reference table
- A default column to join on will probably appear in the table; if not, add it manually
6) Right-click on the column that was added and select 'Remove Column'
- A null pointer exception is generated
- It does not have to be the only column, it also fails if remove any one of multiple join conditions

Suggested fix:
No exception.
[23 May 2008 14:34] MySQL Verification Team 
Displaying error message

Attachment: invalid_pointer.PNG (image/png, text), 62.81 KiB.
[23 May 2008 14:35] MySQL Verification Team 
Thank you for the bug report.
[23 Sep 2008 8:54] Mike Lischke 
Fixed in rev 2062
[7 Oct 2008 9:10] Mike Lischke 
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://dev.mysql.com/doc/en/installing-source.html