[jira] [Created] (PHOENIX-988) The result is not expected when select case when case

["jay wong (JIRA)" <ji...@apache.org>]

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)