[
https://issues.apache.org/jira/browse/PHOENIX-5411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16894207#comment-16894207
]
Hudson commented on PHOENIX-5411:
---------------------------------
SUCCESS: Integrated in Jenkins build Phoenix-4.x-HBase-1.4 #236 (See
[https://builds.apache.org/job/Phoenix-4.x-HBase-1.4/236/])
PHOENIX-5411 Incorrect result is returned when using sum function with (ankit:
rev 3c5482e91d8b8b11db6bc84ce3d97caa8e77e63f)
* (edit)
phoenix-core/src/main/java/org/apache/phoenix/expression/IsNullExpression.java
* (add) phoenix-core/src/it/java/org/apache/phoenix/end2end/SumFunctionIT.java
> Incorrect result is returned 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
> Priority: Major
> Fix For: 4.15.0
>
> Attachments: PHOENIX-5411.master.v1.patch,
> PHOENIX-5411.master.v2.patch
>
>
> 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, 1), but (2, 2) is returned.
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
