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

MariaDB-Migrations hang when IF is multiline #2853

Closed
htto opened this issue Jun 10, 2020 · 0 comments
Closed

MariaDB-Migrations hang when IF is multiline #2853

htto opened this issue Jun 10, 2020 · 0 comments
Assignees
Milestone

Comments

@htto
Copy link

@htto htto commented Jun 10, 2020

Which version and edition of Flyway are you using?

6.4.3 (broken since 6.4.1, assuming 9235c04)

Which client are you using? (Command-line, Java API, Maven plugin, Gradle plugin)

Flyway CLI Community

Which database are you using (type & version)?

mariadb Ver 15.1 Distrib 10.3.22-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

Which operating system are you using?

Distributor ID: Debian
Description: Debian GNU/Linux 10 (buster)
Release: 10
Codename: buster

What did you do?

cat database/V20200610_113700__flyway_bug.sql

IF
1 = 0
 THEN                                                                                                                   
    SELECT 1;
 ELSE
    SELECT 0;
END IF;   
What did you expect to see?

The same as with 'IF 1=0' on one line

DEBUG: Executing SQL: IF 1 = 0
 THEN                                                                                                                   
    SELECT 1;
 ELSE
    SELECT 0;
 END IF
+---+
| 0 |
+---+
| 0 |
+---+
What did you see instead?

Hang with

DEBUG: Parsing V20200610_113700__flyway_bug.sql ...

and hogging 150% CPU for me

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants