CREATE TABLE dbo.testTable
(
ID nchar(10) NOT NULL,
TestDate datetime2(3) NULL
)
go
ALTER TABLE dbo.testTable ADD CONSTRAINT
PK_testTable PRIMARY KEY( ID)
GO
CREATE VIEW dbo.vw_test
WITH SCHEMABINDING
AS
SELECT
TestDate, COUNT(1) AS Expr1
FROM
dbo.testTable
GROUP BY TestDate
GO
CREATE UNIQUE CLUSTERED INDEX IX_Test_TestDate
ON vw_test (TestDate);
GO
Liquibase with version 3.4.1 somehow drops the with option and does not create the indexed view. It gives the sql error when trying to create unique clustered index. Is there any solution or work around for this?