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
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.2.12 OS:Microsoft Windows (XP SP3)
Assigned to: Mike Lischke Target Version:
Triage: D2 (Serious)

[15 Jul 2008 10:13] Kai Sautter 
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.
[15 Jul 2008 15:29] Miguel Solorzano 
Thank you for the bug report.
[9 Oct 2008 12:07] Mike Lischke 
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