Maryann Xue created PHOENIX-2444:
------------------------------------
Summary: Expansion of derived table query works incorrectly with
aggregate over order by
Key: PHOENIX-2444
URL: https://issues.apache.org/jira/browse/PHOENIX-2444
Project: Phoenix
Issue Type: Bug
Reporter: Maryann Xue
Assignee: Maryann Xue
Priority: Minor
Example:
"select max(a) from (select * from t order by b) as t0"
was rewritten wrongly as
"select max(a) from t order by b"
while it should be equivalent to
"select max(a) from (select * from t) as t0"
and should be rewritten as
"select max(a) from t".
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)