升级2.1.7版本后create table as select internal表1 left join internal表2报Column in field list is ambiguous问题,建表失败,查询正常

Viewed 27

Doris版本信息:2.1.7
doris-2.1.7-rc03-443e87e203
复现语句:
create table tmp_gzrh_202410_1_wzl
as
select a1.prod_inst_id
,a1.group_prod_inst_id
,a1.lan_id
,a2.lan_name
,a2.offer_grade
,case when a1.order_finish_date like '1970%' then concat(202410,'01') else substr(a1.order_finish_date,1,8) end order_finish_date
,a2.p_mon_id
,case when a1.innet_dur<=6 then 1
when a1.innet_dur>6 and a1.innet_dur<=12 then 2
when a1.innet_dur>12 and a1.innet_dur<=24 then 3
else 4 end innet_dur
from INT3BAS.WID_PRD_PROD_INST_M a1
join WZL_20230322_100 a2
on a1.prod_inst_id=a2.prod_inst_id
and a2.p_mon_id in (202312,202410)
and a2.prd_type=7
and cast(a2.offer_grade as int)>=129
and a1.p_mon_id=a2.p_mon_id
and a2.day_id=date_format(last_day(STR_TO_DATE(a2.p_mon_id,'%Y%m')),'%Y%m%d')
where a1.p_mon_id in (202312,202410)
and a1.prod_catalog_cd=1
and a1.is_bil_user=1;
e8e64ceceb2582babcfa8345c817117.png
之前在2.1.3版本出现过一次,确认为nereids优化器未开启所致,这次升级后nereids为开启状态,仍然出现了这次问题,麻烦各位老师专家看下呢,感激不尽!
5ef60252cdab03043ec60fd73a3e14a.png

1 Answers

内部已经复现,正在跟进中,后续同步修复PR