MySQL Bugs: #18790: Changing or adding primary keys

Bug #18790	Changing or adding primary keys
Submitted:	5 Apr 2006 8:50	Modified:	5 Apr 2006 17:18
Reporter:	Klaus Bensch	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Workbench Preview	Severity:	S2 (Serious)
Version:	1.0.5	OS:	Windows (WinXP-SP2)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
The 'Main View' is not updated properly, when the primay key is changed or an exisiting key is changed to a primary key. The 'Table Editor' shows the correct values.

How to repeat:
Generate a new table with several additional keys and save. Edit table an try to change primary key to normal key or key to primary key. Apply changes and close editor. 'Main View' is unchanged.

Suggested fix:
Workaround:
Just design the table correctly from the start.
Add a new primary key instead of changing an existing key.
Or change the table in any other way, apply changes, and undo changes in a second step.

Thank you for the bug report.