【 TiDB 使用环境】生产环境 /测试/ Poc
【 TiDB 版本】
V5.4.0
【复现路径】执行以下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;
【遇到的问题：问题现象及影响】
limit 0,50可以很快出来，但是limit 0,100一直无返回直到超时
【资源配置】暂无
【附件：截图/日志/监控】
前后执行计划一样吗