TiDB执行SQLMAX_EXECUTION_TIME参数失效问题

是指SQL倒数第二行limit 50000 改成40000 30000 均卡死 但是20000 是OK的 现在疑惑的是为什么参数不生效,而且并没有多出很大的机器负载 麻烦了
SELECT /*+ MAX_EXECUTION_TIME(10000) */ *
FROM (
SELECT tc.customer_account_id, concat(tc.phone_province_name, ‘-’, tc.phone_city_name)
, CASE ro.last_follow_up_status
WHEN 11 THEN ‘电话未接通’
WHEN 10 THEN ‘继续跟进’
WHEN 12 THEN ‘继续跟进’
WHEN 13 THEN ‘下发门店(异店试驾)’
WHEN 33 THEN ‘已有专家跟进’
WHEN 35 THEN ‘成交’
WHEN 20 THEN ‘无效号码’
WHEN 21 THEN ‘观望口碑’
WHEN 22 THEN ‘暂不用车’
WHEN 23 THEN ‘等不及购买其他品牌’
WHEN 24 THEN ‘对新品牌不信任’
WHEN 26 THEN ‘资金不足’
WHEN 27 THEN ‘没有牌照或指标’
WHEN 28 THEN ‘担心异地售后无保障’
WHEN 29 THEN ‘不能安装充电桩’
WHEN 30 THEN ‘购买其他车型’
WHEN 31 THEN ‘提车日期晚’
WHEN 32 THEN ‘其他’
ELSE ‘–’
END AS last_follow_up_status, ro.last_follow_up_content
, CASE ro.intention_level
WHEN 5 THEN ‘H’
WHEN 2 THEN ‘高’
WHEN 4 THEN ‘中’
WHEN 1 THEN ‘有’
WHEN 0 THEN ‘无’
WHEN 10 THEN ‘3天内试驾’
WHEN 15 THEN ‘7天内试驾’
WHEN 20 THEN ‘14天内试驾’
WHEN 25 THEN ‘30天内试驾’
WHEN 99 THEN ‘暂不确定’
ELSE ‘–’
END AS intention_level, DATE_FORMAT(ro.last_follow_up_time, ‘%Y-%m-%d %k:%i:%s’) AS last_follow_up_time
, CASE ro.oppty_status
WHEN 10 THEN ‘新商机’
WHEN 11 THEN ‘待跟进’
WHEN 12 THEN ‘电销跟进中’
WHEN 13 THEN ‘驳回待跟进’
WHEN 20 THEN ‘已下发门店’
WHEN 21 THEN ‘已试驾’
WHEN 30 THEN ‘已锁单’
WHEN 31 THEN ‘已交付’
WHEN 40 THEN ‘战败’
ELSE ‘–’
END AS oppty_status, ud.dept_name, ro.owner_name, ro.first_source_name
, DATE_FORMAT(ro.create_time, ‘%Y-%m-%d %k:%i:%s’) AS create_time
, DATE_FORMAT(ro.first_follow_up_time, ‘%Y-%m-%d %k:%i:%s’) AS first_follow_up_time
FROM saos_tur.rb_opportunity ro
LEFT JOIN saos_tur.tur_customer tc ON ro.customer_account_id = tc.customer_account_id
LEFT JOIN saos_tur.upm_dept ud ON ro.owner_dept_id = ud.id
WHERE tc.account_status = 0
AND ro.is_delete = 0
AND ro.create_time BETWEEN ‘2021-04-07 00:00:00’ AND ‘2021-05-13 23:59:59’
AND ro.owner_dept_id IN (
SELECT id
FROM saos_tur.upm_dept
WHERE dept_code LIKE concat(concat(‘100100100’), ‘%’)
)
ORDER BY ro.last_follow_up_time DESC
LIMIT 50000
) bd_limit_temp limit 0,10