Bug #36102 Weirdness with setting Foreign Key reference column
Submitted: 15 Apr 2008 20:47 Modified: 6 Nov 2008 7:38
Reporter: Ian Jones Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.17 SE RC OS:Windows (Vista Home Premium)
Assigned to: CPU Architecture:Any
Tags: foreign keys, SE, workbench

[15 Apr 2008 20:47] Ian Jones
Description:
When clicking the column for a foreign key in the Foreign Keys tab of the table editor, the Referenced Column drop down list refreshes a number of times before the column is checked and the drop down can be used.

How to repeat:
Have two or more tables in your model.
Double click a table from the main Physical Schemata view.
Click the Foreign Keys tab.
Enter a name for a new foreign key.
Tab into the Referenced Table column and select a table to be referenced.
In the next "Column" column in the second section click a column name that is the foreign key.

Weirdness happens in the Referenced Column drop down list as it redraws a number of times before the clicked column shows itself as clicked and the Referenced Column drop down list finally stops refreshing and stays open ready to have a column name selected.

Suggested fix:
Unknown.
[15 Apr 2008 20:50] Ian Jones
QT movie showing redrawing behaviour of Referenced Column

Attachment: FunkyForeignKeyReferences.mov.zip (application/zip, text), 467.18 KiB.

[29 Oct 2008 13:16] MySQL Verification Team
Could you please test with latest release. I couldn't repeat behavior reported.
[30 Oct 2008 21:41] Ian Jones
Doesn't seem to happen in latest release, in fact I don't think I've seen it for a couple of releases.
[6 Nov 2008 7:38] Valeriy Kravchuk
So, the problem is not repeatable with latest releases.