How to rollback changeSetId using SQL Dialect

General Discussion
,
1

I am intrigued by the rollback capability that allows you to reference the changeset that originally created a statement:

<changeSet id="changeRollback2-drop" author="liquibase">
  <dropTable tableName="changeRollback2"/>
  <rollback changeSetId="changeRollback2-create" changeSetAuthor="liquibase"/>
</changeSet>

How can we do this using the SQL Dialect?

1 Like
2

Welcome whitford.

Rollback to changeSetId is currently only availabe in XML changelogs.

1 Like
3

Thanks for confirming. I found an open issue – with a PR! :crossed_fingers:

4

LOL The guy that opened that PR works at my company.

1 Like
5

Lol. Hey Daryl. That PR never got much traction…I am still willing to help get it into the mainline if a maintainer takes any interest.