What are the challenges you face when working across database platforms? Take the survey
Options

Undo behaviour

plynch1969plynch1969 Posts: 2 Bronze 1
edited March 30, 2023 9:10PM in Flyway (General Discussion)
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





Tagged:

Answers

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file