We are testing Liquibase in our environment and we have a changeset that is creating two tables and has a rollback at the end. Here is an example:
–changeset Developer1:createTable_AppetiteYearBuilt runInTransaction:true
CREATE TABLE [dbo].[AppetiteYearBuilt]
(
[StartYear] INT NOT NULL,
[EndYear] INT NOT NULL,
[IsFL] BIT NOT NULL,
[Score] INT NOT NULL,
CONSTRAINT PK_AppetiteYearBuilt PRIMARY KEY NONCLUSTERED([StartYear], [EndYear], [IsFL])
)
–rollback DROP TABLE [dbo].[AppetiteYearBuilt]
The changeset applied but when we try to do a rollback we are getting 0 changesets rolled back.
Any suggestions?