v2.1.6
对表中 A(int),B(varchar) 字段添加倒排索引
-- 可以命中倒排索引 (RowsInvertedIndexFiltered > 0)
select * from table where A in (123) or B in ('xxx')
select * from table where A in (123) or B in ('xxx', 'yyy')
select * from table where A in (123, 456)
select * from table where B in ('xxx', 'yyy')
-- 无法命中倒排索引 (RowsInvertedIndexFiltered = 0)
select * from table where A in (123, 456) or B in ('xxx')
select * from table where A in (123, 456) or B in ('xxx', 'yyy')
经测试 如果A和B都为varchar类型,则上述问题不存在