Undo behaviour
plynch1969
Posts: 2 Bronze 1
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
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
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
This does not look like correct behaviour to me, the only way to deploy on the latest is to use -outOfOrder=true
Tagged:
Answers
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.
The work to resolve this is ongoing.
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.