[jira] [Created] (CALCITE-6995) StarRocks/Doris should support full join

["Yu Xu (Jira)" <ji...@apache.org>]

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)