Bug #45615 Corresponding columns in foreign key must have similar internal datatypes

• Submitted: 19 Jun 2009 13:18
• Modified: 30 Jul 2009 22:51
• Reporter: Petr Burian
• Status: Duplicate
• Category: MySQL Workbench
• Severity: S4 (Feature request)
• Version: 5.1.14
• OS: Any
• CPU Architecture: Any
• Tags: CHECKED, foreign key, similar internal datatype

[19 Jun 2009 13:18] Petr Burian

Description:
Foreign keys in InnoDB must have similar internal datatypes.

http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html

I appreciate a new feature in Worbkench to follow this rule.

How to repeat:
Imagine a InnoDB table 'languale' with primary key 'id'. There are several other InnoDB tables with foreign key 'language_id'.

At this time Workbench doesn't compare or change data types of foreign keys. Imagine I want to change langugage.id from INT to UNSIGNED SMALLINT. Now I also have to change all tables with language_id foreign key manually.

I hope for feature changing foreign keys automaticly whenever primary key of a constraint is changed. Of course there can be a Question dialog to confirm the change.

[19 Jun 2009 13:58] Valeriy Kravchuk

Thank you for the feature request.

[30 Jul 2009 22:51] Alfredo Kojima

Marked as duplicate of bug #38801