phpmyadmin
diff --git a/‎src/Statement.php
Lines changed: 9 additions & 5 deletions b/‎src/Statement.php
Lines changed: 9 additions & 5 deletions
diff --git a/‎src/Statements/TruncateStatement.php
Lines changed: 10 additions & 0 deletions b/‎src/Statements/TruncateStatement.php
Lines changed: 10 additions & 0 deletions
@@ -320,11 +320,15 @@ public function parse(Parser $parser, TokensList $list)
             }
 
             // Checking if this is the beginning of a clause.
-            if (! empty(Parser::$KEYWORD_PARSERS[$token->value]) && $list->idx < $list->count) {
-                $class = Parser::$KEYWORD_PARSERS[$token->value]['class'];
-                $field = Parser::$KEYWORD_PARSERS[$token->value]['field'];
-                if (! empty(Parser::$KEYWORD_PARSERS[$token->value]['options'])) {
-                    $options = Parser::$KEYWORD_PARSERS[$token->value]['options'];
+            // Fix Issue #221: As `truncate` is not a keyword
+            // but it might be the beginning of a statement of truncate,
+            // so let the value use the keyword field for truncate type.
+            $token_value = in_array($token->keyword, ['TRUNCATE']) ? $token->keyword : $token->value;
+            if (! empty(Parser::$KEYWORD_PARSERS[$token_value]) && $list->idx < $list->count) {
+                $class = Parser::$KEYWORD_PARSERS[$token_value]['class'];
+                $field = Parser::$KEYWORD_PARSERS[$token_value]['field'];
+                if (! empty(Parser::$KEYWORD_PARSERS[$token_value]['options'])) {
+                    $options = Parser::$KEYWORD_PARSERS[$token_value]['options'];
                 }
             }
 
 
@@ -33,4 +33,14 @@ class TruncateStatement extends Statement
      * @var Expression
      */
     public $table;
+
+    /**
+     * Special build method for truncate statement as Statement::build would return empty string.
+     *
+     * @return string
+     */
+    public function build()
+    {
+        return 'TRUNCATE TABLE ' . $this->table . ';';
+    }
 }
Original file line number	Diff line number	Diff line change
`@@ -320,11 +320,15 @@ public function parse(Parser $parser, TokensList $list)`
`320`	`320`	`}`
`321`	`321`
`322`	`322`	`// Checking if this is the beginning of a clause.`
`323`		`- if (! empty(Parser::$KEYWORD_PARSERS[$token->value]) && $list->idx < $list->count) {`
`324`		`- $class = Parser::$KEYWORD_PARSERS[$token->value]['class'];`
`325`		`- $field = Parser::$KEYWORD_PARSERS[$token->value]['field'];`
`326`		`- if (! empty(Parser::$KEYWORD_PARSERS[$token->value]['options'])) {`
`327`		`- $options = Parser::$KEYWORD_PARSERS[$token->value]['options'];`
	`323`	+ // Fix Issue #221: As `truncate` is not a keyword
	`324`	`+ // but it might be the beginning of a statement of truncate,`
	`325`	`+ // so let the value use the keyword field for truncate type.`
	`326`	`+ $token_value = in_array($token->keyword, ['TRUNCATE']) ? $token->keyword : $token->value;`
	`327`	`+ if (! empty(Parser::$KEYWORD_PARSERS[$token_value]) && $list->idx < $list->count) {`
	`328`	`+ $class = Parser::$KEYWORD_PARSERS[$token_value]['class'];`
	`329`	`+ $field = Parser::$KEYWORD_PARSERS[$token_value]['field'];`
	`330`	`+ if (! empty(Parser::$KEYWORD_PARSERS[$token_value]['options'])) {`
	`331`	`+ $options = Parser::$KEYWORD_PARSERS[$token_value]['options'];`
`328`	`332`	`}`
`329`	`333`	`}`
`330`	`334`