You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Ian Maxon (Jira)" <ji...@apache.org> on 2023/08/11 17:09:00 UTC
[jira] [Resolved] (ASTERIXDB-3240) Convert outer joins to joins when possible
[ https://issues.apache.org/jira/browse/ASTERIXDB-3240?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ian Maxon resolved ASTERIXDB-3240.
----------------------------------
Assignee: murali krishna
Resolution: Fixed
> Convert outer joins to joins when possible
> ------------------------------------------
>
> Key: ASTERIXDB-3240
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3240
> Project: Apache AsterixDB
> Issue Type: Improvement
> Reporter: murali krishna
> Assignee: murali krishna
> Priority: Minor
> Labels: triaged
>
> In this query the outer join can be converted to an inner join
> select count (*) from R r left outer join S s on r.rand = s.rand join T t on s.u1K = t.u1K;
> Similarly, both outer joins here can be converted to joinsÂ
> select count (*) from R r left outer join S s on r.rand = s.rand left outer join T t on s.u1K = t.u1K join U u on t.u4K = u.u4K;
--
This message was sent by Atlassian Jira
(v8.20.10#820010)