【StarRocks版本】1.18.1
【集群规模】3fe（1 follower+2observer）+5be（fe与be混部）
【机器信息】40C/128G/万兆
请问我们在执行一条统计语句时发现结果不对，具体语句如下
select a.period_code,b.period_code,a.hsicrm_industryname,b.hsicrm_industryname,a.hz_amount,IFNULL(b.hz_amount,0)
from
(select
date_format( hsicrm_registrationtime,’%Y-%m-%d %H:%i’) period_code,
hsicrm_industryname,
COUNT(1) as hz_amount
from di_fw.hsicrm_wo_workorderbase_registrationtime hwwr
where hsicrm_registrationtime > current_date()
and statecode = 0
and hsicrm_industrycode in (‘CD’,‘XWJ’,‘DR’,‘KT’,‘XYJ’,‘ZHL’)
and hsicrm_sourcecode in (‘CDK’,‘JDA’)
group by hsicrm_industryname,date_format( hsicrm_registrationtime,’%Y-%m-%d %H:%i’)
) a
left join (
select
date_format( date_add( hsicrm_registrationtime, INTERVAL 1 year ),’%Y-%m-%d %H:%i’) period_code,
hsicrm_industryname,
COUNT(1) as hz_amount
from di_fw.hsicrm_wo_workorderbase_registrationtime hwwr
where hsicrm_registrationtime >= date_format(date_sub(now(),interval 1 year), ‘%Y-%m-%d 00:00:00’)
and hsicrm_registrationtime <= date_sub(now(),interval 1 year)
and statecode = 0
and hsicrm_industrycode in (‘CD’,‘XWJ’,‘DR’,‘KT’,‘XYJ’,‘ZHL’)
and hsicrm_sourcecode in (‘CDK’,‘JDA’)
group by hsicrm_industryname,date_format( date_add( hsicrm_registrationtime, INTERVAL 1 year ),’%Y-%m-%d %H:%i’)
) b
on
a.period_code =b.period_code and a.hsicrm_industryname =b.hsicrm_industryname
左边只有2900多条数据，右表也是，但执行完得到57000条数据
该语句在测试环境执行正确，生产环境执行错误
已做过 ANALYZE TABLE也无效
