Bug #53878 Auto Increment is not updated
Submitted: 21 May 2010 12:06 Modified: 21 May 2010 14:48
Reporter: Daniel Bradley Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2.21 RC Revision 5918 OS:Any
Assigned to: CPU Architecture:Any
Tags: auto_increment workbench alter

[21 May 2010 12:06] Daniel Bradley 
Description:
When synchronizing or editing a live database you are not able to change the auto increment value in the table options. Not sure if this is due to the way the options are evaluated as being modified or two separate bugs in the synchronization and table alter modules. The modifying of the live table is easier to replicate so will describe that scenario below. 

How to repeat:
1) Select "Database" > "Query Database" and connect to a database.
2) Right click on a table in the overview tab and select "Alter Table"
3) Go to the "Options" tab and increase the "Auto Increment" value.
4) Click the "Apply" button and the message "No changes to object were detected." will be displayed.

Suggested fix:
If the Auto Increment value is changed an alter table command should be run to update the AUTO_INCREMENT value.
[21 May 2010 14:48] Johannes Taxacher 
this is a duplicate of bug# 50214