Parser Limitation - Incomplete statement at line 1 col 1

[kayla-kirzinger]

Which version and edition of Flyway are you using?

9.21.1 Teams edition

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)

Please advise - it will be disruptive to upgrade so I can't really just test that casually, we are in the middle of a very high priority migration. If this is something that has a known resolution in a newer version

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

Command-line

Which database are you using? (Type & version)

Snowflake - N/A

Which operating system are you using?

Linux RHEL

What did you do? (Please include the content causing the issue, any relevant configuration settings, the SQL statement(s) that failed (if any), and the command you ran)

Ran the attached statement in an R file via Azure Devops pipeline. Please let me know what other information is relevant.

What did you expect to see?

Successful migration.

What did you see instead?

Unable to parse statement in C:\agent_work\16\s\2. Integration\SEM_DATA\StoredProcedures\R__0035_JOR_COST_RECAP_BYACCTCODE_LOAD.sql at line 1 col 1. See https://rd.gt/3ipi7Pm for more information: Incomplete statement at line 1 col 1

flyway_bad.txt

[kayla-kirzinger]

Sorry I was mistaken - it is a Windows runtime not RHEL.