Grammar or Syntax Description
JSQLParser fails to parse Postgres queries with multi-parameter "TRUNCATE" statement.
SQL Example
TRUNCATE TABLE transfer_state, transfer_state_change_log
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "," ","
at line 1, column 30.
Additional context
JSQLParser version: 4.6.
I also tested with 4.7 SNAPSHOT
Postgres sql.
https://www.postgresql.org/docs/12/sql-truncate.html
The multi-table truncate statement is necessary in case the two tables are referencing each other by some constraints. In that case Postgres returns an error if you try to truncate each table individually.
Grammar or Syntax Description
JSQLParser fails to parse Postgres queries with multi-parameter "TRUNCATE" statement.
SQL Example
Additional context
JSQLParser version: 4.6.
I also tested with 4.7 SNAPSHOT
Postgres sql.
https://www.postgresql.org/docs/12/sql-truncate.html
The multi-table truncate statement is necessary in case the two tables are referencing each other by some constraints. In that case Postgres returns an error if you try to truncate each table individually.