Bug #18218 Impossible to choose column for FK

• Submitted: 14 Mar 2006 10:43
• Modified: 2 May 2006 22:18
• Reporter: [ name withheld ]
• Status: Won't fix
• Category: MySQL Workbench Preview
• Severity: S2 (Serious)
• Version: 1.0.5-beta
• OS: MacOS (MacOS X 10.4.5)
• CPU Architecture: Any

[14 Mar 2006 10:43] [ name withheld ]

Description:
I tried to create a Foreign Key within the table editor. But it's impossible to select a column in the actual table for the Foreign Key. 

How to repeat:
1) Create a table with at least two columns, let's say column_1 and column_2.
2) Go to the table editor and then to the "Foreign Keys" tab
3) Add a Foreign Key.
4) Click on the Foreign Key and go to the subwindow, where you can choose the columns to use for the Foreign Key.
5) Try to select column_2 as Foreign Key column of the actual table. But after a click on column_2, the select still remains empty.

[15 Mar 2006 20:11] Steve Slater

Same problem on win2k. Looks like there is a pull-down to choose from the columns on the table, but it doesn't work. 

Trying this for a minute gave me a blue screen of death.

[21 Apr 2006 10:04] matthew heald

may be a variation on the same error, can define foreign keys one table, but on trying to add 3rd fk defintion can select the correct item in the "column" but the referred column list box is empty.

query is their a limit on the number of FK contstraints that workbench can handle either as the child or parent table

[2 May 2006 22:17] Jorge del Conde

Thanks for your bug report

[2 May 2006 22:18] Jorge del Conde

I tested this under 10.4.2

[2 Jan 2007 12:48] Yahoo Serious

On typing a letter the right column name appears (so th edrop-down does have contents, even though not shown), but it seems impossible to keep it...

[13 Feb 2007 14:44] Sheeri Cabral

I had this issue, and it was due to an index not being on the field or the field mysteriously being deleted.  Check indices and columns (i've had the index persist when the column wasn't there as well).