[ 
https://issues.apache.org/jira/browse/PHOENIX-2444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15027507#comment-15027507
 ] 

Hudson commented on PHOENIX-2444:
---------------------------------

FAILURE: Integrated in Phoenix-master #982 (See 
[https://builds.apache.org/job/Phoenix-master/982/])
PHOENIX-2444 Expansion of derived table query works incorrectly with 
(maryannxue: rev 7b2e1b1493c1fe2bbcf8d2c8b5de6ba1447f7ec3)
* phoenix-core/src/it/java/org/apache/phoenix/end2end/DerivedTableIT.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/SubselectRewriter.java


> 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
>             Fix For: 4.7.0
>
>         Attachments: PHOENIX-2444.patch
>
>
> 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