[
https://issues.apache.org/jira/browse/CALCITE-6995?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated CALCITE-6995:
------------------------------------
Labels: pull-request-available (was: )
> 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
> Priority: Major
> Labels: pull-request-available
> 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)
