mysql 全文索引查找不出来

[aliipay]

ngram_token_size 设置为 1

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

INSERT INTO articles (title) VALUES("a");
INSERT INTO articles (title) VALUES("b");
INSERT INTO articles (title) VALUES("f");

搜索 a，返回空。为什么？

select * FROM  articles  WHERE   MATCH (title) AGAINST ('+a' IN BOOLEAN MODE) ;

ps， 把 a 改成 b 或者 f 则能正常返回。

[aliipay]

up，这么久没人回

[kaffka]

测试了下
1238 - Variable 'ngram_token_size' is a read only variable, Time: 0.001000s
默认是 2
很好奇你是怎么设置的

[aliipay]

@kaffka 直接修改配置文件然后重启 mysql

[sakaf]

后面解决了吗，遇到同样的问题= =

[aliipay]

@sakaf stopword 了解一下

[sakaf]

谢谢大佬😂