Test Result : FilterEstimationSuite

0 failures (±0)
77 tests (±0)
Took 87 ms.

All Tests

Test nameDurationStatus
01 msPassed
4000000000000000001 msPassed
601 msPassed
ColumnStatsMap tests1 msPassed
Not(Not(null))1 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)0 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)2 msPassed
Not(cintSkewHgm < 3 AND null)1 msPassed
Not(null)0 msPassed
cbool = true1 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)1 msPassed
cdate IN ( cast('2017-01-03' AS DATE), cast('2017-01-04' AS DATE), cast('2017-01-05' AS DATE) )3 msPassed
cint < 00 msPassed
cint < 31 msPassed
cint < 3 AND null3 msPassed
cint < 3 OR null2 msPassed
cint < cint20 msPassed
cint < cint30 msPassed
cint < cint40 msPassed
cint <= 31 msPassed
cint <=> 20 msPassed
cint = 01 msPassed
cint = 21 msPassed
cint = 3 OR cint = 61 msPassed
cint = cint22 msPassed
cint = cint31 msPassed
cint = cint40 msPassed
cint > 101 msPassed
cint > 3 AND cint <= 61 msPassed
cint > 61 msPassed
cint > cint21 msPassed
cint > cint31 msPassed
cint >= 61 msPassed
cint IN (1, 2, 3, 4, 5)1 msPassed
cint IN (3, 4, 5)3 msPassed
cint IS NOT NULL1 msPassed
cint IS NOT NULL && null0 msPassed
cint IS NULL1 msPassed
cint NOT IN (3, 4, 5)1 msPassed
cintHgm < 00 msPassed
cintHgm < 30 msPassed
cintHgm <= 31 msPassed
cintHgm = 01 msPassed
cintHgm = 3 OR cintHgm = 61 msPassed
cintHgm = 51 msPassed
cintHgm > 101 msPassed
cintHgm > 3 AND cintHgm <= 61 msPassed
cintHgm > 61 msPassed
cintHgm >= 61 msPassed
cintSkewHgm < 00 msPassed
cintSkewHgm < 31 msPassed
cintSkewHgm <= 31 msPassed
cintSkewHgm = 00 msPassed
cintSkewHgm = 3 OR cintSkewHgm = 62 msPassed
cintSkewHgm = 50 msPassed
cintSkewHgm > 100 msPassed
cintSkewHgm > 3 AND cintSkewHgm <= 65 msPassed
cintSkewHgm > 61 msPassed
cintSkewHgm >= 61 msPassed
cstring < 'A2' - unsupported condition1 msPassed
cstring = 'A2'0 msPassed
don't estimate IsNull or IsNotNull if the child is a non-leaf node3 msPassed
evaluateInSet with all zeros0 msPassed
evaluateInSet with string0 msPassed
false1 msPassed
null0 msPassed
true14 msPassed
update ndv for columns based on overall selectivity1 msPassed