FULLTEXT (title, body) WITH PARSER ngram语句审核失败

[xiaoshenwei]

描述

重现

CREATE TABLE
  articles (
    id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
    title VARCHAR(200),
    body TEXT,
    FULLTEXT (title, body) WITH PARSER ngram
  ) CHARACTER SET utf8mb4;

----------+---------+-------------+-----------------+------------------------------------------+----------------------------------------------------------+---------------+--------------+---------------+--------------+---------+-------------+
| order_id |  stage  | error_level |   stage_status  |              error_message               |                           sql                            | affected_rows |   sequence   | backup_dbname | execute_time | sqlsha1 | backup_time |
+----------+---------+-------------+-----------------+------------------------------------------+----------------------------------------------------------+---------------+--------------+---------------+--------------+---------+-------------+
|    1     | CHECKED |      0      | Audit Completed |                   None                   |                      use ncmdb_dev                       |       0       | 0_0_00000000 |      None     |      0       |   None  |      0      |
|    2     |  RERUN  |      2      | Audit Completed | line 6 column 33 near "WITH PARSER ngram |                       CREATE TABLE                       |       0       | 0_0_00000001 |      None     |      0       |   None  |      0      |
|          |         |             |                 |         ) CHARACTER SET utf8mb4"         |                         articles (                       |               |              |               |              |         |             |
|          |         |             |                 |                                          |     id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, |               |              |               |              |         |             |
|          |         |             |                 |                                          |                     title VARCHAR(200),                  |               |              |               |              |         |             |
|          |         |             |                 |                                          |                          body TEXT,                      |               |              |               |              |         |             |
|          |         |             |                 |                                          |          FULLTEXT (title, body)  WITH PARSER ngram       |               |              |               |              |         |             |
|          |         |             |                 |                                          |                  ) CHARACTER SET utf8mb4                 |               |              |               |              |         |             |
+----------+---------+-------------+-----------------+------------------------------------------+----------------------------------------------------------+---------------+--------------+---------------+--------------+---------+-------------+

https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-ngram.html