Test Result : PartitionBatchPruningSuite

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

All Tests

Test nameDurationStatus
SELECT CAST(s AS INT) FROM pruningStringData WHERE '18%' like s63 msPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s < '102'54 msPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s = '100'70 msPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s IN ('99', '150', '201')63 msPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s like '%'84 msPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s like '18%'64 msPassed
SELECT _1 FROM pruningArrayData WHERE _1 <= array(1)51 msPassed
SELECT _1 FROM pruningArrayData WHERE _1 = array(1)81 msPassed
SELECT _1 FROM pruningArrayData WHERE _1 >= array(1)50 msPassed
SELECT _1 FROM pruningArrayData WHERE _1 IN (array(1), array(2, 2))57 msPassed
SELECT _1 FROM pruningBinaryData WHERE _1 == binary(chr(1))75 msPassed
SELECT key FROM pruningData WHERE 1 <=> key50 msPassed
SELECT key FROM pruningData WHERE 1 = key51 msPassed
SELECT key FROM pruningData WHERE 11 >= key51 msPassed
SELECT key FROM pruningData WHERE 12 > key49 msPassed
SELECT key FROM pruningData WHERE 88 < key71 msPassed
SELECT key FROM pruningData WHERE 89 <= key52 msPassed
SELECT key FROM pruningData WHERE NOT (key < 88)63 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))61 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 > 8872 msPassed
SELECT key FROM pruningData WHERE key < 1261 msPassed
SELECT key FROM pruningData WHERE key < 12 AND key IS NOT NULL51 msPassed
SELECT key FROM pruningData WHERE key < 2 OR (key > 78 AND key < 92)53 msPassed
SELECT key FROM pruningData WHERE key < 2 OR key > 9948 msPassed
SELECT key FROM pruningData WHERE key <= 1161 msPassed
SELECT key FROM pruningData WHERE key <=> 149 msPassed
SELECT key FROM pruningData WHERE key = 177 msPassed
SELECT key FROM pruningData WHERE key > 8 AND key <= 2154 msPassed
SELECT key FROM pruningData WHERE key > 8853 msPassed
SELECT key FROM pruningData WHERE key >= 8952 msPassed
SELECT key FROM pruningData WHERE key IN (1)47 msPassed
SELECT key FROM pruningData WHERE key IN (1, 11)65 msPassed
SELECT key FROM pruningData WHERE key IN (1, 2)67 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)55 msPassed
SELECT key FROM pruningData WHERE key IN (1, 21, 41, 61, 81)61 msPassed
SELECT key FROM pruningData WHERE value IS NOT NULL48 msPassed
SELECT key FROM pruningData WHERE value IS NULL74 msPassed
disable IN_MEMORY_PARTITION_PRUNING42 msPassed