Bug #83341 Cannot connect foreign keys using CHAR

• Submitted: 12 Oct 2016 9:57
• Modified: 12 Oct 2016 11:33
• Reporter: Craig Macdonald
• Status: Verified
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 6.3.7
• OS: Any
• 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