Flyway always execute repeatable migrations

Question

Is it possible to execute repeatable migrations in flyway even when the checksum is the same? The problem I am facing is having a view which extends another table with additional rows and the view doesn't get updated automatically.

An example here:

R__person_view.sql

CREATE OR REPLACE VIEW person_view AS 
    SELECT p.*, e.name FROM person p, entity e
    WHERE /* not relevant here ... */;

If this migration is executed at first it will work fine. If I add another migration, where I modify the table person, the changes are not adapted, because the view migration checksum did not change.

David Atkinson David Atkinson · Accepted Answer · 2020-07-25T17:53:12

Yes, from Flyway 6.3.0 it has been possible to have repeatable migrations run each time using the timestamp placeholder in a comment, ensuring that Flyway sees this as being changed afresh each time. For example:

R__UtilityProcedures.sql
-- ${flyway:timestamp}
create or replace procedure my_important_proc

Flyway always execute repeatable migrations

1 Answers