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

SAP HANA: CREATE OR REPLACE not working #2222

Closed
ArunNeo opened this issue Nov 29, 2018 · 1 comment
Closed

SAP HANA: CREATE OR REPLACE not working #2222

ArunNeo opened this issue Nov 29, 2018 · 1 comment

Comments

@ArunNeo
Copy link

@ArunNeo ArunNeo commented Nov 29, 2018

Which version and edition of Flyway are you using?

5.1.4

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)

yes tried newer version, still same issue

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

Java

Which database are you using (type & version)?

SAP hana

Which operating system are you using?

MAC osx

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.)

create or replace procedure proc(out o table(a int))
default schema system reads sql data deterministic with encryption as
begin
    o = select 1 as a from dummy;
end;

issue might be similar to this issue #1723

CREATE or REPLACE gives a Syntax error only in Flyway migration. works fine in SAP hana directly.

What did you expect to see?

Create or replace a procedure

What did you see instead?

Syntax error

SQL State : HY000
Error Code : 257
Message : SAP DBTech JDBC: [257] (at 296): sql syntax error: line 6 col 28 (at pos 296)

@axelfontaine axelfontaine added this to the Flyway 5.2.4 milestone Nov 29, 2018
@axelfontaine axelfontaine changed the title CREATE OR REPLACE not working in SAP hana SAP HANA: CREATE OR REPLACE not working Nov 30, 2018
axelfontaine added a commit to flyway/flywaydb.org that referenced this issue Nov 30, 2018
axelfontaine added a commit that referenced this issue Nov 30, 2018
@axelfontaine
Copy link
Contributor

@axelfontaine axelfontaine commented Nov 30, 2018

Thanks for reporting. Fixed.

dohrayme pushed a commit to dohrayme/flyway that referenced this issue Feb 3, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants
You can’t perform that action at this time.