Bug #52541 error defini foreign Keys
Submitted: 1 Apr 2010 20:31 Modified: 5 May 2010 13:18
Reporter: Alejandro Belmar Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:5.2.16 OSS beta OS:Windows
Assigned to: CPU Architecture:Any
Tags: foreign keys

[1 Apr 2010 20:31] Alejandro Belmar 
Description:
when i am relation two tables with no data in one of them this error happend.

How to repeat:
applying a foreign key with data in the table with the foreign key and no data at all in the other table.
[5 Apr 2010 13:18] MySQL Verification Team 
Thank you for the bug report. The table with data and the empty table doesn't violate the FK constraint which are you trying to create?. Please try to create the FK using the mysql.exe client with the tables with same conditions and comment the result. Thanks in advance.
[5 May 2010 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[6 May 2010 0:55] Alex Belmar 
the problem occurs when the related fields in the foreign key has a different type or a different feature, for example: an integer field unsigned related an integer field signed or  other exmple: char(1) field to int field this last example is the most obvious