You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@kylin.apache.org by "Zhong Yanghong (Jira)" <ji...@apache.org> on 2019/12/02 02:45:00 UTC

[jira] [Created] (KYLIN-4275) Result of count(case when) is not correct

Zhong Yanghong created KYLIN-4275:
-------------------------------------

             Summary: Result of count(case when) is not correct
                 Key: KYLIN-4275
                 URL: https://issues.apache.org/jira/browse/KYLIN-4275
             Project: Kylin
          Issue Type: Bug
            Reporter: Zhong Yanghong


For the following sql, the result is not correct:
{code}
select count(case when LEAF_CATEG_ID=165888 then 1 else null end)
from TEST_KYLIN_FACT
{code}

The result should be equal to 
{code}
select count(*)
from TEST_KYLIN_FACT
where LEAF_CATEG_ID=165888
{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)