Get the most out of Flyway v7 - Sign up for our webinar on the Redgate Hub ▶ Watch now
We frequently get bugs about the Flyway parser being unable to handle certain sql scripts. This page was created to document some of the known issues and workarounds.
If none of the workarounds work for you, or if you think the workaround is unsuitable for any reason, then please create a GitHub issue with reproduction steps, including the contents of the file, or attaching the file itself if possible.
If you see any of the error messages
Delimiter changed inside statement,
Incomplete statement, or
Unable to decrease block depth below 0 it may be because Flyway’s control flow handling encountered an error. This can be caused by a number of different reasons:
IFnot closed by an
END, but may also include
WHILE, and more depending on database type. In this case please change the variable name to one that is not used for control flow.
© 2010-2020 Redgate. Made with in Cambridge.
Flyway is a registered trademark of Red Gate Software Ltd.
All other trademarks, trade names, logos or service marks mentioned on this site belong to their respective owners.
This site collects anonymous usage information through Google Analytics.