[teiid-issues] [JBoss JIRA] (TEIID-3783) Error when limit/sort is pushed above a window function

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