H2 mode MySQL- AUTO_INCREMENT not supported

Please send a question to the H2 Google Group or StackOverflow first,
and only then, once you are completely sure it is an issue, submit it here.
The reason is that only very few people actively monitor the issue tracker.

Before submitting a bug, please also check the FAQ:
http://www.h2database.com/html/faq.html

What steps will reproduce the problem?
(simple SQL scripts or simple standalone applications are preferred)
1.Start h2 with MODE=MySQL 
2.create table employee(
empid BIGINT AUTO_INCREMENT,
first_name varchar(50),
last_name varchar(50)
) ENGINE=InnoDB AUTO_INCREMENT=42 CHARSET=utf8;

3.The returned error is :Caused by: org.h2.jdbc.JdbcSQLException: Syntax error 
in SQL statement "CREATE TABLE EMPLOYEE( EMPID BIGINT AUTO_INCREMENT, 
FIRST_NAME VARCHAR(50), LAST_NAME VARCHAR(50) ) ENGINE=INNODB 
AUTO_INCREMENT[*]=42 CHARSET=UTF8 "; SQL statement:
create table employee( empid BIGINT AUTO_INCREMENT, first_name varchar(50), 
last_name varchar(50) ) ENGINE=InnoDB AUTO_INCREMENT=42 CHARSET=utf8 [42000-172]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
    at org.h2.message.DbException.get(DbException.java:169)
    at org.h2.message.DbException.get(DbException.java:146)
    at org.h2.message.DbException.getSyntaxError(DbException.java:181)
    at org.h2.command.Parser.getSyntaxError(Parser.java:484)
    at org.h2.command.Parser.prepareCommand(Parser.java:233)
    at org.h2.engine.Session.prepareLocal(Session.java:425)
    at org.h2.engine.Session.prepareCommand(Session.java:374)
    at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)
    at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:167)
    at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:155)
    at org.springframework.jdbc.datasource.init.ResourceDatabasePopulator.executeSqlScript(ResourceDatabasePopulator.java:186)
    ... 51 more

What is the expected output? What do you see instead?

The table should have been created successfully 

What version of the product are you using? On what operating system, file
system, and virtual machine?
- H2 v1.3.172
- Windows 7 64bit
- java version "1.7.0_17"
Java(TM) SE Runtime Environment (build 1.7.0_17-b02)
Java HotSpot(TM) 64-Bit Server VM (build 23.7-b01, mixed mode)

Do you know a workaround?
No

What is your use case, meaning why do you need this feature?

How important/urgent is the problem for you?

Please provide any additional information below.
Original issue reported on code.google.com by queeq...@gmail.com on 12 Jul 2013 at 5:07
ilovejs / h2database

H2 mode MySQL- AUTO_INCREMENT not supported #488
