[
https://issues.apache.org/jira/browse/ASTERIXDB-2750?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dmitry Lychagin resolved ASTERIXDB-2750.
----------------------------------------
Resolution: Fixed
> Incorrect result with simple unnest (",") followed by JOIN
> ----------------------------------------------------------
>
> Key: ASTERIXDB-2750
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2750
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Affects Versions: 0.9.4.1
> Reporter: Dmitry Lychagin
> Assignee: Dmitry Lychagin
> Priority: Major
> Fix For: 0.9.5
>
>
> Simple unnest (",") should be equivalent to using UNNEST keyword. However a
> combination of simple unnest followed by JOIN produces incorrect result.
> Consider these 3 queries which should return the same result (24 = 2*3*4):
> Q1: (UNNEST then JOIN ON TRUE)
> {noformat}
> with
> t1 as [ { "x": 1, "y": [10, 11, 12] }, { "x": 2, "y": [20, 21, 22] } ],
> t2 as [ 100, 101, 102, 103 ]
> from t1 as t1 unnest t1.y as y join t2 as t2 on true
> select value count(*)
> {noformat}
> Correct: returns 24 as expected.
> Q2: ("," then ",")
> {noformat}
> with
> t1 as [ { "x": 1, "y": [10, 11, 12] }, { "x": 2, "y": [20, 21, 22] } ],
> t2 as [ 100, 101, 102, 103 ]
> from t1 as t1, t1.y as y, t2 as t2
> select value count(*)
> {noformat}
> Correct: returns 24 as expected.
> Q3: ("," then JOIN ON TRUE)
> {noformat}
> with
> t1 as [ { "x": 1, "y": [10, 11, 12] }, { "x": 2, "y": [20, 21, 22] } ],
> t2 as [ 100, 101, 102, 103 ]
> from t1 as t1, t1.y as y join t2 as t2 on true
> select value count(*)
> {noformat}
> INCORRECT: returns 48
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
