Toshihiro Suzuki created PHOENIX-5411:
-----------------------------------------
Summary: Incorrect result when using sum function with case when
statement
Key: PHOENIX-5411
URL: https://issues.apache.org/jira/browse/PHOENIX-5411
Project: Phoenix
Issue Type: Bug
Reporter: Toshihiro Suzuki
Assignee: Toshihiro Suzuki
In the following case, incorrect result is returned:
{code}
0: jdbc:phoenix:> create table tbl (id varchar primary key, col1 varchar, col2
integer);
No rows affected (0.86 seconds)
0: jdbc:phoenix:> upsert into tbl values('id1', 'aaa', 2);
1 row affected (0.078 seconds)
0: jdbc:phoenix:> upsert into tbl values('id2', null, 1);
1 row affected (0.008 seconds)
0: jdbc:phoenix:> select sum(case when col1 is not null then col2 else 0 end),
sum(case when col1 is null then col2 else 0 end) from tbl;
+-------------------------------------------------------+-------------------------------------------------------+
| SUM(CASE WHEN COL1 IS NOT NULL THEN COL2 ELSE 0 END) | SUM(CASE WHEN COL1 IS
NOT NULL THEN COL2 ELSE 0 END) |
+-------------------------------------------------------+-------------------------------------------------------+
| 2 | 2
|
+-------------------------------------------------------+-------------------------------------------------------+
1 row selected (0.03 seconds)
{code}
The correct result is 2 and 1.
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
