SqlServer Index Challenge

General Discussion
1

I am using mssql 2017 and liquibase 4.26.0 and I’m having a challenge with non-clustered indexes.

A t-sql file i have contains this

CREATE NONCLUSTERED INDEX IX_TGroup_CRMContactId  ON [dbo].[TGroup] ([CRMContactId]) INCLUDE ([GroupId])

I deploy the t-sql to a reference database using an includeAll and sqlcmd, which creates it correctly.

But when I diff-changelog between 2 databases the following changeset is produced, i.e. without the INCLUDE column.

- changeSet:
    id: 1713178532602-12
    author: ralexander
    changes:
    - createIndex:
        columns:
        - column:
            name: CRMContactId
        indexName: IX_TGroup_CRMContactId
        tableName: TGroup

Does anyone know how I can resolve this

2

FYI, the " INCLUDE ([GroupId]) " part of the index definition is a TSQL dialect extension. So it can’t be coded with the createIndex tag.
You can use the sql tag for example
`

  • changeSet:
    id: 1713178532602-12
    author: ralexander
    changes:
    • sql:
      dbms: ‘mssql’
      endDelimiter: \nGO
      splitStatements: true
      sql: CREATE NONCLUSTERED INDEX IX_TGroup_CRMContactId ON [dbo].[TGroup] ([CRMContactId]) INCLUDE ([GroupId])
      stripComments: true