Repository navigation
Postgresql: TRUNCATE does not require TABLE #1583
Description
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
Closes JSQLParser#1583
Closes JSQLParser#1583, removed unnecessary local variable.
Closes JSQLParser#1583, proper support for deparsing.
Closes #1583:: Implement Postgresql optional TABLE in TRUNCATE (#1585)