Open
Feature
Open
[BUG] JSQLParser 5.3.0 : PostgreSQL : Encountered unexpected token: "AS" "AS" in sequence#2243
@jgperrin

Description

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.