Uploaded image for project: 'Liquibase Core'
  1. CORE-3381

ValidationFailedException v2: clustered is not allowed on h2

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects versions: 3.5.3, 3.6.3
    • Fix versions: None
    • Components: Changelog Parameters
    • Environment:

      H2

    • Sprint:

      Description

      The issue is very similar to CORE-2682 Open , 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.

      <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

        Attachments

          Activity

            People

            • Reporter:
              tnagy.adam Ádám T. Nagy
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: