Hello,
Liquibase Community 4.17.2 #5255 on Windows
This is either a doc bug or a product bug. Not sure which.
I’m following the JSON example from this documentation page.
Whichever file is the last in the list is the only one run.
The JSON is aberrant (trying to set the same property multiple times) and the include should probably be an array or list. But Liquibase threw errors for the variations I guessed at.
Reproduction
This file is a copy-paste of the documentation with the filenames changed.
Changelog_UsingInclude.json
{
"databaseChangeLog": [
{
"include": {"file": "cl2.mssql.sql"},
"include": {"file": "cl1.mssql.sql"}
}
]
}
And two SQL files
c1.mssql.sql
-- liquibase formatted sql
--
--changeset xxxxx:1
IF OBJECT_ID('[dbo].[tab1]', 'U') IS NULL
CREATE TABLE [dbo].[tab1]
(
[col1] NVARCHAR(120) NOT NULL
)
GO
c2.mssql.sql
-- liquibase formatted sql
--
--changeset xxxxx:1
IF OBJECT_ID('[dbo].[tab2]', 'U') IS NULL
CREATE TABLE [dbo].[tab2]
(
[col1] NVARCHAR(120) NOT NULL
)
GO