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

Inline comments for SQL*Plus DEFINE statements fail #2484

Closed
alextercete opened this issue Aug 27, 2019 · 1 comment

Comments

@alextercete
Copy link
Member

commented Aug 27, 2019

Which version and edition of Flyway are you using?

6.0.0

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

CLI

Which database are you using (type & version)?

Oracle 19.3

Which operating system are you using?

Windows

What did you do?

Set oracle.sqlplus=true and run migration:

SET DEFINE ON
DEFINE test = 'value' -- test comment
SELECT '&test' FROM dual;
SET DEFINE OFF
What did you expect to see?

Migration succeeds.

What did you see instead?

Migration fails with:

SQL State  : 42000
Error Code : 923
Message    : ORA-00923: FROM keyword not found where expected
[...]
Statement  : SELECT ''value' -- test comment' FROM dual

@alextercete alextercete added this to the Flyway 6.0.1 milestone Aug 28, 2019

@alextercete

This comment has been minimized.

Copy link
Member Author

commented Aug 28, 2019

This has been fixed and it will be released in Flyway 6.0.1

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