Bug #18802 Cannot assign foreign key as additional primary key

• Submitted: 5 Apr 2006 13:31
• Modified: 2 May 2006 16:58
• Reporter: Klaus Bensch
• Status: Won't fix
• Category: MySQL Workbench Preview
• Severity: S2 (Serious)
• Version: 1.0.5
• OS: Windows (WinXP-SP2)
• CPU Architecture: Any

[5 Apr 2006 13:31] Klaus Bensch

Description:
The DBDesigner has two tools to create foreign keys:
i) the 1:n tool (which is missing in Workbench) and
ii) the 1:n non-identifying tool (the standard tool in Workbench).

It is not possible to create combined primary keys by using the standard 1:n non-identifying tool and thereafter the table editor.

DBDesigner files are imported correctly.

How to repeat:
Create two tables with primary keys.
Create a 1:n relation between both tables.
Try to change the foreign key to a primary key.

[5 Apr 2006 13:47] Klaus Bensch

There is a workaround if you create new tables:
Create the first table with primary key.
Insert new table. Don't edit table at this point.
Add 1:n relation between tables.
Now open table editor and add new additional primary key. Change foreign key to primary key. Then save changes.

[2 May 2006 16:58] Jorge del Conde

Thanks for your bug report.  I was able to reproduce this under 1.0.6