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

Delimiter changed inside statement #2781

Closed
SamuraiPrinciple opened this issue Apr 21, 2020 · 2 comments
Closed

Delimiter changed inside statement #2781

SamuraiPrinciple opened this issue Apr 21, 2020 · 2 comments

Comments

@SamuraiPrinciple
Copy link

SamuraiPrinciple commented Apr 21, 2020

Which version and edition of Flyway are you using?

6.4.0

If this is not the latest version, can you reproduce the issue with the latest one as well?

(Many bugs are fixed in newer releases and upgrading will often resolve the issue)

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

Command-line

Which database are you using (type & version)?

MySQL 8.0.19

Which operating system are you using?

macOS, Linux

What did you do?

(Please include the content causing the issue, any relevant configuration settings, the SQL statement that failed (if relevant) and the command you ran.)

delimiter $$
create procedure p()
begin
select if(1, 2, 3) from dual;
end$$
delimiter ;

What did you expect to see?

Successful migration

What did you see instead?

ERROR: Unable to parse statement in sql/egames_limited_series_ml/R__0004_egames_limited_series_ml.sql at line 2 col 1: Delimiter changed inside statement at line 2 col 1: create procedure p()
begin
select if(1, 2, 3) from dual;
end$$

@francescopeloi
Copy link

francescopeloi commented May 10, 2020

Hi, I am a bit confused because I am getting the problem described in this issue with 6.4.1 but not with 6.4.0. Was it supposed to be fixed in 6.4.1?

@francescopeloi
Copy link

francescopeloi commented May 10, 2020

Ok. If only I searched before posting. I guess it's already covered here: #2807

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