Bug #56329 Unable to create foreign keys (type mismatch)
Submitted: 27 Aug 2010 17:50 Modified: 31 Aug 2010 14:54
Reporter: Todd Farmer (OCA) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.26 OS:Windows (XP)
Assigned to: CPU Architecture:Any

[27 Aug 2010 17:50] Todd Farmer 
Description:
Trying to create an InnoDB table with foreign keys, I am unable to select a column or referenced column in the second section of the "Foreign Key" tab of the Create Table wizard.

How to repeat:
Try to create a table with a foreign key.

Suggested fix:
Allow selection of necessary components.
[27 Aug 2010 17:51] Todd Farmer 
Unable to select column or referenced column

Attachment: SP32-20100827-104901.gif (image/gif, text), 16.19 KiB.
[27 Aug 2010 17:54] Alfredo Kojima 
Did you toggle the checkbox for the column? The screenshot indicates they're unchecked.
[27 Aug 2010 18:08] Todd Farmer 
Yes, that's part of the bug.  I am unable to toggle that checkbox.  :(
[27 Aug 2010 18:39] Alfredo Kojima 
Can you attach the SQL for test.first?
[27 Aug 2010 18:40] Todd Farmer 
delimiter $$

CREATE TABLE `first` (
  `a` int(11) NOT NULL,
  `b` int(11) default NULL,
  PRIMARY KEY  (`a`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8$$
[27 Aug 2010 18:47] Alfredo Kojima 
Seems the column type matcher thinks INT != INT(11)
[31 Aug 2010 14:54] Alfredo Kojima 
this is a duplicate of bug #55399