H2 mode MySQL- enum('9','10') not supported

[GoogleCodeExporter]

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 `test` (
  `version` enum('9','10') NOT NULL DEFAULT '9',
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

3.The returned error is : Caused by: org.h2.jdbc.JdbcSQLException: Unknown data 
type: "ENUM"; SQL statement:
CREATE TABLE `test` ( `version` enum('9','10') NOT NULL DEFAULT '9', ) 
ENGINE=InnoDB DEFAULT CHARSET=utf8 [50004-172]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
    at org.h2.message.DbException.get(DbException.java:171)
    at org.h2.message.DbException.get(DbException.java:148)
    at org.h2.command.Parser.parseColumnWithType(Parser.java:3720)
    at org.h2.command.Parser.parseColumnForTable(Parser.java:3583)
    at org.h2.command.Parser.parseCreateTable(Parser.java:5305)
    at org.h2.command.Parser.parseCreate(Parser.java:3872)
    at org.h2.command.Parser.parsePrepared(Parser.java:324)
    at org.h2.command.Parser.parse(Parser.java:279)
    at org.h2.command.Parser.parse(Parser.java:251)
    at org.h2.command.Parser.prepareCommand(Parser.java:218)
    at org.h2.engine.Session.prepareLocal(Session.java:428)
    at org.h2.engine.Session.prepareCommand(Session.java:377)
    at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)
    at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:168)
    at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156)
    at org.springframework.jdbc.datasource.init.ResourceDatabasePopulator.executeSqlScript(ResourceDatabasePopulator.java:186)
    ... 51 more

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

What version of the product are you using? On what operating system, file
system, and virtual machine?
- H2 v1.3.172 (SVN 4956)
- 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 16 Jul 2013 at 1:05

[GoogleCodeExporter]

Hi Guys,

May I have your feedback on this one ?

Thanks

Original comment by queeq...@gmail.com on 19 Jul 2013 at 6:01

[GoogleCodeExporter]

Hi,

Well, I'm not trying to build a MySQL clone.

Sorry, but I don't view this as an important use case. You could just use 
VARCHAR or INT, and use a constraint.

Original comment by thomas.t...@gmail.com on 20 Jul 2013 at 5:26

[GoogleCodeExporter]

Original comment by thomas.t...@gmail.com on 20 Jul 2013 at 5:26

• Changed state: WontFix

[GoogleCodeExporter]

Hi ! Same problem here, what use case would you deem acceptable for use of H2 ? 
Fast Unit testing of MySQL proprietary code is kinda interesting ! Anyway, I 
have the same problem and will try to make a patch. Will post here when done !

Original comment by pierre.c...@trinov.com on 7 Oct 2013 at 4:22