[Bug] Doris bigint column join will auto cast to double, result repeat. bigint类型关联时自动转double, 导致重复关联。

[ScalaFirst]

Search before asking

• I had searched in the issues and found no similar issues.

Version

2.1.11

What's Wrong?

Doris bigint column join will auto cast to double. so that join result repeat.

What You Expected?

正常关联，或者转varchar关联。

How to Reproduce?

with users as (
SELECT
cua.id as user_id
from (select id,user_name,user_type from ssp_portal_user where is_delete = false) cua
left join ssp_user_login sul on cua.id = sul.user_id
where cua.user_type = 1
group by cua.id -- 这里也 group by 了id
),
person_all as (
SELECT
asmp.user_id as user_id ,
SUM(asmp.person_login_count) as totalLoginNum,
SUM(asmp.person_dwell_time)/SUM(asmp.person_pv) AS avgDuration,
MAX(asmp.last_action_date) as recentActive
from ads_ssp_metrics_person asmp
group by asmp.user_id -- 这里 group by 了id
)
SELECT
u.,pa.
from users u
join person_all pa on u.user_id = pa.user_id
where u.user_id = 2012037927747854336

Anything Else?

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct