[KYLIN-3532] Inconsistent results of the query

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Incomplete
• Component/s: Query Engine
• Assignee: Unassigned
• Reporter: Na Zhai
• Created: 04/Sep/18 07:13
• Updated: 02/Mar/20 14:50
• Resolved: 02/Mar/20 14:50

Description

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.