Hello
We use H2 in our test framework and PG in production.
I am trying to migrate from 1.4.200 to 2.1.214 but getting sytax issues , while flyway 9 with spring 3.0.2 tries to execute the SQL queries on new H2.
I am getting following error, earlier with 2.1.214, same used to work with 1.4.200.
Please suggest, what config changes may be needed to make new H2 identify these SQL queries?
{"@timestamp":"2023-02-24T20:35:49.094Z","service_name":"activate-inventory","level":"DEBUG","logger":"o.f.c.i.s.DefaultSqlScriptExecutor","thread":"main","message":"Executing SQL: create sequence hibernate_sequence start 1 increment 1"}
.f.c.i.s.FlywaySqlScriptException: Migration V1__app_tables.sql failed\n-----------------------------------\nSQL State : 42000\nError Code : 42000\nMessage : Syntax error in SQL statement \
"create sequence hibernate_sequence [*]start 1 increment 1
Thanks
Hemant