【详述】在starrocks数据库表中新增了一个排序字段sort_num，写入数据时已经排好序，在查询时通过order by sort_num limit 20升序查询前20条。查询内容不包含排序字段sort_num时，全局排序失效。包含sort_num时全局排序有效。
【背景】用starrocks做分页查询。
【业务影响】分页查询失效，数据api接口查询分页有问题。
【StarRocks版本】例如：2.4
【集群规模】例如：3fe（1 follower+2observer）+3be
【附件】
SQL查询语句：
– 查询字段不包含sort_num
SELECT part_dt,
comm_id,
comm_name,
organ_id,
organ_name,
tenant_id,
build_cnt,
room_cnt,
house_keeper_cnt,
prepay_comple_amt,
prepay_amt_deduct_mths,
prepay_amt_goal,
prepay_amt_goal_comple_rate,
arrear_amt,
arrear_households,
thmon_mtd_recvl_amt1,
year_ytd_recvl_amt1,
thmon_mtd_adjust_hisy_amt,
year_ytd_adjust_hisy_amt,
d_recd_total_amt,
d_recd_total_amt_dod_incr_rate,
thmon_mtd_recd_total_amt,
year_ytd_recd_total_amt,
d_act_recov_total_amt,
d_act_recov_total_amt_dod_incr_rate,
thmon_mtd_act_recov_total_amt,
year_ytd_act_recov_total_amt,
year_ytd_begin_arrear_amt,
year_ytd_chrg_rate1,
year_ytd_chrg_rate1_yoy,
year_ytd_chrg_rate1_mom,
year_ytd_recvl_all_amt,
year_ytd_recd_all_amt,
year_ytd_compre_chrg_rate,
year_ytd_compre_chrg_rate_yoy,
year_ytd_compre_chrg_rate_mom,
year_ytd_recov_rate,
year_ytd_recov_rate_goal,
year_ytd_recov_rate_goal_comple_rate,
year_ytd_recov_rate_yoy,
year_ytd_recov_rate_mom,
year_ytd_compre_chrg_rate_rk,
year_ytd_chrg_rate1_rk,
year_ytd_recov_rate_rk,
tkover_households,
tkover_area,
tkover_households_yoy_incr_rate,
tkover_households_mom_incr_rate,
tkover_area_yoy_incr_rate,
tkover_area_mom_incr_rate,
tkover_households_rk,
tkover_area_rk,
property_type_households_ratio,
property_type_area_ratio,
year_ytd_chrg_rate1_goal_unreach,
year_ytd_chrg_amt_goal_unreach,
year_ytd_chrg_rate1_goal,
year_ytd_chrg_rate1_goal_comple_rate,
year_ytd_recov_rate_goal_unreach,
year_ytd_recov_amt_goal_unreach,
year_ytd_recov_rate_goal,
year_ytd_recov_rate_goal_comple_rate,
year_ytd_chrg_rate1_d_incr,
year_ytd_recov_rate_d_incr,
year_esti_recvl_amt1
FROM ads_comm_fhx_idx_df
where part_dt = 20221205
order by sort_num limit 20;
– 查询字段包含sort_num
SELECT part_dt,
comm_id,
sort_num,
comm_name,
organ_id,
organ_name,
tenant_id,
build_cnt,
room_cnt,
house_keeper_cnt,
prepay_comple_amt,
prepay_amt_deduct_mths,
prepay_amt_goal,
prepay_amt_goal_comple_rate,
arrear_amt,
arrear_households,
thmon_mtd_recvl_amt1,
year_ytd_recvl_amt1,
thmon_mtd_adjust_hisy_amt,
year_ytd_adjust_hisy_amt,
d_recd_total_amt,
d_recd_total_amt_dod_incr_rate,
thmon_mtd_recd_total_amt,
year_ytd_recd_total_amt,
d_act_recov_total_amt,
d_act_recov_total_amt_dod_incr_rate,
thmon_mtd_act_recov_total_amt,
year_ytd_act_recov_total_amt,
year_ytd_begin_arrear_amt,
year_ytd_chrg_rate1,
year_ytd_chrg_rate1_yoy,
year_ytd_chrg_rate1_mom,
year_ytd_recvl_all_amt,
year_ytd_recd_all_amt,
year_ytd_compre_chrg_rate,
year_ytd_compre_chrg_rate_yoy,
year_ytd_compre_chrg_rate_mom,
year_ytd_recov_rate,
year_ytd_recov_rate_goal,
year_ytd_recov_rate_goal_comple_rate,
year_ytd_recov_rate_yoy,
year_ytd_recov_rate_mom,
year_ytd_compre_chrg_rate_rk,
year_ytd_chrg_rate1_rk,
year_ytd_recov_rate_rk,
tkover_households,
tkover_area,
tkover_households_yoy_incr_rate,
tkover_households_mom_incr_rate,
tkover_area_yoy_incr_rate,
tkover_area_mom_incr_rate,
tkover_households_rk,
tkover_area_rk,
property_type_households_ratio,
property_type_area_ratio,
year_ytd_chrg_rate1_goal_unreach,
year_ytd_chrg_amt_goal_unreach,
year_ytd_chrg_rate1_goal,
year_ytd_chrg_rate1_goal_comple_rate,
year_ytd_recov_rate_goal_unreach,
year_ytd_recov_amt_goal_unreach,
year_ytd_recov_rate_goal,
year_ytd_recov_rate_goal_comple_rate,
year_ytd_chrg_rate1_d_incr,
year_ytd_recov_rate_d_incr,
year_esti_recvl_amt1
FROM ads_comm_fhx_idx_df
where part_dt = 20221205
order by sort_num limit 20;
查询字段包含sort_num时排序正常，查询字段不包含sort_num时排序异常。帮忙看一下!