Sergey Soldatov created PHOENIX-2888:
----------------------------------------
Summary: 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
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)
