[
https://issues.apache.org/jira/browse/ASTERIXDB-2844?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dmitry Lychagin resolved ASTERIXDB-2844.
----------------------------------------
Resolution: Fixed
> 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
> Priority: Major
> 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)
