[
https://issues.apache.org/jira/browse/ASTERIXDB-2857?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dmitry Lychagin resolved ASTERIXDB-2857.
----------------------------------------
Resolution: Fixed
Fixed by https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/10785
> Incorrect result for left outer join
> ------------------------------------
>
> Key: ASTERIXDB-2857
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2857
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: RT - Runtime
> Affects Versions: 0.9.6
> Reporter: Dmitry Lychagin
> Assignee: Dmitry Lychagin
> Priority: Major
> Fix For: 0.9.7
>
>
> 4 data partitions.
> The following query incorrectly returns 6 tuples. The correct result is 2
> tuples.
> {noformat}
> SELECT
> t0.unique1 AS t0_unique1,
> t1.unique1 AS t1_unique1,
> t2.unique1 AS t2_unique1
> FROM (
> SELECT unique1, unique2 FROM tenk WHERE unique2 < 2
> ) t0
> INNER JOIN (
> SELECT unique1, unique2 FROM tenk WHERE unique2 < 4
> ) t1 ON t0.unique2 = t1.unique2
> LEFT JOIN (
> SELECT unique1, unique2 FROM tenk WHERE unique2 < 6
> ) t2 ON t0.unique2 = t2.unique2 AND t1.unique2 = t2.unique2
> ORDER BY t0_unique1, t1_unique1, t2_unique1;
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
