[
https://issues.apache.org/jira/browse/PHOENIX-988?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
jay wong updated PHOENIX-988:
-----------------------------
Description:
A table :
select count( int_column_a ) 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.
was:
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.
> 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( int_column_a ) 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)
