Bug #44079 Workbench relation inconsistancy
Submitted: 3 Apr 2009 13:55 Modified: 3 Apr 2009 13:59
Reporter: Ken Brown Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.1.9 OSS Beta OS:Microsoft Windows (Vista Ultimate)
Assigned to: CPU Architecture:Any
Tags: Data Type, relation, workbench

[3 Apr 2009 13:55] Ken Brown
When manually creating a relation via the foreign key properties system does not maintain data types or warn about mismatch

How to repeat:
Create table 1 - col 1 int PK - col 2 int
create table 2 - col 1 varchar
create table 3 - col 2 datetime
edit table 1 and add identifying relation to table 2 on col 1
edit table 1 and add non relation to table 3 on col 2
no errors or warnings - would have expected relation to trigger update of object info on table 1 when relation created

Suggested fix:
none as using ERR to create relations hangs application
[3 Apr 2009 13:59] Michael G. Zinner
The matching datatype checking of FK columns is a feature of the SE edition. When using the OSS Edition you need manually check the matching datatypes.