Dmitry Lychagin created ASTERIXDB-2905:
------------------------------------------
Summary: 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
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)
