Dmitry Lychagin created ASTERIXDB-2844:
------------------------------------------

             Summary: Syntax error with UNNEST
                 Key: ASTERIXDB-2844
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2844
             Project: Apache AsterixDB
          Issue Type: Bug
          Components: COMP - Compiler
    Affects Versions: 0.9.6
            Reporter: Dmitry Lychagin
            Assignee: Dmitry Lychagin
             Fix For: 0.9.7


The following query fails with syntax error:
{noformat}
with t as (select r, [r,r] ra from range(1, 2) r)
select count(*)
from t unnest t.ra
{noformat}

Workaround: use AS subclause in UNNEST: unnest t.ra AS x




--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to