Bug #56700 Foreign key exception

• Submitted: 9 Sep 2010 18:02
• Modified: 9 Sep 2010 18:50
• Reporter: Todd Reilly
• Status: Closed
• Category: MySQL Workbench: Modeling
• Severity: S3 (Non-critical)
• Version: 5.2.27
• OS: Windows (Windows 7)
• CPU Architecture: Any
• Tags: Foreign key external component exception

[9 Sep 2010 18:02] Todd Reilly

Description:
Hi,

When I tried to make a foreign key on a table to reference itself, I got a box saying:

"MySQL Workbench has encountered a problem
External component has thrown an exception"

How to repeat:
I tried to create a table, T_EMP, with EMP_ID as an integer primary key, auto incrementing.  I added a column MGR_ID and wanted to set a foreign key to EMP_ID, when I got the error.

On another note, I seem to be unable, when setting up foreign keys, to click on the column to make the foreign key.  I click on it, but nothing happens.

[9 Sep 2010 18:18] MySQL Verification Team

Please report the version you are using, if minor version than 5.2.27 please upgrade. Thanks.

[9 Sep 2010 18:26] Todd Reilly

Hi,

The version is 5.2.27 CE.

Thanks.

[9 Sep 2010 18:31] Valeriy Kravchuk

I have no problem while creating such a table with 5.2.27 on Mac OS X.

[9 Sep 2010 18:50] Todd Reilly

Hi,

I'm running on Windows 7.  I deinstalled and just reinstalled MySQL and MySQL Workbench, and the error went away.

Thanks.