Bug #42333 Primary Keys
Submitted: 25 Jan 2009 22:52 Modified: 2 Feb 2009 14:36
Reporter: Anthony P Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S2 (Serious)
Version:1.2.12 OS:Any
Assigned to: CPU Architecture:Any
Tags: key, primary key, UPDATE

[25 Jan 2009 22:52] Anthony P 
Description:
When setting a primary key the status for key's does not show up in the catalog/schema table view.

How to repeat:
Create any table (with a key or without).  Drop to a mysql command shell and change the key (DROP PRIMARY or ADD PRIMARY KEY).  Refresh the screen in Administrator and notice that the key value is not set even when a KEY set.  Can of course verify that a KEY field is set by issuing a SHOW CREATE TABLE or DESCRIBE table.
[26 Jan 2009 14:48] Anthony P 
This seems to be even more repeatable when there are two keys.
[26 Jan 2009 15:52] Susanne Ebrecht 
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/
[1 Feb 2009 16:33] Anthony P 
The version that is available for linux download is 5.0.r12.  Are you saying that it has only been fixed in 5.0.r16 which is only available for Windows?
[2 Feb 2009 14:36] Susanne Ebrecht 
I tested with MySQL Administrator 1.2.15.

We are on the way to implement whole functionality from MySQL Administrator into Workbench at the moment.

Linux is not a supported platform for MySQL Administrator.

For more informations about supported platform please look here:

http://www.mysql.com/support/supportedplatforms/tools.html