[
https://issues.apache.org/jira/browse/PHOENIX-2888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15282053#comment-15282053
]
James Taylor commented on PHOENIX-2888:
---------------------------------------
Good catch, [~sergey.soldatov]! That's definitely a bug. You might spot check
any other Expression implementors for the same mistake.
> Aggregations for similar IN list expressions doesn't work correctly
> -------------------------------------------------------------------
>
> Key: PHOENIX-2888
> URL: https://issues.apache.org/jira/browse/PHOENIX-2888
> Project: Phoenix
> Issue Type: Bug
> Reporter: Sergey Soldatov
> Assignee: Sergey Soldatov
> Attachments: PHOENIX-2888-1.patch
>
>
> The test case:
> {noformat}
> create table test (id integer primary key, i1 integer, i2 integer);
> upsert into test values (1,1,1);
> upsert into test values (2,1,11);
> SELECT (SUM(CASE WHEN i1 in (1,2) THEN 1 ELSE 0 END)), (SUM(CASE WHEN i2 in
> (1,2) THEN 1 ELSE 0 END)) from test;
> {noformat}
> Expected result: 2, 1
> Real result : 2,2
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
