[BUG] JSQLParser 5.4 PostgreSQL treats the WITH and BY in CREATE SEQUENCE expressions as optional

[mjog]

Failing SQL Feature:

PostgreSQL treats the WITH in CREATE SEQUENCE name START WITH … expressions as optional. At least one SQL generator (Hibernate) is generating PostgreSQL-specific SQL when creating new sequences, without the WITH.

SQL Example:

CREATE SEQUENCE example_seq START 1 INCREMENT 1;

Software Information:

PostgreSQL 7.1 through to current (7.x did not support WITH at all, which is maybe why Hibernate is not including it)

JSqlParser version: 4.9 (this project still requires Java 8 for the moment, unfortunately)

However, JSqlParser 5.4-SNAPSHOT still requires it:

[mjog]

A review for the PR above would be great. If I also produce a backport for 4.x would that be considered for a new release there (I'm stuck on Java 8 for the project I'd like to use JSQLParser for).

[mjog]

Hmm, actually also BY in INCREMENT BY for these statements is also optional, in the same way WITH is. Will update the title and PR.

[mjog]

Updated to allow for an optional BY in INCREMENT BY.