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 # not supported #2571

Closed
BartBM opened this issue Nov 21, 2019 · 1 comment
Closed

Delimiter # not supported #2571

BartBM opened this issue Nov 21, 2019 · 1 comment

Comments

@BartBM
Copy link

@BartBM BartBM commented Nov 21, 2019

Which version and edition of Flyway are you using?

6.0.8

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

It is the latest (stable) version.

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

Java API.

Which database are you using (type & version)?

Mariadb 10.4.2

Which operating system are you using?

MacOS

What did you do?

The delimiter # does not work. It did with flyway 5.x
Workaround: use delimiter //

delimiter #
create procedure someProcedure() BEGIN
END #
delimiter ;
call someProcedure();
What did you expect to see?

Successful migrations.

What did you see instead?

SQL State : 42000
Error Code : 1305
Message : (conn=150) PROCEDURE someProcedure does not exist

@alextercete alextercete added this to the Flyway 6.2.0 milestone Nov 22, 2019
@juliahayward juliahayward removed this from the Flyway 6.x milestone Dec 4, 2019
@juliahayward juliahayward added this to the Flyway 6.1.1 milestone Dec 4, 2019
@juliahayward
Copy link
Member

@juliahayward juliahayward commented Dec 4, 2019

The error is that # was still being seen as an alternative single line comment - which is overridden temporarily by DELIMITER #. A fix will be included in 6.1.1.

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