Bug #54146 Workbench Table Editor - Auto Increment - Unable to update
Submitted: 1 Jun 2010 14:08 Modified: 1 Jun 2010 14:35
Reporter: Gary Lockett Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2.21 OSS RC (Revision 5918) OS:Any
Assigned to: CPU Architecture:Any

[1 Jun 2010 14:08] Gary Lockett 
Description:
When updating the AUTO_INCREMENT value using the table editor in MySQL Workbench, clicking Apply returns "No changes to object were detected".

It is therefore impossible to alter the AUTO_INCREMENT value this way and a manual SQL statement has to be executed.

How to repeat:
Open a database in MySQL Workbench.
Right click on a table which has an automatically incremented column.
Choose "Alter Table".
Click the tab labelled "Options".
Where it says Auto Increment in the "General Options" area, try altering the value and then clicking apply.
The message "No changes to object were detected" is then displayed in red in the status bar of that dialogue box.

Suggested fix:
If the Auto Increment value is altered in the table editor, this should be detected as a change to be applied.
[1 Jun 2010 14:35] Johannes Taxacher 
this is a duplicate of Bug #50214