MySQL syntax for autoincrement column with start value

Description

When providing a startsWith attribute in a column tag with the autoincrement attribute set to true the following (exemplary) sql is generated by Liquibase:

CREATE TABLE `tab1`
(`Id` INT AUTO_INCREMENT=100 NOT NULL)

However, the MySQL syntax forbids the declaration of the starting value right after the AUTO_INCREMENT statement, instead it has to be placed as table option after the parenthesis of the table definition:

CREATE TABLE `tab1`
(`Id` INT AUTO_INCREMENT NOT NULL) AUTO_INCREMENT=100

Environment

MySQL 5.1

Status

Reporter

T. Schmidt

Components

Fix versions

Affects versions

Priority

Major
Configure