[BUG] JSQLParser Version 5.0 : PostgreSQL : `TRUNCATE` statements do not parse with multiple tables provided

[nick-redfearn]

Failing SQL Feature:

TRUNCATE or TRUNCATE TABLE statements do not parse with multiple tables provided

This is allowed by PostgreSQL:
https://www.postgresql.org/docs/current/sql-truncate.html

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

SQL Example:

TRUNCATE table1, table2, table3

OR

TRUNCATE TABLE table1, table2, table3

These both fail with the error message below

net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "," ","
    at line 2, column 11.

Was expecting one of:

    "CASCADE"
    <EOF>
    <ST_SEMICOLON>

Software Information:

• JSqlParser version 5.0
• PostgreSQL

[manticore-projects]

Greetings.

Correct, the current implementation covers single table truncate only.
You would need to provide or sponsor an implementation for multiple table truncate to make it happen.

[manticore-projects]

Duplicate #1821

[nick-redfearn]

@manticore-projects I've created this pull request -> #2048

[manticore-projects]

Fixed via #2048