It seems there is a disconnect from these three concepts that can be easily unified.
Sql Changelogs (introduced in v 2.0)
To allow setting of 'tags' (which is supported in XML style changesets)
To provide ability to support rollbacks by tag for Sql changelogs
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 ;