Na Zhai created KYLIN-3532: ------------------------------ Summary: Inconsistent results of the query Key: KYLIN-3532 URL: https://issues.apache.org/jira/browse/KYLIN-3532 Project: Kylin Issue Type: Bug Components: Query Engine Reporter: Na Zhai
When I query with sql "select count(*) from KYLIN_CATEGORY_GROUPINGS where KYLIN_CATEGORY_GROUPINGS.KYLIN_GROUPINGS_CRE_DATE > DATE '2012-09-02'". The query result shows 0 which is correct. When I query with sql "select count(*) from KYLIN_CATEGORY_GROUPINGS where KYLIN_CATEGORY_GROUPINGS.KYLIN_GROUPINGS_CRE_DATE < DATE '2012-09-02'". The query result shows 0 which is wrong. It should be 14. When I query with sql "select count(*) from KYLIN_CATEGORY_GROUPINGS where KYLIN_CATEGORY_GROUPINGS.KYLIN_GROUPINGS_CRE_DATE > DATE '2010-09-02'". The query result shows 14 which is correct. -- This message was sent by Atlassian JIRA (v7.6.3#76005)