We're updating the issue view to help you get more done. 

ValidationFailedException v2: clustered is not allowed on h2

Description

The issue is very similar to CORE-2682, I receive a ValidationException when I would like to use clustered="false" in a H2 database.

I use the xml below, which differs from the example in the above mentioned issue. It uses the clustered="false" in the addPrimaryKey tag instead of using it in the createIndex tag.

1 2 3 4 5 6 7 8 9 10 11 <changeSet id="1" author="Adam"> <createTable tableName="my_table"> <column name="id" type="uuid"> <constraints nullable="false"/> </column> <column name="name" type="nvarchar(100)"> <constraints nullable="false"/> </column> </createTable> <addPrimaryKey tableName="my_table" clustered="false" columnNames="id" constraintName="PK_my_table"/> </changeSet>

Thank you in advance,
Adam

Environment

H2

Status

Assignee

Unassigned

Reporter

Ádám T. Nagy

Labels

None

Components

Affects versions

3.5.3
3.6.3

Priority

Major