[HIVE-11493] Predicate with integer column equals double evaluates to false

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 0.14.0, 1.0.0, 1.2.0, 1.2.1, 2.0.0
• Fix Version/s: 2.0.0
• Component/s: Query Planning
• Target Version/s: 1.3.0
• Assignee: Pengcheng Xiong
• Reporter: Prasanth Jayachandran
• Created: 06/Aug/15 20:29
• Updated: 16/Feb/16 23:49
• Resolved: 14/Aug/15 05:36

Description

Filters with integer column equals double constant evaluates to false everytime. Negative double constant works fine.

explain select * from orc_ppd where t = 10.0;

OK
Stage-0
   Fetch Operator
      limit:-1
      Select Operator [SEL_2]
         outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
         Filter Operator [FIL_1]
            predicate:false (type: boolean)
            TableScan [TS_0]
               alias:orc_ppd

explain select * from orc_ppd where t = -10.0;

OK
Stage-0
   Fetch Operator
      limit:-1
      Select Operator [SEL_2]
         outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
         Filter Operator [FIL_1]
            predicate:(t = (- 10.0)) (type: boolean)
            TableScan [TS_0]
               alias:orc_ppd