Description

ndepomereu

opened on May 15, 2023

Issue body actions

Hi,

With 4.6 I try to parse a PostgreSQL schema, it fails on this kind of table:

Statement in Error No 2: 
CREATE TABLE public.actor (
    actor_id integer DEFAULT nextval('public.actor_actor_id_seq'::regclass) NOT NULL,
    first_name character varying(45) NOT NULL,
    last_name character varying(45) NOT NULL,
    last_update timestamp without time zone DEFAULT now() NOT NULL
)
Exception of Error No 2: 
Encountered unexpected token: "::" "::"

Seems the :: notation is not suported in nextval.

Best,
N.

Activity

1. manticore-projects commented on May 16, 2023

   

   manticore-projects

   on May 16, 2023

   Contributor

   More actions

   Greetings, thank you for reporting.

   I will fix this today, since there is a similar issue already.
   Duplicate #1098
   Duplicate #1022
2. manticore-projects

   self-assigned this

   on May 16, 2023
3. manticore-projects

   added

   duplicate

   on May 16, 2023
4. manticore-projects

   added a commit that references this issue on May 16, 2023

   fix: issue JSQLParser#1789

   d20c8e9
5. manticore-projects commented on May 16, 2023

   

   manticore-projects

   on May 16, 2023

   Contributor

   More actions

   Fixed via Commit d20c8e9 with PR #1778

   Cheers!
6. manticore-projects

   added a commit that references this issue on May 16, 2023

   fix: issue JSQLParser#1789

   32ec561
7. manticore-projects

   added a commit that references this issue on Jun 1, 2023

   JSQLParser 5.0 (#1778)

   41b6fce
8. manticore-projects

   closed this as completedin #1778on Jun 1, 2023
9. manticore-projects

   added a commit that references this issue on Jun 15, 2023

   Assorted Fixes #8 (#1807)

   a815f5f
10. manticore-projects

    added a commit that references this issue on Jun 27, 2023

    Backslash Quotation of Single-Quote `'\\''` (#1813)

    c79dfff

Issue actions