Bug #54289 synchronizing, AUTO_INCREMENT= statements
Submitted: 7 Jun 2010 11:46 Modified: 14 Jun 2010 21:42
Reporter: Markus Gschwendt Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:wb5.2.22 OS:Linux (Ubuntu 10.4, 64bit)
Assigned to: CPU Architecture:Any
Tags: ALTER TABLE, auto_increment, error 1064, synchronizing

[7 Jun 2010 11:46] Markus Gschwendt 
Description:
on synchronizing a model with the server, the update script contains for all tables with AI columns an alter table statement like this:

ALTER TABLE <db>.<table> AUTO_INCREMENT = ;

and on executing an error message: Error 1064 ...error in SQL syntax...

How to repeat:
synchronizing a model with the server

Suggested fix:
statement should be build the right way
[7 Jun 2010 12:09] Markus Gschwendt 
a workaround would be to edit the statements manually before executing.
[7 Jun 2010 22:38] Chris Nanney 
Came here to report this.
[14 Jun 2010 21:42] Johannes Taxacher 
this is a duplicate of Bug #54319