MSSQL stored procedure GO issue with includeAll configuration

General Discussion
7

Hi,

Thank You all for the answers given so far.

I prefer setting delimiter globally and already tried setting it in liquibase.properties file but the parameter seems to be ignored.

liquibase.properties
delimiter=GO

update output:

Unexpected error running Liquibase: Migration failed for changeset changes/08_CreateSomeTable.sql::raw::includeAll:
     Reason: liquibase.exception.DatabaseException: Incorrect syntax near 'GO'. [Failed SQL: (102) USE [LiquibaseTest1]
GO
CREATE TABLE [dbo].[table3](
	[Id] [int] NOT NULL,
	[Description] [varchar](50) NULL
 CONSTRAINT [PK_table3] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]]
Logs saved to C:\data\LiquibaseProjects\LocalTester\liquibase.log

liquibase.log:

[2022-10-10 11:29:04] WARNING [liquibase.configuration] Potentially ignored key(s) in file C:\data\LiquibaseProjects\LocalTester\liquibase.properties
 - 'delimiter'

I found this post from 2020 stating that liquibase online documentation is wrong about the delimiter param and endDelimiter should be used instead:

However, the result is the same:

liquibase.properties
endDelimiter=GO

liquibase.log:

[2022-10-10 11:37:27] WARNING [liquibase.configuration] Potentially ignored key(s) in file C:\data\LiquibaseProjects\LocalTester\liquibase.properties
 - 'endDelimiter'

Can anyone check this please? Is there anyone to set endDelimiter in liquibase.properties file?