Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Dry Run fails to recognise baseline version #2562

Closed
MikielAgutu opened this issue Nov 13, 2019 · 1 comment
Closed

Dry Run fails to recognise baseline version #2562

MikielAgutu opened this issue Nov 13, 2019 · 1 comment

Comments

@MikielAgutu
Copy link
Member

@MikielAgutu MikielAgutu commented Nov 13, 2019

From Dennis Jansen via an email

Hi,
we have upgrade from Flyway 5.2.4 to 6.0.8 and now we have an unexpected behavior.
In our testcase we have 4 migration scripts:

V20170309100000000__8.3_init.sql
V20170309100000001__8.4.sql
V20170309100000002__8.5.sql
V20170309100000010__10.4.2-48_Test_1.sql

If i set the baseline version to „20170309100000002“ i would expect, that there are only the schema_version and one script „20170309100000010“ in dryrun output.

But dryrun shows all scripts in the output-file.

Flyway does not recocnize the baseline version in dryrun mode.

It seems to be a bug. In flyway 5.2.4 it was correct.

---====================================

-- Flyway Dry Run (2019-11-08 16:37:28)

---====================================

 

SET SCHEMA "PUBLIC";

 

-- Executing: baseline (with callbacks)

------------------------------------------------------------------------------------------

CREATE TABLE IF NOT EXISTS "PUBLIC"."TDBSCHEMAVERSION" (

    "installed_rank" INT NOT NULL,

    "version" VARCHAR(50),

    "description" VARCHAR(200) NOT NULL,

    "type" VARCHAR(20) NOT NULL,

    "script" VARCHAR(1000) NOT NULL,

    "checksum" INT,

    "installed_by" VARCHAR(100) NOT NULL,

    "installed_on" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

    "execution_time" INT NOT NULL,

    "success" BOOLEAN NOT NULL,

    CONSTRAINT "TDBSCHEMAVERSION_pk" PRIMARY KEY ("installed_rank")

) AS SELECT -1, NULL, '<< Flyway Schema History table created >>', 'TABLE', '', NULL, 'SA', CURRENT_TIMESTAMP, 0, TRUE;

INSERT INTO "PUBLIC"."TDBSCHEMAVERSION" ("installed_rank", "version", "description", "type", "script", "checksum", "installed_by", "execution_time", "success") VALUES (1, '20170309100000002', '8.5', 'BASELINE', '8.5', NULL, 'SA', 0, 1);

CREATE INDEX "PUBLIC"."TDBSCHEMAVERSION_s_idx" ON "PUBLIC"."TDBSCHEMAVERSION" ("success");

SET SCHEMA "PUBLIC";

 

-- Executing: migrate (with callbacks)

------------------------------------------------------------------------------------------

SET SCHEMA "PUBLIC";

 

-- Executing: migrate -> v20170309100000000 (with callbacks)

------------------------------------------------------------------------------------------

 

-- Source: migration/shortTest/common/V20170309100000000__8.3_init.sql

----------------------------------------------------------------------

CREATE TABLE TBEISPIEL ( 

                ATTVARCHAR VARCHAR(20) NOT NULL,

                ATTDECIMAL DECIMAL(16,0)

                );

INSERT INTO "PUBLIC"."TDBSCHEMAVERSION" ("installed_rank", "version", "description", "type", "script", "checksum", "installed_by", "execution_time", "success") VALUES (1, '20170309100000000', '8.3 init', 'SQL', 'V20170309100000000__8.3_init.sql', 1504380838, 'SA', 519, 1);

SET SCHEMA "PUBLIC";

 

-- Executing: migrate -> v20170309100000001 (with callbacks)

------------------------------------------------------------------------------------------

 

-- Source: migration/shortTest/common/V20170309100000001__8.4.sql

-----------------------------------------------------------------

INSERT INTO TBEISPIEL (ATTVARCHAR, ATTDECIMAL) VALUES ('Beispieltest', 99);

INSERT INTO "PUBLIC"."TDBSCHEMAVERSION" ("installed_rank", "version", "description", "type", "script", "checksum", "installed_by", "execution_time", "success") VALUES (2, '20170309100000001', '8.4', 'SQL', 'V20170309100000001__8.4.sql', 414608062, 'SA', 57, 1);

SET SCHEMA "PUBLIC";

 

-- Executing: migrate -> v20170309100000002 (with callbacks)

------------------------------------------------------------------------------------------

 

-- Source: migration/shortTest/common/V20170309100000002__8.5.sql

-----------------------------------------------------------------

INSERT INTO TBEISPIEL (ATTVARCHAR, ATTDECIMAL) VALUES ('Beispieltest2', 100);

INSERT INTO "PUBLIC"."TDBSCHEMAVERSION" ("installed_rank", "version", "description", "type", "script", "checksum", "installed_by", "execution_time", "success") VALUES (3, '20170309100000002', '8.5', 'SQL', 'V20170309100000002__8.5.sql', -295128922, 'SA', 11, 1);

SET SCHEMA "PUBLIC";

 

-- Executing: migrate -> v20170309100000010 (with callbacks)

------------------------------------------------------------------------------------------

 

-- Source: migration/shortTest/h2/V20170309100000010__10.4.2-48_Test_1.sql

--------------------------------------------------------------------------

CREATE TABLE TEXAMPLE ( 

                ATTVARCHAR2 VARCHAR(20) NOT NULL,

                ATTDECIMAL2 DECIMAL(16,0)

                );

INSERT INTO TEXAMPLE (ATTVARCHAR2, ATTDECIMAL2) VALUES ('test', 1);

INSERT INTO "PUBLIC"."TDBSCHEMAVERSION" ("installed_rank", "version", "description", "type", "script", "checksum", "installed_by", "execution_time", "success") VALUES (4, '20170309100000010', '10.4.2-48 Test 1', 'SQL', 'V20170309100000010__10.4.2-48_Test_1.sql', 929687905, 'SA', 12, 1);

SET SCHEMA "PUBLIC";

SET SCHEMA "PUBLIC";
@juliahayward juliahayward changed the title Flyway 6.0.8 Dryrun bug Dry Run fails to recognise baseline version Nov 19, 2019
@juliahayward

This comment has been minimized.

Copy link
Member

@juliahayward juliahayward commented Nov 19, 2019

Fix will be released in 6.1.0.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
2 participants
You can’t perform that action at this time.