jay wong created PHOENIX-988:
--------------------------------
Summary: The result is not expected when select case when case
Key: PHOENIX-988
URL: https://issues.apache.org/jira/browse/PHOENIX-988
Project: Phoenix
Issue Type: Bug
Affects Versions: 3.0.0
Reporter: jay wong
Fix For: 3.1
A table :
select count(*) count from table1 where int_column_a<10;
+------------+
| COUNT |
+------------+
| 0 |
+------------+
then select with sql :
select count( distinct case when int_column_a<10 then 2 else null end ) count
from table1;
the expected reuslt is 0. but 1 we got.
As the CaseExcression#evaluate doesn't handle the case.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
