Test Result : FilterEstimationSuite

0 failures (±0)
77 tests (±0)
Took 1.1 sec.

All Tests

Test nameDurationStatus
01 msPassed
4000000000000000001 msPassed
602 msPassed
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')3 msPassed
Not(cint = 3 OR cstring < 'A8')1 msPassed
Not(cint > 3 AND cint <= 6)7 msPassed
Not(cintHgm < 3 AND null)5 msPassed
Not(cintSkewHgm < 3 AND null)1 msPassed
Not(null)1 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)1 msPassed
cdate IN ( cast('2017-01-03' AS DATE), cast('2017-01-04' AS DATE), cast('2017-01-05' AS DATE) )5 msPassed
cint < 01 msPassed
cint < 39 msPassed
cint < 3 AND null6 msPassed
cint < 3 OR null3 msPassed
cint < cint21 msPassed
cint < cint30 msPassed
cint < cint41 msPassed
cint <= 31 msPassed
cint <=> 21 msPassed
cint = 00 msPassed
cint = 22 msPassed
cint = 3 OR cint = 61 msPassed
cint = cint23 msPassed
cint = cint30 msPassed
cint = cint41 msPassed
cint > 109 msPassed
cint > 3 AND cint <= 63 msPassed
cint > 61 msPassed
cint > cint21 msPassed
cint > cint30 msPassed
cint >= 69 msPassed
cint IN (1, 2, 3, 4, 5)1 msPassed
cint IN (3, 4, 5)8 msPassed
cint IS NOT NULL2 msPassed
cint IS NOT NULL && null1 msPassed
cint IS NULL1 msPassed
cint NOT IN (3, 4, 5)1 msPassed
cintHgm < 01 msPassed
cintHgm < 31 msPassed
cintHgm <= 31 msPassed
cintHgm = 00 msPassed
cintHgm = 3 OR cintHgm = 61 msPassed
cintHgm = 51 msPassed
cintHgm > 100 msPassed
cintHgm > 3 AND cintHgm <= 61 msPassed
cintHgm > 61 msPassed
cintHgm >= 60 msPassed
cintSkewHgm < 00 msPassed
cintSkewHgm < 31 msPassed
cintSkewHgm <= 31 msPassed
cintSkewHgm = 01 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 condition1 msPassed
cstring = 'A2'1 msPassed
don't estimate IsNull or IsNotNull if the child is a non-leaf node7 msPassed
evaluateInSet with all zeros1 msPassed
evaluateInSet with string1 msPassed
false1 msPassed
null0 msPassed
true0.97 secPassed
update ndv for columns based on overall selectivity1 msPassed