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

SQLite: UNIQUE index on multiple columns

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects versions: 3.6.3
    • Fix versions: None
    • Components: Database Support
    • Environment:

      Windows 7, xerial/sqlite-jdbc 3.23.1

    • Sprint:

      Description

      SQLite supports UNIQUE key on multiple columns:

      create table foo (
      ...
      UNIQUE (col1, col2, col3)
      );
      

      This works only at create table level.
      addUniqueConstraint generates 'addUniqueConstraint is not supported on sqlite'.

      Maybe you can add createTable-level <uniqueConstraint> for such situations?

      <createTable tableName="foo">
          <column .... />
          .....
          <uniqueConstraint name="uk" columnNames="..." />
      

        Attachments

          Activity

            People

            • Reporter:
              darth.naihil Anatoliy Golubev
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: