[Bug]: Executing a query that includes "select .. group by .. union all select .." results in a core dump

[getiancheng]

What happened?

create table test_group
(
	TypeFlag varchar(100)
);
insert into test_group values (30),(7),(10);
GO

select 
	TypeFlag -- varchar(100)
from test_group 
	group by typeflag -- coredump(signal 11)
	-- group by typeflag -- ok!
union all
select 40 as TypeFlag; -- int
GO

When executing the above SQL statement with the "group by typeflag" clause, the database crashed due to signal 11

Version

BABEL_5_X_DEV (Default)

Extension

None

Which flavor of Linux are you using when you see the bug?

Ubuntu (Default)

Relevant log output

Code of Conduct

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

[tanscorpio7]

Thanks for reporting. I can reproduce this. This likely is a bug in select common type for union logic where we modified the type for a select column but did not update its consumer (i.e. group by in this case).

[Mohitraj-g]

placeholder