MySQL Bugs: #36902: Invalid pointer operation creating foreign key

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
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.2.12	OS:	Microsoft Windows (Vista 64-bit)
Assigned to:	Mike Lischke	Target Version:
Tags:	foreign key, Invalid pointer operation
Triage:	D3 (Medium)

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.

Displaying error message

Attachment: invalid_pointer.PNG (image/png, text), 62.81 KiB.

Thank you for the bug report.

Fixed in rev 2062

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