Steven Hawkins created TEIID-3783:
-------------------------------------
Summary: Error when limit/sort is pushed above a window function
Key: TEIID-3783
URL:
https://issues.jboss.org/browse/TEIID-3783
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.12
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.12.1, 8.13
TEIID-3568 introduced a regression by pushing a sort over a project node, but not
accounting for aliases. This can be reproduced with a query such as:
select column_a, column_b from (select sum(column_a) over (partition by key_column) as
column_a, key_column from a ) a left outer join ( select sum(column_b) over (partition by
key_column) as column_b, key_column from b) b on a.key_column = b.key_column order by
column_a desc limit 10
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)