Bug #35623 Removing additional primary key does not update EER diagram

• Submitted: 27 Mar 2008 20:20
• Modified: 31 Mar 2008 17:44
• Reporter: Che Hodgins
• Status: Duplicate
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 5.0.16 SE RC
• OS: Windows
• CPU Architecture: Any
• Tags: primary key, update eer diagram

[27 Mar 2008 20:20] Che Hodgins

Description:
If you remove the 2nd+ primary key from a table (by unchecking the checkbox), the EER diagram will not be updated to match the change. ie. the small key icon beside that column will not disappear.

How to repeat:
Open Workbench
Click "Add Diagram" in the EER Diagrams section
Click "Place a new Table (T)" from the left sidebar
Place table and double click on it to make the bottom tab appear
Click on the "columns" tab
create 2 columns with whatever definition
notice that the first column is by default the PK
set the 2nd column as a primary key also (using checkbox)
notice that the eer diagram updates immediately with new pk (small icon to left of column)
uncheck the same checkbox to remove the primary key
notice that the eer diagram does NOT update accordingly.

Suggested fix:
Update the EER right away when an additional PK is removed.

[31 Mar 2008 17:44] Johannes Taxacher

duplicate of #35639