sql文本:
select
line_code as lineCode,
sum(amount) as amount
from
header
join ext on
ext.id = header.id
join event on
header.id = event.rcv_header_id
left join line on
line.rcv_header_id = header.id
where
ext.order_id = 8405253
and header.rcp_business_type in (‘edrwcew’)
and event.event_at >= 1669824000000
and event.event_at <= 1672502399999
group by
line_code,
order_id;
低版本(2.0)tidb执行计划:
高版本(5.1.2)执行计划: