Bug #83341 Cannot connect foreign keys using CHAR
Submitted: 12 Oct 2016 9:57 Modified: 12 Oct 2016 11:33
Reporter: Craig Macdonald Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:6.3.7 OS:Any
Assigned to: CPU Architecture:Any
Tags: regression

[12 Oct 2016 9:57] Craig Macdonald
Description:
The ability to add a foreign key constraint when the referring and referenced columns have type CHAR() does not work. The user is unable to select the referenced column: 
 - on Windows, the drop down just empties itself
 - on Mac, the referenced column cannot be selected successfully

How to repeat:
Create a table T1 with primary key a1 of type CHAR(8).
Press Apply.

Create a table T2 with any attributes, including a2 of type CHAR(8).
Press Apply.

On the foreign keys tab of T2, name a new foreign key constraint (e.g. fk_1) and select T1 as the referenced table. Now try to connect column a2 with a1.

Suggested fix:
This is a regression - it works fine on 6.3.4.

It also works fine for VARCHAR - but I dont understand why the data type has an impact.
[12 Oct 2016 11:33] MySQL Verification Team
Hello Craig,

Thank you for the report.
Observed this with WB 6.3.7 on Win7.

Thanks,
Umesh
[12 Oct 2016 11:40] MySQL Verification Team
This issue observed from WB >=6.3.5 but no issues in 6.3.4 on Win7