执行sql：
with a as (
select
‘01’ scop_type,
ps_org_no,
app_no,
cast(ifnull(contract_cap, 0) as int) contract_cap,
case
when cons_sort_code like ‘01%’ then ‘01’
when cons_sort_code like ‘02%’ then ‘02’
when cons_sort_code like ‘03%’ then ‘03’
end as cons_sort_code,
date_format(handle_time, ‘%Y%m’) as stat_cycle
from
s_app
where
(
cons_sort_code like ‘01%’
or cons_sort_code like ‘02%’
or cons_sort_code like ‘03%’
)
and handle_time >= ‘2021-01-01 00:00:00’
and date_format(handle_time, ‘%Y%m%d’) <= curdate() + 0
union all
select
‘02’ scop_type,
ps_org_no,
app_no,
cast(ifnull(contract_cap, 0) as int) contract_cap,
case
when cons_sort_code like ‘01%’ then ‘01’
when cons_sort_code like '02% ’ then ‘02’
when cons_sort_code like '03% ’ then ‘03’
end as cons_sort_code,
date_format(handle_time, ‘%Y%m’) as stat_cycle
from
arc_s_app
where
cons_sort_code like '01%'
or cons_sort_code like '02%'
or cons_sort_code like '03%'
)
报错日志：
43行就是最后一行，每次都是报错最后一行有问题