[Bug] Execute left out join sql with group_concat function will cause be core

[caiconghui]

Search before asking

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

Version

master

What's Wrong?

outer join sql would make some slot nullable when slot is selected from nullable tuple in outer join sql even the origin slot is not nullable. but now our design forget to check it.

What You Expected?

be not core

How to Reproduce?

CREATE TABLE left_table (
k1 int(11) NULL COMMENT "",
no varchar(50) NOT NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(k1)
COMMENT "OLAP"
DISTRIBUTED BY HASH(k1) BUCKETS 2
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"in_memory" = "false",
"storage_format" = "V2"
);

CREATE TABLE right_table (
k1 int(11) NULL COMMENT "",
no varchar(50) NOT NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(k1)
COMMENT "OLAP"
DISTRIBUTED BY HASH(k1) BUCKETS 2
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"in_memory" = "false",
"storage_format" = "V2"
) ;
insert into left_table values(1, "test");
select l.k1, group_concat(r.no) from left_table l left join right_table r on l.k1=r.k1 group by l.k1;

Anything Else?

No response

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