MySQL Bugs: #83341: Cannot connect foreign keys using CHAR

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:	Won't Fix	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	6.3.7	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	regression

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.

Hello Craig,

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

Thanks,
Umesh

This issue observed from WB >=6.3.5 but no issues in 6.3.4 on Win7

Posted by developer:

This issue applies to the legacy MySQL Workbench 8.x implementation that is no longer supported or maintained.
MySQL Workbench 26.7 is a complete rewrite using a new technology stack and does not use the affected legacy implementation.
Therefore, this issue is not applicable to the current MySQL Workbench product and as such is closed.