MySQL Bugs: #6734: Primary key display does not update when you change the name of the column

Bug #6734	Primary key display does not update when you change the name of the column
Submitted:	21 Nov 2004 0:50	Modified:	30 Nov 2004 22:06
Reporter:	Derek Thomas	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.1.1 Gamma	OS:	Windows (Win XP)
Assigned to:	Michael G. Zinner	CPU Architecture:	Any

Description:
When creating a new table by default the first key you create is the primary key; however if you change the name of this column it doesnt update the primary key sub window so when you create the table the execution fails.

How to repeat:
Create a new schema.
Create a new table in the scheme.
Create the first field maybe called "foo" and it is assumed to be the primary key.
Change the name of the field maybe to "bar". (Notice that the field name in the primary key display still says "foo" when no field named foo exists.)

Suggested fix:
Make sure that column names displayed in sub windows are synconized with the column names that are used in the column editor.

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 bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html