【StarRocks版本】2.4.0
客户端:navicat
两个预期排序结果一致的SQL,最后结果不一致:
SELECT * FROM (SELECT * FROM
JH_IN_ORDERS t ORDER BY t.
IOR0035` DESC) t LIMIT 0,100;
//排序快,0.5s,但是结果不正确,感觉查询计划有问题
SELECT * FROM JH_IN_ORDERS
t ORDER BY t.IOR0035
DESC LIMIT 0,100;
//排序慢,112s,但是结果正确`