Test Result : PartitionBatchPruningSuite

0 failures (±0)
38 tests (±0)
Took 3.6 sec.

All Tests

Test nameDurationStatus
SELECT CAST(s AS INT) FROM pruningStringData WHERE '18%' like s0.1 secPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s < '102'93 msPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s = '100'0.15 secPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s IN ('99', '150', '201')94 msPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s like '%'84 msPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s like '18%'0.1 secPassed
SELECT _1 FROM pruningArrayData WHERE _1 <= array(1)0.17 secPassed
SELECT _1 FROM pruningArrayData WHERE _1 = array(1)0.19 secPassed
SELECT _1 FROM pruningArrayData WHERE _1 >= array(1)94 msPassed
SELECT _1 FROM pruningArrayData WHERE _1 IN (array(1), array(2, 2))83 msPassed
SELECT _1 FROM pruningBinaryData WHERE _1 == binary(chr(1))0.13 secPassed
SELECT key FROM pruningData WHERE 1 <=> key79 msPassed
SELECT key FROM pruningData WHERE 1 = key79 msPassed
SELECT key FROM pruningData WHERE 11 >= key81 msPassed
SELECT key FROM pruningData WHERE 12 > key87 msPassed
SELECT key FROM pruningData WHERE 88 < key90 msPassed
SELECT key FROM pruningData WHERE 89 <= key90 msPassed
SELECT key FROM pruningData WHERE NOT (key < 88)93 msPassed
SELECT key FROM pruningData WHERE NOT (key IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30))90 msPassed
SELECT key FROM pruningData WHERE NOT (key IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30)) AND key > 8885 msPassed
SELECT key FROM pruningData WHERE key < 1268 msPassed
SELECT key FROM pruningData WHERE key < 12 AND key IS NOT NULL71 msPassed
SELECT key FROM pruningData WHERE key < 2 OR (key > 78 AND key < 92)85 msPassed
SELECT key FROM pruningData WHERE key < 2 OR key > 9974 msPassed
SELECT key FROM pruningData WHERE key <= 1181 msPassed
SELECT key FROM pruningData WHERE key <=> 187 msPassed
SELECT key FROM pruningData WHERE key = 10.16 secPassed
SELECT key FROM pruningData WHERE key > 8 AND key <= 2180 msPassed
SELECT key FROM pruningData WHERE key > 8886 msPassed
SELECT key FROM pruningData WHERE key >= 8980 msPassed
SELECT key FROM pruningData WHERE key IN (1)77 msPassed
SELECT key FROM pruningData WHERE key IN (1, 11)0.11 secPassed
SELECT key FROM pruningData WHERE key IN (1, 2)0.1 secPassed
SELECT key FROM pruningData WHERE key IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30)87 msPassed
SELECT key FROM pruningData WHERE key IN (1, 21, 41, 61, 81)0.1 secPassed
SELECT key FROM pruningData WHERE value IS NOT NULL92 msPassed
SELECT key FROM pruningData WHERE value IS NULL0.11 secPassed
disable IN_MEMORY_PARTITION_PRUNING57 msPassed