[
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}
test in mysql:
{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;
> SQL error [1064] [42000]: You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right syntax to
> use near 'full join (select 1 as id, 'bb' as name) as b on a.id=b.id
LIMIT 0, 200' at line 1 {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(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}
> 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}
>
> test in mysql:
> {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;
> > SQL error [1064] [42000]: You have an error in your SQL syntax; check the
> > manual that corresponds to your MySQL server version for the right syntax
> > to use near 'full join (select 1 as id, 'bb' as name) as b on a.id=b.id
> LIMIT 0, 200' at line 1 {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
