Description

d2a-raudenaerde

opened on Jul 1, 2022

Issue body actions

I see this in scripts:

TRUNCATE myfancytable;

This is allowed by Postgresql:

https://www.postgresql.org/docs/current/sql-truncate.html

TRUNCATE [ TABLE ] [ ONLY ] name [ * ] [, ... ]
    [ RESTART IDENTITY | CONTINUE IDENTITY ] [ CASCADE | RESTRICT ]

However, the parser complains with:

net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "myfancytable" <S_IDENTIFIER>
    at line 3, column 10.

Was expecting:

    "TABLE"

Activity

1. d2a-raudenaerde

   added 3 commits that reference this issue on Jul 6, 2022

   Closes JSQLParser#1583

   This issue will close once commit d119768 is merged into the 'master' branch.

   d119768

   Closes JSQLParser#1583, removed unnecessary local variable.

   This issue will close once commit bb78fd8 is merged into the 'master' branch.

   bb78fd8

   Closes JSQLParser#1583, proper support for deparsing.

   This issue will close once commit 4258702 is merged into the 'master' branch.

   4258702
2. wumpz

   closed this as completedin #1585on Jul 14, 2022
3. wumpz

   added a commit that references this issue on Jul 14, 2022

   Closes #1583:: Implement Postgresql optional TABLE in TRUNCATE (#1585)

   This issue will close once commit 2624826 is merged into the 'master' branch.

   2624826

Issue actions