Bug #53134 mysql-workbench-5.2.19: creating foreign keys is impossible
Submitted: 23 Apr 2010 22:24 Modified: 4 May 2010 16:25
Reporter: Jakub Caban Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.19 OS:Linux (Gentoo Linux, Ubuntu 8.04)
Assigned to: Alfredo Kojima CPU Architecture:Any
Tags: editor, foreign keys

[23 Apr 2010 22:24] Jakub Caban
Description:
This bug occurred in earlier versions too.

When in "Alter table" window, in FK tab, when I try to create new FK I can
select foreign table, but nothing more. No check-boxes nor combo boxes in
column list are active, so I cannot configure the FK.

I've reported it on Gentoo bugzilla here:

http://bugs.gentoo.org/show_bug.cgi?id=316141

I will be happy to provide any details that could be useful.

How to repeat:
Open any table via "Alter table" and try to create any NEW FK (editing existing ones works ok).
[26 Apr 2010 8:15] Valeriy Kravchuk
Thank you for the bug report. Verified just as described on Ubuntu 8.04 while working with local MySQL server 5.0.51.
[27 Apr 2010 1:14] Johannes Taxacher
Hi Jakub,
can you check if the columns you were about to connect via FK were defined of exactly same type? if you create a table using INT for a column and try to connect it to another tables column defined as INT(11) WB will refuse to do so.
thanks in advance
[27 Apr 2010 8:42] Jakub Caban
OK, I've tried a few times and found a way I can create FKs. About column types - I was always using it on same types (always INT(11) to INT(11) in this case).

But the problem is, that when I select table from table list, it doesn't get selected - I need to select that list and press enter. Than it looks like WB is actually selecting table and choosing foreign column becomes possible.

So it is not problem with creating FKs, but with interface that needs double selecting foreign table (first from combo box, and than going back in and "confirming" with enter) - that's really not intuitive, so I'd still say it's some kind of bug.
[29 Apr 2010 12:30] Alfredo Kojima
Fixed
[30 Apr 2010 19:30] Johannes Taxacher
fix confirmed in repository
[4 May 2010 16:25] Tony Bedford
An entry has been added to the 5.2.21 changelog:

In the Alter Table dialog of the SQL Editor, it was not possible to create new Foreign Keys.