UNIQUE property parsing problem in CREATE TABLE

[GoogleCodeExporter]

Hi, 

this sql "CREATE TABLE TESTTBL (TESTCOL INT(1) UNIQUE NOT NULL)" produce
error [42001-109] 42001/42001.

When switch the "NOT NULL" with "UNIQUE" the table created succesfully.
(like this: "CREATE TABLE TESTTBL (TESTCOL INT(1) NOT NULL UNIQUE)")

Possible workaround add the not null check in the org.h2.command.Parser
parseCreateTable method, after line 4676.
-----8<-------
if (readIf("NOT")) {
    read("NULL");
    column.setNullable(false);
} else {
    readIf("NULL");
}
----->8-------

Original issue reported on code.google.com by ferenc.b...@gmail.com on 25 Mar 2009 at 2:07

[GoogleCodeExporter]

The workaround in patch file

Original comment by ferenc.b...@gmail.com on 25 Mar 2009 at 10:52

Attachments:

• org_h2_command_Parser_notnullunique.patch

[GoogleCodeExporter]

Thanks for your help! The syntax you used is supported by MySQL, so I will also
support it starting with the next release.

Original comment by thomas.t...@gmail.com on 25 Mar 2009 at 8:43

• Changed state: Accepted

[GoogleCodeExporter]

This create table (genenrated by eclipselink 1.1) works good in mysql, 
postgresql and
oracle xe (10g) too.
I attchached the example project.

Original comment by ferenc.b...@gmail.com on 25 Mar 2009 at 11:22

Attachments:

• uniquetest_maven_jpa.zip

[GoogleCodeExporter]

This should be fixed with todays release (1.1.110).
Please tell me if not, I will then re-open this bug.

Original comment by thomas.t...@gmail.com on 3 Apr 2009 at 3:59

• Changed state: Fixed

[GoogleCodeExporter]

Tested, works good.
Thanks.

Original comment by ferenc.b...@gmail.com on 7 Apr 2009 at 10:18