Liquibase - Multi-line SQL rollback using rollbackSplitStatements and rollbackEndDelimiter

user_3006906 0
Viewed 3648

In 3.5.2 rollbackSplitStatements and rollbackEndDelimiter were introduced to allow us to write our rollback statements in multiple lines and not have to tag every line with "--rollback" or at least I am assuming that from the PR (https://github.com/liquibase/liquibase/pull/334).

But I have not see any documentation on how to use it.

As an example: 

--changeset auth:1.1 rollbackSplitStatements:false rollbackEndDelimiter:/
DELETE FROM my_table WHERE id = 3;
--rollback
insert into my_table values (
  3,
  'firstname',
  'lastname'
);
/

This throws an error during migrate:
Unexpected error running Liquibase: ERROR: syntax error at or near "/"

Alternatively this does not throw an error but does execute the statement under "--rollback" during migrate: 

--changeset auth:1.1 
DELETE FROM my_table WHERE id = 3;
--rollback rollbackSplitStatements:false rollbackEndDelimiter:/
insert into my_table values (
  3,
  'firstname',
  'lastname'
);
/
liquibase rollback
1 Answers

I wish multi-line rollback worked the way you presented. I am using 3.5.3, still had to put --rollback in front of each line as

--changeset auth:1.1 rollbackSplitStatements:false
DELETE FROM my_table WHERE id = 3;
--rollback insert into my_table values (
--rollback  3,
--rollback  'firstname',
--rollback  'lastname'
--rollback);

In fact, the rollbackSplitStatements setting does not seem to make any difference in my tests.

user_41793570
Related