Test Result : FilterEstimationSuite

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

All Tests

Test nameDurationStatus
ColumnStatsMap tests1 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)1 msPassed
Not(cint <= 3 OR cint > 6)1 msPassed
Not(cint = 3 AND cstring < 'A8')2 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)0 msPassed
Not(null)1 msPassed
SPARK-36079: Bound selectivity >= 01 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 = true1 msPassed
cbool > false0 msPassed
cbool IN (true)1 msPassed
cdate < cast('2017-01-03' AS DATE)2 msPassed
cdate = cast('2017-01-02' AS DATE)1 msPassed
cdate IN ( cast('2017-01-03' AS DATE), cast('2017-01-04' AS DATE), cast('2017-01-05' AS DATE) )2 msPassed
cdecimal < 0.601 msPassed
cdecimal = 0.4000000000000000001 msPassed
cdouble < 3.01 msPassed
cint < 01 msPassed
cint < 31 msPassed
cint < 3 AND null2 msPassed
cint < 3 OR null2 msPassed
cint < cint20 msPassed
cint < cint30 msPassed
cint < cint41 msPassed
cint <= 31 msPassed
cint <=> 21 msPassed
cint = 00 msPassed
cint = 21 msPassed
cint = 3 OR cint = 61 msPassed
cint = cint21 msPassed
cint = cint31 msPassed
cint = cint40 msPassed
cint > 100 msPassed
cint > 3 AND cint <= 62 msPassed
cint > 61 msPassed
cint > cint20 msPassed
cint > cint30 msPassed
cint >= 61 msPassed
cint IN (1, 2, 3, 4, 5)1 msPassed
cint IN (3, 4, 5)12 msPassed
cint IS NOT NULL1 msPassed
cint IS NOT NULL && null0 msPassed
cint IS NULL0 msPassed
cint NOT IN (3, 4, 5)0 msPassed
cintHgm < 01 msPassed
cintHgm < 33 msPassed
cintHgm <= 31 msPassed
cintHgm = 01 msPassed
cintHgm = 3 OR cintHgm = 60 msPassed
cintHgm = 51 msPassed
cintHgm > 101 msPassed
cintHgm > 3 AND cintHgm <= 61 msPassed
cintHgm > 60 msPassed
cintHgm >= 61 msPassed
cintSkewHgm < 01 msPassed
cintSkewHgm < 31 msPassed
cintSkewHgm <= 30 msPassed
cintSkewHgm = 00 msPassed
cintSkewHgm = 3 OR cintSkewHgm = 61 msPassed
cintSkewHgm = 51 msPassed
cintSkewHgm > 101 msPassed
cintSkewHgm > 3 AND cintSkewHgm <= 62 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 node7 msPassed
evaluateInSet with all zeros0 msPassed
evaluateInSet with string1 msPassed
false0 msPassed
null1 msPassed
true11 msPassed
update ndv for columns based on overall selectivity1 msPassed