[jira] [Updated] (ASTERIXDB-3033) LEFT OUTER JOIN does not produce correct output

["Xean Nguyenla (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ASTERIXDB-3033?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Xean Nguyenla updated ASTERIXDB-3033:
-------------------------------------
    Affects Version/s: 0.9.7

> LEFT OUTER JOIN does not produce correct output
> -----------------------------------------------
>
>                 Key: ASTERIXDB-3033
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3033
>             Project: Apache AsterixDB
>          Issue Type: Bug
>    Affects Versions: 0.9.7
>            Reporter: Xean Nguyenla
>            Priority: Major
>         Attachments: inner_join_plan.txt, left_outer_join_plan.txt
>
>
> I am currently working with the CH2 benchmark data and ran into an issue regarding inner join vs. left outer join. When doing an inner join between customers & orders, there is a successful join (outputs 1 when finding how many counts of o_id are present). but when running the left outer join, it outputs 0 indicating no successful joins when it should output 1 as well. Plans for each query are attached below.



--
This message was sent by Atlassian Jira
(v8.20.7#820007)