I have this following index in my SQL Server DatabaseCREATE NONCLUSTERED INDEX XCR_ACTIVE ON dbo.CS_PA_VEH_BASE ( ETL_ACTIVE_FL ) WHERE ETL_ACTIVE_FL = ‘N’ ON “default”;
for which liquibase gives out following:
But when I want to execute it (also in MS SQL Server) I get the following error:
Function call <raise_exception ( Liquibase update error:
-1: Unexpected error running Liquibase: Incorrect syntax near ‘(’. [Failed SQL: CREATE NONCLUSTERED INDEX XCR_ACTIVE ON [dbo].CS_PA_VEH_DELTA] ) > failed, due to error <50316>: <Liquibase update error:
-1: Unexpected error running Liquibase: Incorrect syntax near ‘(’. [Failed SQL: CREATE NONCLUSTERED INDEX XCR_ACTIVE ON [dbo].CS_PA_VEH_DELTA]>.
I hope it’s not the first time this is happening to someone.