Rollback to tag and tagDatabase

General Discussion
1

Is this a valid changeset:

- changeSet:
    id: 2026.05.18.090100-001
    author: nowhere man
    dbms: oracle
    comment: Load Table 
    changes:
       - tagDatabase:
           tag: 2026.05.18.090100-001
       - sqlFile:
           endDelimiter: '/'
           encodig: UTF-8
       ...

So this changeset includes the tagDatabase und the sqlFile change type.

The update command works fine, but the rollback to tag 2026.05.18.090100-001 contains all changes after this tag, the tag himself is not included.

Now I’m trying a different one

- changeSet:
    id: 2026.05.18.090100-001
    author: nowhere man
    dbms: oracle
    comment: Load Table 
    changes:
       - tagDatabase:
           tag: 2026.05.18.090100-001
- changeSet:
    id: 2026.05.18.090100-001
    author: nowhere man
    dbms: oracle
    comment: Load Table 
    changes:
       - sqlFile:
           endDelimiter: '/'
           encodig: UTF-8
       ...

In my opinion, it’s the same procedure, but the rollback to tag 2026.05.18.090100-001 contains all changes after this tag, the tag himself is also included.

What am I overlooking?

Thanks

andreas

2

I’m pretty sure that tagDatabase change-type needs to be isolated in it’s own changeset, not grouped with other changes.

3

Thanks for your reply. I agree with you, but I’m surprised that both methods work yet behave differently during a rollback.

I need to develop a template that will serve as the basis for all our implementations, so I’d really like to understand this.

Thanks for your help, i’ll look into it further and appreciate any ideas.

Many thanks,

Andreas

4

addendum

Here’s what I found:

It is a best practice to specify only one type of change per changeset

It’s just a suggestion, but I’ll go ahead and do it that way.