Repository navigation
[BUG] JSQLParser 5.4 PostgreSQL treats the WITH and BY in CREATE SEQUENCE expressions as optional #2347
Description
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:
Activity
[-][BUG] JSQLParser Version : RDBMS : failing feature description[/-][+][BUG] JSQLParser 5.4 PostgreSQL treats the WITH in CREATE SEQUENCE name START WITH … expressions as optional[/+]Support PostgreSQL-specific [CREATE SEQUENCE name START n ...]
mjog commentedon Nov 21, 2025
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 commentedon Nov 21, 2025
Hmm, actually also
BYinINCREMENT BYfor these statements is also optional, in the same wayWITHis. Will update the title and PR.[-][BUG] JSQLParser 5.4 PostgreSQL treats the WITH in CREATE SEQUENCE name START WITH … expressions as optional[/-][+][BUG] JSQLParser 5.4 PostgreSQL treats the WITH and BY in CREATE SEQUENCE expressions as optional[/+]Support PostgreSQL-specific [CREATE SEQUENCE … INCREMENT n ...]
mjog commentedon Nov 21, 2025
Updated to allow for an optional
BYinINCREMENT BY.Support PostgreSQL-specific [CREATE SEQUENCE name START n ...] (#2348)