JSqlParser icon indicating copy to clipboard operation
JSqlParser copied to clipboard

[BUG] JSQLParser 5.3.0 : PostgreSQL : Encountered unexpected token: "AS" "AS" in sequence

Open jgperrin opened this issue 6 months ago • 1 comments
trafficstars

Failing SQL Feature:

  • AS integer can't be parsed

SQL Example:

  • Simplified Query Example, focusing on the failing feature
CREATE SEQUENCE public.activites_activite_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

Software Information:

  • JSqlParser version 5.3.0
  • PostgreSQL version 14.18

Tips:

Generated by pg_dump. Valid syntax according to https://www.postgresql.org/docs/current/sql-createsequence.html.

jgperrin avatar May 21 '25 14:05 jgperrin

Unsupported and you will need to either provide a PR or sponsor an implementation.

manticore-projects avatar May 25 '25 09:05 manticore-projects