Bug #27899 Primary contains invalid column "newcolumn" during new table creation.
Submitted: 17 Apr 2007 19:01 Modified: 26 May 2009 11:54
Reporter: James Hood (Candidate Quality Contributor) Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.2.11 OS:MacOS
Assigned to: CPU Architecture:Any

[17 Apr 2007 19:01] James Hood 
Description:
The PK of a new table contains the invalid column "newcolumn" when the Primary Key checkbox in Column Detailed is ticked.

How to repeat:
1. Open the editor to create a new table.

2. Add a column.

3. Type in a new name, but don't finish editing the name yet.

4. Click the "Primary Key" checkbox in Column Details.

5. The new name is applied -after- the PK is created with the old "newcolumn" name.

6. Tick the Auto Increment checkbox. The PK now contains both the new column name and "newcolumn".

Suggested fix:
Apply pending field name changes before processing any checkbox actions.
[17 Apr 2007 19:18] Sveta Smirnova 
Thank you for the report.

Verified as described.
[26 May 2009 11:54] Susanne Ebrecht 
Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Administrator into MySQL Workbench. Unfortunately you are using an unsupported platform. More informations about supported platforms you will find here:

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

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/