Skip to content

H2 2.x cannot read PostgreSQL-style sequence generator start with option without WITH keyword #3675

@specter8x

Description

@specter8x

We are having issues with Postgres flyway scripts where we create sequence without WITH in the SQL statement which is optional in Postgres. For example,

CREATE SEQUENCE seq START 100 INCREMENT 1;

With the update of H2 db 2.x, we are getting syntax errors. Since these are flyway scripts, we cannot easily update the scripts without messing up the hash. Any workaround or update to this?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions