[
https://issues.apache.org/jira/browse/CALCITE-6995?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yu Xu updated CALCITE-6995:
---------------------------
Description:
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(connect link like:
jdbc::mysql://startrocks.url:9030):*
{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}
was:
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}
> 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(connect link like:
> jdbc::mysql://startrocks.url:9030):*
> {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)
