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

"Flyway parsing bug" error when processing SAP HANA view #2624

Closed
stesix opened this issue Jan 14, 2020 · 1 comment
Closed

"Flyway parsing bug" error when processing SAP HANA view #2624

stesix opened this issue Jan 14, 2020 · 1 comment

Comments

@stesix
Copy link

@stesix stesix commented Jan 14, 2020

Which version and edition of Flyway are you using?

6.1.4 community

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

cli

Which database are you using (type & version)?

sap hana 2

What did you do?

I tried to create a sap hana view

What did you expect to see?

the view in the db

What did you see instead?

Flyway parsing bug: unable to decrease block depth below 0
[...]

It's possible to reproduce the issue by adding a view using CASE. e.g.

create view my_test_case as
  select 
    case when table_name = 'testing' then 'testing' else table_name end
  from tables;

The issue is in flyway-core/src/main/java/org/flywaydb/core/internal/database/saphana/SAPHANAParser.java. The CASE portion ends with END but the parser considers the END to be used only with BEGIN, DO or IF (that are normally not used in views afaik).

EDIT: fixed the statement...

@alextercete
Copy link
Contributor

@alextercete alextercete commented Jan 16, 2020

@stesix Thanks for the bug report.

We've identified a fix and we expect to include it in the next release.

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

2 participants