Test Result : FilterEstimationSuite

0 failures
80 tests
Took 69 ms.

All Tests

Test nameDurationStatus
00 msPassed
4000000000000000000 msPassed
601 msPassed
ColumnStatsMap tests0 msPassed
Not(Not(null))0 msPassed
Not(cint < 3 AND Not(null))0 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)3 msPassed
Not(cintSkewHgm < 3 AND null)1 msPassed
Not(null)2 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)0 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
cint < 00 msPassed
cint < 31 msPassed
cint < 3 AND null4 msPassed
cint < 3 OR null2 msPassed
cint < cint21 msPassed
cint < cint31 msPassed
cint < cint41 msPassed
cint <= 31 msPassed
cint <=> 20 msPassed
cint = 00 msPassed
cint = 21 msPassed
cint = 3 OR cint = 61 msPassed
cint = cint21 msPassed
cint = cint30 msPassed
cint = cint40 msPassed
cint > 101 msPassed
cint > 3 AND cint <= 61 msPassed
cint > 60 msPassed
cint > cint20 msPassed
cint > cint30 msPassed
cint >= 60 msPassed
cint IN (1, 2, 3, 4, 5)1 msPassed
cint IN (3, 4, 5)2 msPassed
cint IS NOT NULL0 msPassed
cint IS NOT NULL && null1 msPassed
cint IS NULL0 msPassed
cint NOT IN (3, 4, 5)1 msPassed
cintHgm < 00 msPassed
cintHgm < 31 msPassed
cintHgm <= 30 msPassed
cintHgm = 01 msPassed
cintHgm = 3 OR cintHgm = 61 msPassed
cintHgm = 51 msPassed
cintHgm > 100 msPassed
cintHgm > 3 AND cintHgm <= 61 msPassed
cintHgm > 60 msPassed
cintHgm >= 61 msPassed
cintSkewHgm < 00 msPassed
cintSkewHgm < 30 msPassed
cintSkewHgm <= 31 msPassed
cintSkewHgm = 01 msPassed
cintSkewHgm = 3 OR cintSkewHgm = 61 msPassed
cintSkewHgm = 50 msPassed
cintSkewHgm > 101 msPassed
cintSkewHgm > 3 AND cintSkewHgm <= 61 msPassed
cintSkewHgm > 60 msPassed
cintSkewHgm >= 60 msPassed
cstring < 'A2' - unsupported condition0 msPassed
cstring = 'A2'1 msPassed
don't estimate IsNull or IsNotNull if the child is a non-leaf node2 msPassed
evaluateInSet with all zeros1 msPassed
evaluateInSet with string0 msPassed
false1 msPassed
null0 msPassed
true17 msPassed
update ndv for columns based on overall selectivity1 msPassed