MySQL Bugs: #52434: Exception when choosing foreign key in "referenced column" on "Foreign Keys" tab

Bug #52434	Exception when choosing foreign key in "referenced column" on "Foreign Keys" tab
Submitted:	29 Mar 2010 11:32	Modified:	1 May 2010 6:35
Reporter:	Luap Luap	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S3 (Non-critical)
Version:	5.2.16	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	exception, foreign key

Description:
I got a pop up message asking me to report this:

Exception = System.Runtime.InteropServices.SEHException
Message = External component has thrown an exception.
FullText = System.Runtime.InteropServices.SEHException: External component has thrown an exception.
   at bec.FKConstraintColumnsListBE.get_column_is_fk(FKConstraintColumnsListBE* , NodeId* )
   at MySQL.Grt.Db.FKConstraintColumnsListBE.get_column_is_fk(NodeId node)
   at MySQL.GUI.Workbench.Plugins.DbMysqlTableFkColumnListModel.columnEnabledFkNodeControl_CheckStateChanged(Object sender, TreePathEventArgs e)
   at System.EventHandler`1.Invoke(Object sender, TEventArgs e)
   at Aga.Controls.Tree.NodeControls.NodeCheckBox.OnCheckStateChanged(TreePathEventArgs args)
   at Aga.Controls.Tree.NodeControls.NodeCheckBox.OnCheckStateChanged(TreeNodeAdv node)
   at Aga.Controls.Tree.NodeControls.NodeCheckBox.SetCheckState(TreeNodeAdv node, CheckState value)
   at Aga.Controls.Tree.NodeControls.NodeCheckBox.MouseDown(TreeNodeAdvMouseEventArgs args)
   at Aga.Controls.Tree.TreeViewAdv.OnMouseDown(MouseEventArgs e)
   at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

How to repeat:
Unable to repeat. My second attempt to set the foreign key worked without the error being generated.

What exact data types referencing and referenced columns have?

Hi,

The datatypes are both INT. 

I have encountered the problem a few times now. It happens when I click  to open the drop down menu of foreign key choices. It seems to happen randomly, I can't pinpoint anything I am doing to make it happen! But when it does happen, if I click to a differnet tab and then back to the foreign key tab then it works fine.

I think if I click the drop down menu after the error then the list is empty. I will double check if I get the error again.

Does it happen with Referenced Table or Referenced Column drop down box?

It is the Referenced Column.

Many thanks for writing a bug report.

Unfortunately, we have too less informations here to make
a deeper analysis.

We either need to know how we can reproduce this or we
need a backtrace.

Please read: http://bugs.mysql.com/how-to-report.php

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".