-
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
-
Labels:None
-
Target Version/s:
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