Skip to content

[BUG] JSQLParser Version 4.6 - PostgreSQL: "::" notation not supported in nextval #1789

Closed
#1778
Closed
[BUG] JSQLParser Version 4.6 - PostgreSQL: "::" notation not supported in nextval#1789
#1778
Assignees
manticore-projects
Labels
duplicate

Description

@ndepomereu
ndepomereu
opened on May 15, 2023

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
    manticore-projects
    on May 16, 2023
    Contributor

    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
    manticore-projects
    on May 16, 2023
    Contributor

    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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

duplicate

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions