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.