Test Result : FilteredScanSuite

0 failures (±0)
52 tests (±0)
Took 2.3 sec.

All Tests

Test nameDurationStatus
PushDown Returns 0: SELECT * FROM oneToTenFiltered WHERE 1 > a23 msPassed
PushDown Returns 0: SELECT * FROM oneToTenFiltered WHERE a < 118 msPassed
PushDown Returns 0: SELECT * FROM oneToTenFiltered WHERE a = 2021 msPassed
PushDown Returns 0: SELECT a, b, c FROM oneToTenFiltered WHERE c like '%Ee%'22 msPassed
PushDown Returns 0: SELECT a, b, c FROM oneToTenFiltered WHERE c like '%d'21 msPassed
PushDown Returns 0: SELECT a, b, c FROM oneToTenFiltered WHERE c like 'C%'21 msPassed
PushDown Returns 10: SELECT * FROM oneToTenFiltered WHERE b = 121 msPassed
PushDown Returns 10: SELECT c FROM oneToTenFiltered WHERE A + b > 937 msPassed
PushDown Returns 1: SELECT * FROM oneToTenFiltered WHERE 1 = a21 msPassed
PushDown Returns 1: SELECT * FROM oneToTenFiltered WHERE A = 128 msPassed
PushDown Returns 1: SELECT * FROM oneToTenFiltered WHERE a = 119 msPassed
PushDown Returns 1: SELECT a FROM oneToTenFiltered WHERE A = 124 msPassed
PushDown Returns 1: SELECT a, b FROM oneToTenFiltered WHERE A = 125 msPassed
PushDown Returns 1: SELECT a, b, c FROM oneToTenFiltered WHERE c like '%D'22 msPassed
PushDown Returns 1: SELECT a, b, c FROM oneToTenFiltered WHERE c like '%eE%'18 msPassed
PushDown Returns 1: SELECT a, b, c FROM oneToTenFiltered WHERE c like 'c%'24 msPassed
PushDown Returns 1: SELECT b FROM oneToTenFiltered WHERE A = 120 msPassed
PushDown Returns 1: SELECT c FROM oneToTenFiltered WHERE c = 'aaaaaAAAAA'33 msPassed
PushDown Returns 1: SELECT c FROM oneToTenFiltered WHERE c IN ('aaaaaAAAAA', 'foo')19 msPassed
PushDown Returns 2: SELECT * FROM oneToTenFiltered WHERE 2 >= a23 msPassed
PushDown Returns 2: SELECT * FROM oneToTenFiltered WHERE a <= 219 msPassed
PushDown Returns 3: SELECT * FROM oneToTenFiltered WHERE a < 5 AND a > 118 msPassed
PushDown Returns 3: SELECT * FROM oneToTenFiltered WHERE a IN (1,3,5)20 msPassed
PushDown Returns 3: SELECT a FROM oneToTenFiltered WHERE a + b > 9 AND b < 16 AND c IN ('bbbbbBBBBB', 'cccccCCCCC', 'dddddDDDDD', 'foo')23 msPassed
PushDown Returns 4: SELECT * FROM oneToTenFiltered WHERE a < 3 OR a > 819 msPassed
PushDown Returns 5: SELECT * FROM oneToTenFiltered WHERE NOT (a < 6)19 msPassed
PushDown Returns 8: SELECT * FROM oneToTenFiltered WHERE a > 1 AND a < 1021 msPassed
PushDown Returns 9: SELECT * FROM oneToTenFiltered WHERE 1 < a21 msPassed
PushDown Returns 9: SELECT * FROM oneToTenFiltered WHERE 2 <= a23 msPassed
PushDown Returns 9: SELECT * FROM oneToTenFiltered WHERE a > 122 msPassed
PushDown Returns 9: SELECT * FROM oneToTenFiltered WHERE a >= 223 msPassed
SELECT * FROM oneToTenFiltered0.13 secPassed
SELECT A AS b FROM oneToTenFiltered0.11 secPassed
SELECT a * 2 FROM oneToTenFiltered0.1 secPassed
SELECT a FROM oneToTenFiltered93 msPassed
SELECT a, b FROM oneToTenFiltered0.11 secPassed
SELECT a, b FROM oneToTenFiltered WHERE A = 156 msPassed
SELECT a, b FROM oneToTenFiltered WHERE NOT (a < 6)48 msPassed
SELECT a, b FROM oneToTenFiltered WHERE a < 3 OR a > 845 msPassed
SELECT a, b FROM oneToTenFiltered WHERE a < 5 AND a > 162 msPassed
SELECT a, b FROM oneToTenFiltered WHERE a = 154 msPassed
SELECT a, b FROM oneToTenFiltered WHERE a IN (1,3,5)52 msPassed
SELECT a, b FROM oneToTenFiltered WHERE a IS NOT NULL48 msPassed
SELECT a, b FROM oneToTenFiltered WHERE a IS NULL17 msPassed
SELECT a, b FROM oneToTenFiltered WHERE b = 269 msPassed
SELECT a, b, c FROM oneToTenFiltered WHERE c like '%D'49 msPassed
SELECT a, b, c FROM oneToTenFiltered WHERE c like '%eE%'53 msPassed
SELECT a, b, c FROM oneToTenFiltered WHERE c like 'c%'52 msPassed
SELECT b FROM oneToTenFiltered83 msPassed
SELECT b, a FROM oneToTenFiltered87 msPassed
SELECT x.a, y.b FROM oneToTenFiltered x JOIN oneToTenFiltered y ON x.a = y.b0.15 secPassed
SELECT x.b, y.a FROM oneToTenFiltered x JOIN oneToTenFiltered y ON x.a = y.b0.18 secPassed