How can we help you today? How can we help you today?

Undo behaviour

I did a POC on a trial version of Flyway Teams edition (9.2.3), I now have the latest vesion (9.16.1) and purchased a full license. 

So I have a test that has 4 Versioned files and 4 Undo files in the same directory, when I deploy into an empty database I get the followoing results after I migrate 

+-----------+---------+-------------------+------+---------------------+---------+----------+
| Category  | Version | Description       | Type | Installed On        | State   | Undoable |
+-----------+---------+-------------------+------+---------------------+---------+----------+
| Versioned | 0001    | Initial Table     | SQL  | 2023-03-30 12:57:35 | Success | Yes      |
| Versioned | 0002    | MoreStuff         | SQL  | 2023-03-30 12:57:35 | Success | Yes      |
| Versioned | 0003    | Add View          | SQL  | 2023-03-30 12:57:35 | Success | Yes      |
| Versioned | 0004    | Add Another Table | SQL  | 2023-03-30 12:57:35 | Success | Yes      |
+-----------+---------+-------------------+------+---------------------+---------+----------+

With the latest version of flyway teams I run the same process and I get the following results
+-----------+---------+-------------------+----------+---------------------+---------+----------+
| Category  | Version | Description       | Type     | Installed On        | State   | Undoable |
+-----------+---------+-------------------+----------+---------------------+---------+----------+
| Versioned | 0001    | Initial Table     | SQL      | 2023-03-30 13:13:25 | Success | Yes      |
| Versioned | 0002    | MoreStuff         | SQL      | 2023-03-30 13:13:25 | Success | Yes      |
| Versioned | 0003    | Add View          | SQL      | 2023-03-30 13:13:25 | Success | Yes      |
| Versioned | 0004    | Add Another Table | SQL      | 2023-03-30 13:13:25 | Success | Yes      |
| Undo      | 0001    | Initial Table     | UNDO_SQL |                     | Ignored |          |
| Undo      | 0002    | MoreStuff         | UNDO_SQL |                     | Ignored |          |
| Undo      | 0003    | Add View          | UNDO_SQL |                     | Ignored |          |
+-----------+---------+-------------------+----------+---------------------+---------+----------+

This does not look like correct behaviour to me, the only way to deploy on the latest is to use -outOfOrder=true





plynch1969
0

Comments

4 comments

Sort by
  • plynch1969
    forgot to mention the version that works in the way I expect is 9.2.3
    plynch1969
    0
  • Peter_Laws
    Hi plynch1969

    Thank you for reporting it, I already have a bug report for this behaviour and the development team are working on it, once resolved it will be referenced under issue 2258.

    In the meantime, 9.14.1 is the newest version that I'm aware of that's unaffected.
    Peter_Laws
    0
  • Peter_Laws
    I've performed more testing, the issue was introduced in v9.8.0.
    The work to resolve this is ongoing.
    Peter_Laws
    0
  • Peter_Laws
    Hello,

    Thank you for bearing with us, as of flyway v9.17.0, validate will no longer block you in this scenario.
    Please do let us know if you have any issues.
    Peter_Laws
    0

Add comment

Please sign in to leave a comment.