Can retrieve 50 records, but cannot retrieve 100 records

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 查50条可以查出来,但是查100条查不出来

| username: TiDBer_37cEUU9o

[TiDB Usage Environment] Production Environment / Testing / PoC
[TiDB Version]
V5.4.0
[Reproduction Path] Execute the following SQL

SELECT
/* listId : 113 listViewId : 917 */
-- t_warehouse_maintenance_task_detail2176.claim_status AS t_warehouse_maintenance_task__id___t_warehouse_maintenance_task_detail__claim_status,
-- t_warehouse_maintenance_task_detail2176.maintenance_task_id AS t_warehouse_maintenance_task__id___t_warehouse_maintenance_task_detail__maintenance_task_id,
-- t_warehouse_maintenance_task_detail2176.the_last_maintenance_date AS t_warehouse_maintenance_task__id___t_warehouse_maintenance_task_detail__the_last_maintenance_date,
-- t_warehouse_maintenance_task.task_status,
-- t_warehouse_maintenance_task.task_begin_date,
t_warehouse_maintenance_task.id,
-- t_warehouse_maintenance_task.maintenance_plan_id,
-- t_warehouse_maintenance_task.company_id,
-- t_warehouse_maintenance_task_detail2176.stock_qty AS t_warehouse_maintenance_task__id___t_warehouse_maintenance_task_detail__stock_qty,
-- t_warehouse_maintenance_task.business_id,
-- t_warehouse_maintenance_task.maintenance_task_number,
-- t_warehouse_maintenance_task.create_time,
-- t_warehouse_maintenance_task_detail2176.made_number AS t_warehouse_maintenance_task__id___t_warehouse_maintenance_task_detail__made_number,
-- t_warehouse_maintenance_task.task_over_date,
-- t_warehouse_maintenance_task_detail2176.ware_inside_code AS t_warehouse_maintenance_task__id___t_warehouse_maintenance_task_detail__ware_inside_code,
-- t_warehouse_maintenance_task_detail2176.invalidate AS t_warehouse_maintenance_task__id___t_warehouse_maintenance_task_detail__invalidate,
t_warehouse_maintenance_task_detail2176.id AS t_warehouse_maintenance_task__id___t_warehouse_maintenance_task_detail__id 
FROM
`h3_maintenance`.t_warehouse_maintenance_task
LEFT JOIN `h3_maintenance`.t_warehouse_maintenance_task_detail AS t_warehouse_maintenance_task_detail2176 ON t_warehouse_maintenance_task.id = t_warehouse_maintenance_task_detail2176.maintenance_task_id 
WHERE
t_warehouse_maintenance_task.create_time >= '2023-05-11 00:00:00' 
AND t_warehouse_maintenance_task.create_time < '2023-06-11 00:00:00' 
AND t_warehouse_maintenance_task.create_time >= '2023-05-11 00:00:00' 
AND t_warehouse_maintenance_task.create_time < '2023-06-11 00:00:00' 
AND t_warehouse_maintenance_task.company_id IN ( 10032, 10025 ) 
ORDER BY
t_warehouse_maintenance_task.create_time desc,
t_warehouse_maintenance_task.id desc 
LIMIT 0, 100;

[Encountered Problem: Phenomenon and Impact]
LIMIT 0, 50 can return results quickly, but LIMIT 0, 100 keeps running until it times out.
[Resource Configuration] None
[Attachments: Screenshots/Logs/Monitoring]

| username: zhanggame1 | Original post link

Are the execution plans the same before and after?