[
https://issues.apache.org/jira/browse/ASTERIXDB-2905?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dmitry Lychagin resolved ASTERIXDB-2905.
----------------------------------------
Resolution: Fixed
> Ambiguous alias failure when window function is used inside subquery
> --------------------------------------------------------------------
>
> Key: ASTERIXDB-2905
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2905
> 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 "ASX1074: Cannot resolve ambiguous alias
> reference for identifier c2"
> {noformat}
> select c2,
> (
> select nth_value(c2, 3)
> over (partition by one order by c2 range between unbounded preceding
> and unbounded following)
> as nth
> from t1 x
> ) as q1
> from t1 y
> order by c2;
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
