Bug #43843 No composite/compound primary keys for MyISAM tables

• Submitted: 24 Mar 2009 21:55
• Modified: 24 Mar 2009 22:56
• Reporter: Mark M
• Status: Not a Bug
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 5.1.9 OSS Beta
• OS: Windows (Vista)
• CPU Architecture: Any
• Tags: composite, composite primary key, compound, compound primary key, key, primary key

[24 Mar 2009 21:55] Mark M

Description:
I cannot create a compound/composite primary key for intermediary tables linking many to many relationships through the table editor.  I am not sure how to do this in the EER diagram (if available at all).  It should be available in the table editor.  I can get passed this by manually editing the exported output before importing into MySQL.  This is a dangerous hack, as every change I make to the schema in Workbench, I will need to find the tables and modify the import script. I shouldn't have to edit the exported output data, that is why I am using Workbench.

How to repeat:
Try to create a composite/compound primary key, it only accepts one value.  

Suggested fix:
Allow multiple fields in the primary key.

[24 Mar 2009 22:13] Mark M

I have discovered this is not a bug.  You simply have to check the primary key checkbox on each of the desired field(s).  My mistake.

[24 Mar 2009 22:56] MySQL Verification Team

Thank you for the feedback.