[
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)
