Skip to content

Parser cannot deal truncate statement #221

@sinri

Description

@sinri

(1) First, cannot parse common truncate statement.

$query="truncate a";
$parser = new Parser($query,true);

would throw

PHP Fatal error:  Uncaught PhpMyAdmin\SqlParser\Exceptions\ParserException: Unexpected token. in /Users/sinri/code/phpstorm/sql-parser/src/Parser.php:617
Stack trace:
#0 /Users/sinri/code/phpstorm/sql-parser/src/Statement.php(247): PhpMyAdmin\SqlParser\Parser->error('Unexpected toke...', Object(PhpMyAdmin\SqlParser\Token))
#1 /Users/sinri/code/phpstorm/sql-parser/src/Statement.php(90): PhpMyAdmin\SqlParser\Statement->parse(Object(PhpMyAdmin\SqlParser\Parser), Object(PhpMyAdmin\SqlParser\TokensList))
#2 /Users/sinri/code/phpstorm/sql-parser/src/Parser.php(516): PhpMyAdmin\SqlParser\Statement->__construct(Object(PhpMyAdmin\SqlParser\Parser), Object(PhpMyAdmin\SqlParser\TokensList))
#3 /Users/sinri/code/phpstorm/sql-parser/src/Parser.php(381): PhpMyAdmin\SqlParser\Parser->parse()
#4 /Users/sinri/code/phpstorm/sql-parser/doc/1.php(14): PhpMyAdmin\SqlParser\Parser->__construct('truncate a', true)
#5 {main}
  thrown in /Users/sinri/code/phpstorm/sql-parser/src/Parser.php on line 617

Only TRUNCATE table x.y is accepted.

(2) Cannot build an existed TruncateStatement.

Which would return empty string.

Version Commit 2842754

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions