倒排索引MATCH_PHRASE查询异常

Viewed 8

我有一张表A,其中有个字段:
title varchar(65533) NULL COMMENT '笔记标题'
我针对这个字段设置了倒排索引:
INDEX idx_inv_title (title) USING INVERTED PROPERTIES("support_phrase" = "true", "ignore_above" = "2000", "parser" = "chinese", "lower_case" = "true", "parser_mode" = "fine_grained") COMMENT '标题-倒排索引'
里面有两条数据,一条的title为:Only you官推更新,一条的title为:ONLY
现在执行select * from A where title MATCH_PHRASE 'only',只能查询出第一条数据,请问是为什么

0 Answers