phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Maryann Xue (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 Wed, 10 Sep 2014 00:08:28 GMT

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

Maryann Xue commented on PHOENIX-1239:
--------------------------------------

Yes, exactly. So I think several other "boolean" nodes should also be covered by this HavingClauseVisitor,
like InListParseNode and LikeParseNode. Right?

> 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
>            Priority: Minor
>   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