MySQL Bugs: #50214: Alter Table set Auto Increment don't works

Bug #50214	Alter Table set Auto Increment don't works
Submitted:	10 Jan 2010 15:50	Modified:	25 Nov 2010 17:28
Reporter:	pedro oriani	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.11, 5.2.27, 5.2.28	OS:	Any
Assigned to:	Alexander Musienko	CPU Architecture:	Any
Tags:	auto_increment

Description:
When using Alter Table to set a value for auto_increment only,
the form reports "No changes to object were detected".

How to repeat:
Right click on a table, select alter table, select 'options' tabs, change auto_increment value, press apply

this applies to both the live editor in query section, as well as when syncing a document to server

Also verified on 5.2.20 on Windows platform.

Bug #53878 has been marked as duplicate of this one

fix confirmed in repository

An entry has been added to the 5.2.22 changelog:

In SQL Editor, when using the Alter Table facility to set a column to Auto Increment (AI), the dialog reported that “No changes to object were detected”.

Bug #54146 has been marked as duplicate of this one

The bug is still present in 5.2.26 CE

Still present in 5.2.27 on Ubuntu 10.04 (x86, 32-bit)

No changes with new version, the bug is still present

Still present in 5.2.29 CE r 6756.
The next auto-increment key cannot be set using the GUI.

To save anyone a trip to the documentation, the syntax is:
ALTER TABLE [table_name] AUTO_INCREMENT = [value];

fix confirmed in repository

Changelog updated with new version 5.2.30.