MySQL Bugs: #5527: Column selection for foreign keys don't work

Bug #5527	Column selection for foreign keys don't work
Submitted:	11 Sep 2004 11:01	Modified:	13 Oct 2005 13:49
Reporter:	Gernot Brandl	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.0.12	OS:	Windows (Windows 2000)
Assigned to:	Mike Lischke	CPU Architecture:	Any

Description:
When creating foreign keys, after selecting the referenced table, the dropdown's for column-selection don't work. They don't provide any entries.

How to repeat:
every time

Thanks for reporting. Do you have a primary key defined in the table you selected? Have both tables been InnoDB tables?

Yes they are InnoDB and have Indices. I was able to create the foreign keys by coding the statement manually.
The dropdown shows up a bit strange. I'll prepare a screenshot...

There is another stange behaviour:
If i try to type something into the dropdown, not all characters work. I have to find a character that works and after deleting it, i can type in any column name.

That's the way the dropdown looks like AFTER clicking the arrow

Attachment: mysql_admin_err_2.gif (image/gif, text), 21.63 KiB.

I wasn't able to repeat behavior with creating foreign keys. It works fine for me with version 1.0.13.

I didn't understand your description about drop down list. Could you be more specific?

I reinstalled v 1.0.13 but that didn't solve the problem.

To make shure, that's not my mistake, i uploaded a script, that creates two example-tables.

To reproduce:
  - Execute the Script
  - Try to create a foreign key between `articles_lang`.`cr_user` and `users`.`id`

This should result in something like:
ALTER TABLE `articles_lang` ADD FOREIGN KEY (`cr_user`) REFERENCES users(`id`) ON DELETE RESTRICT;

The dropdowns (foreign key column selection) are empty. When i try to expand one i only see a horizontal line under the lower edge of the dropdown (see screenshot) and no entries are shown.

If i start to type in a column name, the following happens:
In the example i try to type in the column name 'cr_user'. If i hit the 'c'-key on my keyboard, the dropdown just disapeares, so i'm unable to type in a 'c'. I am able to type in an 'x'. So i can type in 'xcr_user' and then delete the leading 'x'. This is the only way i found to type in a column name.
I found out, that it is impossible to type in any character that is a leading character of any existing column name...

For your Info:
I use Windows 2000 Professional (German) with all patches installed

regards
Gernot

Hi all,

In a somewhat related bug (I am not sure that it is totally dissimilar) : when one creates a foreign key using the MySQL Administrator and then closes the window the foreign keys will not display on the foreign key tab at any point in the future. One may restart the application but even that does not make the foreign keys visible. The primary keys are defined for all the tables and MyISAM table structure is being used.

Verified with MySQL Administrator 1.0.13

I cannot reproduce this problem. It is likely already fixed. Please update to the latest version.

I'm using version 1.1.6 and I don't get any drop down boxes for the column selection.
I can drag and drop a column into the "column" part but I cannot add the "Foreign Column" at all. No drop down, drag and drop won't work and typing won't work.
Yes I did select a "Refer. Table" and yes both tables are InnoDB.