MySQL Bugs: #38128: Edit Table does not alter Primary Key

Bug #38128	Edit Table does not alter Primary Key
Submitted:	15 Jul 2008 10:13	Modified:	9 Oct 2008 12:07
Reporter:	Kai Sautter (Basic Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	1.2.12	OS:	Windows (XP SP3)
Assigned to:	Mike Lischke	CPU Architecture:	Any

Description:
If -for an existing table - the "Edit Table" (F2) function is used within Query Browser to drop the primary key constraint, this does not take effect. Though the table definition should be changed, Query Browser tells the user, that there is no need for a change to the table definition.

Apparently, this is only the case, if a second index is defined on the table. I have not investigated for more indices.

Within MySQL Administrator the same problem exists (version 1.2.12).

How to repeat:
Create a table with a varchar column as a primary index and a second index on another field. Then edit the table and graphically remove the primary index in the column list by changing the key symbol to a regular column type symbol (diamond). Select "Apply Changes".

The problem also exists for an integer column as the primary key.

Thank you for the bug report.

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html