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)

Reply via email to