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

unsupported SQL*Plus statement: SPOOL #2674

Closed
emarcellus opened this issue Feb 12, 2020 · 2 comments
Closed

unsupported SQL*Plus statement: SPOOL #2674

emarcellus opened this issue Feb 12, 2020 · 2 comments

Comments

@emarcellus
Copy link

emarcellus commented Feb 12, 2020

Which version and edition of Flyway are you using?

/opt/flyway/flyway -v -pro
Flyway Pro Edition 6.2.1 by Redgate

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)
6.2.1 is the latest version

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

Command-line

Which database are you using (type & version)?

Oracle 12.2

Which operating system are you using?

Red Hat Enterprise Linux 6
Linux 2.6.32-754.25.1.el6.x86_64 #1 SMP Wed Nov 20 15:07:26 EST 2019 x86_64 x86_64 x86_64 GNU/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.)
flyway -pro -outputFile=outfile.txt -configFiles=file.conf info

The issues happens with info, migrate & baseline. I suspect others as well but these are the 3 command options I am using currently.

What did you expect to see?

No warnings for unsupported SQL*Plus statements

What did you see instead?

WARNING: Detected unsupported SQLPlus statement: SPOOL OFF
-> Please file an issue requesting support at https://github.com/flyway/flyway/issues
WARNING: Detected unsupported SQL
Plus statement: SPOOL /spoolfile.log
-> Please file an issue requesting support at https://github.com/flyway/flyway/issues

@MikielAgutu
Copy link

MikielAgutu commented Feb 13, 2020

To clarify, we don't necessarily claim to support all SQL*Plus commands. See the docs:

All other SQL*Plus commands are gracefully ignored with a warning message.

Of course we'll consider adding support for more commands in future releases.

@MikielAgutu MikielAgutu added this to the Flyway 6.x milestone Feb 13, 2020
@juliahayward juliahayward modified the milestones: Flyway 6.x, Flyway 6.2.4 Feb 18, 2020
@juliahayward
Copy link
Member

juliahayward commented Feb 18, 2020

I have a fix, hopefully going in 6.2.4

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