Test Result : FilteredScanSuite

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

All Tests

Test nameDurationStatus
PushDown Returns 0: SELECT * FROM oneToTenFiltered WHERE 1 > a25 msPassed
PushDown Returns 0: SELECT * FROM oneToTenFiltered WHERE a < 121 msPassed
PushDown Returns 0: SELECT * FROM oneToTenFiltered WHERE a = 2015 msPassed
PushDown Returns 0: SELECT a, b, c FROM oneToTenFiltered WHERE c like '%Ee%'18 msPassed
PushDown Returns 0: SELECT a, b, c FROM oneToTenFiltered WHERE c like '%d'17 msPassed
PushDown Returns 0: SELECT a, b, c FROM oneToTenFiltered WHERE c like 'C%'17 msPassed
PushDown Returns 10: SELECT * FROM oneToTenFiltered WHERE b = 117 msPassed
PushDown Returns 10: SELECT c FROM oneToTenFiltered WHERE A + b > 934 msPassed
PushDown Returns 1: SELECT * FROM oneToTenFiltered WHERE 1 = a21 msPassed
PushDown Returns 1: SELECT * FROM oneToTenFiltered WHERE A = 125 msPassed
PushDown Returns 1: SELECT * FROM oneToTenFiltered WHERE a = 143 msPassed
PushDown Returns 1: SELECT a FROM oneToTenFiltered WHERE A = 120 msPassed
PushDown Returns 1: SELECT a, b FROM oneToTenFiltered WHERE A = 120 msPassed
PushDown Returns 1: SELECT a, b, c FROM oneToTenFiltered WHERE c like '%D'17 msPassed
PushDown Returns 1: SELECT a, b, c FROM oneToTenFiltered WHERE c like '%eE%'21 msPassed
PushDown Returns 1: SELECT a, b, c FROM oneToTenFiltered WHERE c like 'c%'16 msPassed
PushDown Returns 1: SELECT b FROM oneToTenFiltered WHERE A = 116 msPassed
PushDown Returns 1: SELECT c FROM oneToTenFiltered WHERE c = 'aaaaaAAAAA'30 msPassed
PushDown Returns 1: SELECT c FROM oneToTenFiltered WHERE c IN ('aaaaaAAAAA', 'foo')19 msPassed
PushDown Returns 2: SELECT * FROM oneToTenFiltered WHERE 2 >= a24 msPassed
PushDown Returns 2: SELECT * FROM oneToTenFiltered WHERE a <= 222 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')25 msPassed
PushDown Returns 4: SELECT * FROM oneToTenFiltered WHERE a < 3 OR a > 817 msPassed
PushDown Returns 5: SELECT * FROM oneToTenFiltered WHERE NOT (a < 6)17 msPassed
PushDown Returns 8: SELECT * FROM oneToTenFiltered WHERE a > 1 AND a < 1018 msPassed
PushDown Returns 9: SELECT * FROM oneToTenFiltered WHERE 1 < a23 msPassed
PushDown Returns 9: SELECT * FROM oneToTenFiltered WHERE 2 <= a97 msPassed
PushDown Returns 9: SELECT * FROM oneToTenFiltered WHERE a > 121 msPassed
PushDown Returns 9: SELECT * FROM oneToTenFiltered WHERE a >= 222 msPassed
SELECT * FROM oneToTenFiltered0.14 secPassed
SELECT A AS b FROM oneToTenFiltered40 msPassed
SELECT a * 2 FROM oneToTenFiltered54 msPassed
SELECT a FROM oneToTenFiltered0.16 secPassed
SELECT a, b FROM oneToTenFiltered93 msPassed
SELECT a, b FROM oneToTenFiltered WHERE A = 139 msPassed
SELECT a, b FROM oneToTenFiltered WHERE NOT (a < 6)40 msPassed
SELECT a, b FROM oneToTenFiltered WHERE a < 3 OR a > 840 msPassed
SELECT a, b FROM oneToTenFiltered WHERE a < 5 AND a > 140 msPassed
SELECT a, b FROM oneToTenFiltered WHERE a = 147 msPassed
SELECT a, b FROM oneToTenFiltered WHERE a IN (1,3,5)39 msPassed
SELECT a, b FROM oneToTenFiltered WHERE a IS NOT NULL36 msPassed
SELECT a, b FROM oneToTenFiltered WHERE a IS NULL11 msPassed
SELECT a, b FROM oneToTenFiltered WHERE b = 250 msPassed
SELECT a, b, c FROM oneToTenFiltered WHERE c like '%D'42 msPassed
SELECT a, b, c FROM oneToTenFiltered WHERE c like '%eE%'44 msPassed
SELECT a, b, c FROM oneToTenFiltered WHERE c like 'c%'42 msPassed
SELECT b FROM oneToTenFiltered70 msPassed
SELECT b, a FROM oneToTenFiltered97 msPassed
SELECT x.a, y.b FROM oneToTenFiltered x JOIN oneToTenFiltered y ON x.a = y.b0.1 secPassed
SELECT x.b, y.a FROM oneToTenFiltered x JOIN oneToTenFiltered y ON x.a = y.b0.13 secPassed