索引过滤，limit 分页结果不同

[zhangdeheng]

sql1:select idx from biz_cware_timing where idx>=100000 and dn = ‘acc’ order by idx limit 100000,10;

sql2:select idx from biz_cware_timing where dn = ‘acc’ order by idx limit 100000,10;

结果：
sql1结果：
sql2结果：

[Lucien]

查询谓词不一样，结果会存在差异，这个原因是执行计划的下推计算的规则。