Issue parsing « WITH PARSER `ngram` »

[dugwood]

It seems the parser has an issue with fulltext index with ngram, which throws an exception. I've seen it on phpmyadmin: foreign keys (that are defined after the fulltext) are missing on the table's relations page.

Simple example with:

CREATE TABLE `mytable` (
  `column_one` smallint unsigned DEFAULT NULL,
  FULLTEXT KEY `fulltext_index` (`column_one`) /*!50100 WITH PARSER `ngram` */,
  CONSTRAINT `my_constraint_1` FOREIGN KEY (`column_one`) REFERENCES `other_table` (`column_two`) ON DELETE RESTRICT ON UPDATE RESTRICT
)

Exception: A comma or a closing bracket was expected.
Exception debug for ->token:

public 'token' => 
            object(PhpMyAdmin\SqlParser\Token)[1299]
              public 'token' => string 'WITH' (length=4)
              public 'value' => string 'WITH' (length=4)
              public 'keyword' => string 'WITH' (length=4)
              public 'type' => int 1
              public 'flags' => int 3
              public 'position' => int 128

[williamdes]

Thank you for reporting this @dugwood

What do you think about it @iifawzi or @niconoe- ?

[niconoe-]

I'll try to take a look today.

EDIT:

Note

WITH PARSER only came from MySQL 5.1 and I can't find any MariaDB documentation about it.

I just found it is not part of the available tokens. Therefore, instead of parsing WITH PARSER, the parser parses WITH only, causing an error. I'll add the token in the contextes.

[niconoe-]

@williamdes / @iifawzi here you go 😉