Repository navigation
[BUG] JSQLParser Version 5.0 : PostgreSQL : TRUNCATE statements do not parse with multiple tables provided #2047
Description
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, table3OR
TRUNCATE TABLE table1, table2, table3These 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
Activity
manticore-projects commentedon Jul 24, 2024
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 commentedon Jul 24, 2024
Duplicate #1821
nick-redfearn commentedon Jul 24, 2024
@manticore-projects I've created this pull request -> #2048
manticore-projects commentedon Jul 26, 2024
Fixed via #2048