Test Result : PartitionBatchPruningSuite

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

All Tests

Test nameDurationStatus
SELECT CAST(s AS INT) FROM pruningStringData WHERE '18%' like s71 msPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s < '102'61 msPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s = '100'86 msPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s IN ('99', '150', '201')67 msPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s like '%'59 msPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s like '18%'74 msPassed
SELECT _1 FROM pruningArrayData WHERE _1 <= array(1)62 msPassed
SELECT _1 FROM pruningArrayData WHERE _1 = array(1)0.11 secPassed
SELECT _1 FROM pruningArrayData WHERE _1 >= array(1)67 msPassed
SELECT _1 FROM pruningArrayData WHERE _1 IN (array(1), array(2, 2))62 msPassed
SELECT _1 FROM pruningBinaryData WHERE _1 == binary(chr(1))97 msPassed
SELECT key FROM pruningData WHERE 1 <=> key56 msPassed
SELECT key FROM pruningData WHERE 1 = key69 msPassed
SELECT key FROM pruningData WHERE 11 >= key57 msPassed
SELECT key FROM pruningData WHERE 12 > key56 msPassed
SELECT key FROM pruningData WHERE 88 < key57 msPassed
SELECT key FROM pruningData WHERE 89 <= key58 msPassed
SELECT key FROM pruningData WHERE NOT (key < 88)67 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))64 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 > 8866 msPassed
SELECT key FROM pruningData WHERE key < 1261 msPassed
SELECT key FROM pruningData WHERE key < 12 AND key IS NOT NULL52 msPassed
SELECT key FROM pruningData WHERE key < 2 OR (key > 78 AND key < 92)75 msPassed
SELECT key FROM pruningData WHERE key < 2 OR key > 9978 msPassed
SELECT key FROM pruningData WHERE key <= 1164 msPassed
SELECT key FROM pruningData WHERE key <=> 158 msPassed
SELECT key FROM pruningData WHERE key = 10.1 secPassed
SELECT key FROM pruningData WHERE key > 8 AND key <= 2171 msPassed
SELECT key FROM pruningData WHERE key > 8871 msPassed
SELECT key FROM pruningData WHERE key >= 8962 msPassed
SELECT key FROM pruningData WHERE key IN (1)62 msPassed
SELECT key FROM pruningData WHERE key IN (1, 11)65 msPassed
SELECT key FROM pruningData WHERE key IN (1, 2)61 msPassed
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)58 msPassed
SELECT key FROM pruningData WHERE key IN (1, 21, 41, 61, 81)78 msPassed
SELECT key FROM pruningData WHERE value IS NOT NULL68 msPassed
SELECT key FROM pruningData WHERE value IS NULL85 msPassed
disable IN_MEMORY_PARTITION_PRUNING45 msPassed