phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-1239) IN clause (and some others) cannot get moved from HAVING clause to WHERE clause when qualified
Date Mon, 29 Sep 2014 04:04:33 GMT

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

Hudson commented on PHOENIX-1239:
---------------------------------

SUCCESS: Integrated in Phoenix | Master | Hadoop1 #393 (See [https://builds.apache.org/job/Phoenix-master-hadoop1/393/])
PHOENIX-1239 IN clause (and some others) cannot get moved from HAVING clause to WHERE clause
when qualified (maryannxue: rev 4fce08c90bf52ba29642a2aa40971c32516b7c20)
* phoenix-core/src/main/java/org/apache/phoenix/parse/StatelessTraverseAllParseNodeVisitor.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/JoinCompiler.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/ParseNodeRewriter.java
* phoenix-core/src/test/java/org/apache/phoenix/compile/HavingCompilerTest.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/TraverseAllParseNodeVisitor.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/BooleanParseNodeVisitor.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/HavingCompiler.java


> IN clause (and some others) cannot get moved from HAVING clause to WHERE clause when
qualified
> ----------------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-1239
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1239
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 3.0.0, 4.0.0, 5.0.0
>            Reporter: Maryann Xue
>            Assignee: Maryann Xue
>            Priority: Minor
>         Attachments: 1239.patch
>
>   Original Estimate: 24h
>  Remaining Estimate: 24h
>
> {code}   
>     @Test
>     public void testInListHavingToWhere() throws SQLException {
>         String query = "select count(1) from atable group by a_string having a_string
in ('foo', 'bar')";
>         List<Object> binds = Collections.emptyList();
>         Expressions expressions = compileStatement(query,binds);
>         Expression w = TestUtil.in(A_STRING,"foo","bar");
>         assertEquals(w, expressions.whereClause);
>         assertNull(expressions.havingClause);
>     }
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message