Test Result : FilterEstimationSuite

0 failures (±0)
80 tests (±0)
Took 52 ms.

All Tests

Test nameDurationStatus
ColumnStatsMap tests0 msPassed
Not(Not(null))0 msPassed
Not(cint < 3 AND Not(null))1 msPassed
Not(cint < 3 AND null)1 msPassed
Not(cint < 3 OR null)0 msPassed
Not(cint <= 3 OR cint > 6)1 msPassed
Not(cint = 3 AND cstring < 'A8')1 msPassed
Not(cint = 3 OR cstring < 'A8')1 msPassed
Not(cint > 3 AND cint <= 6)0 msPassed
Not(cintHgm < 3 AND null)1 msPassed
Not(cintSkewHgm < 3 AND null)0 msPassed
Not(null)1 msPassed
SPARK-36079: Bound selectivity >= 00 msPassed
SPARK-36079: Null count higher than row count1 msPassed
SPARK-36079: Null count should be no higher than row count after filter0 msPassed
cbool = true0 msPassed
cbool > false1 msPassed
cbool IN (true)1 msPassed
cdate < cast('2017-01-03' AS DATE)1 msPassed
cdate = cast('2017-01-02' AS DATE)0 msPassed
cdate IN ( cast('2017-01-03' AS DATE), cast('2017-01-04' AS DATE), cast('2017-01-05' AS DATE) )1 msPassed
cdecimal < 0.600 msPassed
cdecimal = 0.4000000000000000001 msPassed
cdouble < 3.01 msPassed
cint < 00 msPassed
cint < 31 msPassed
cint < 3 AND null2 msPassed
cint < 3 OR null1 msPassed
cint < cint20 msPassed
cint < cint30 msPassed
cint < cint40 msPassed
cint <= 31 msPassed
cint <=> 20 msPassed
cint = 00 msPassed
cint = 21 msPassed
cint = 3 OR cint = 61 msPassed
cint = cint20 msPassed
cint = cint30 msPassed
cint = cint41 msPassed
cint > 100 msPassed
cint > 3 AND cint <= 61 msPassed
cint > 61 msPassed
cint > cint21 msPassed
cint > cint30 msPassed
cint >= 61 msPassed
cint IN (1, 2, 3, 4, 5)0 msPassed
cint IN (3, 4, 5)3 msPassed
cint IS NOT NULL0 msPassed
cint IS NOT NULL && null1 msPassed
cint IS NULL0 msPassed
cint NOT IN (3, 4, 5)0 msPassed
cintHgm < 00 msPassed
cintHgm < 31 msPassed
cintHgm <= 31 msPassed
cintHgm = 00 msPassed
cintHgm = 3 OR cintHgm = 60 msPassed
cintHgm = 50 msPassed
cintHgm > 101 msPassed
cintHgm > 3 AND cintHgm <= 61 msPassed
cintHgm > 60 msPassed
cintHgm >= 60 msPassed
cintSkewHgm < 00 msPassed
cintSkewHgm < 30 msPassed
cintSkewHgm <= 30 msPassed
cintSkewHgm = 00 msPassed
cintSkewHgm = 3 OR cintSkewHgm = 61 msPassed
cintSkewHgm = 51 msPassed
cintSkewHgm > 100 msPassed
cintSkewHgm > 3 AND cintSkewHgm <= 60 msPassed
cintSkewHgm > 61 msPassed
cintSkewHgm >= 61 msPassed
cstring < 'A2' - unsupported condition0 msPassed
cstring = 'A2'1 msPassed
don't estimate IsNull or IsNotNull if the child is a non-leaf node6 msPassed
evaluateInSet with all zeros1 msPassed
evaluateInSet with string0 msPassed
false0 msPassed
null0 msPassed
true6 msPassed
update ndv for columns based on overall selectivity1 msPassed