Yu Xu created CALCITE-6995:
------------------------------
Summary: StarRocks/Doris should support full join
Key: CALCITE-6995
URL: https://issues.apache.org/jira/browse/CALCITE-6995
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.39.0
Reporter: Yu Xu
Assignee: Yu Xu
Fix For: 1.40.0
As we know StarRocks/Doris are based on jdbc::mysql protocol and they are both
support full join. But their dialect are extended from Mysql which not support
FULL JOIN, can refer to this Jira ticket:
https://issues.apache.org/jira/browse/CALCITE-4619
At the same time this Jira above not added a test case for full join plan, so
maybe we need to support full join in StarRocks and Doris and add related test
case for it.
full join test in StarRocks and Doris:
{code:java}
select * from (select 1 as id,'aa' as name) as a full join (select 1 as id,
'bb' as name) as b on a.id=b.id;
> 1, aa, 1, bb {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
