sql changesets should allow setting of the tag attribute

Description

It seems there is a disconnect from these three concepts that can be easily unified.

Sql Changelogs (introduced in v 2.0)
https://www.liquibase.org/documentation/sql_format.html

To allow setting of 'tags' (which is supported in XML style changesets)
https://www.liquibase.org/documentation/changes/tag_database.html

To provide ability to support rollbacks by tag for Sql changelogs
https://www.liquibase.org/documentation/rollback.html

From the sql changelog we can set the label, but rollbacks are only available by: date, number, tag

Please add the ability to supply the tag in a sql changeset.

That sql changeset then could look like this:

--changeset john:test-tag context:update tag:test99
INSERT INTO MS_INFO( INFO_ID, INFO_NAME, INFO_VALUE) VALUES (99,'Test','N');
– rollback delete from MS_INFO where INFO_ID=99 ;

Environment

Mac/Linux/All

Activity

Show:

Details

Reporter

Components

Affects versions

Priority

Created February 11, 2020 at 5:49 PM
Updated February 11, 2020 at 5:49 PM