[jira] [Created] (PHOENIX-2888) Aggregations for similar IN list expressions doesn't work correctly

["Sergey Soldatov (JIRA)" <ji...@apache.org>]

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)