Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
1.39.0
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):
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
test in mysql:
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
Attachments
Issue Links
- Blocked
-
CALCITE-4619 "Full join" generates an incorrect execution plan under mysql
-
- Closed
-
- links to