By pass failed sql

Community Answers
1

Is it possible to bypass the failed script.
For e.g:
I have following folder structure

1.Change_Request_1
a.sql
b.sql

2.Change_Request_2
c.sql
d.sql

3.Change_Request_3
e.sql
f.sql

Is it possible to deploy Change_Request_3 if the c.sql from Change_Request_2 fails.

In this case the d.sql from Change_Request_2 should not be deployed. If c.sql from Change_Request_2 fails can it come out of Change_Request_2 folder and deploy from Change_Request_3 folder files (e.sql and f.sql)

2

You could add the failOnError:false attribute to the c.sql to not stop the execution if c.sql fails.

See changeset | Liquibase Docs for more details.