无法使用索引和可以加索未添加的评分高低问题讨论

[martianzhang]

Please answer these questions before submitting your issue. Thanks!

1. What did you do? If possible, provide a recipe for reproducing the error.

select * from test where name='sa' or name='s' 90分

select * from test where name='sa' 只有85分

select * from test where name='sa' or name='s' 没有索引提示

select * from test where name='sa'有索引提示

2. What did you expect to see?

无法使用索引的情况分数应该更低。