Open miaojianxin opened 6 months ago
the tsquery rule can be simple like this: insert into rules(keyword_rule) values('( 实名举报 | 实名投诉 | 实名曝光 | 实名控诉 ) & !( 信用分 | (转发 & 有 需要))');
when rum index is used ,no result get for the sql: select id from rules where to_tsvector('jiebaqry_golaxy','实名举报')@@keyword_rule;
simple the rule again: insert into rules (keyword_rule) values('实名举报 & !(转发&有需要)');
if keyword_rule like this , no result can get for the sql also
may be the problem is when ! and & used together
result: the result is different when rum index(for tsquery) used and not used