Test Result : PartitionBatchPruningSuite

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

All Tests

Test nameDurationStatus
SELECT CAST(s AS INT) FROM pruningStringData WHERE '18%' like s40 msPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s < '102'37 msPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s = '100'57 msPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s IN ('99', '150', '201')40 msPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s like '%'36 msPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s like '18%'41 msPassed
SELECT _1 FROM pruningArrayData WHERE _1 <= array(1)40 msPassed
SELECT _1 FROM pruningArrayData WHERE _1 = array(1)78 msPassed
SELECT _1 FROM pruningArrayData WHERE _1 >= array(1)43 msPassed
SELECT _1 FROM pruningArrayData WHERE _1 IN (array(1), array(2, 2))38 msPassed
SELECT _1 FROM pruningBinaryData WHERE _1 == binary(chr(1))82 msPassed
SELECT key FROM pruningData WHERE 1 <=> key40 msPassed
SELECT key FROM pruningData WHERE 1 = key40 msPassed
SELECT key FROM pruningData WHERE 11 >= key37 msPassed
SELECT key FROM pruningData WHERE 12 > key39 msPassed
SELECT key FROM pruningData WHERE 88 < key38 msPassed
SELECT key FROM pruningData WHERE 89 <= key40 msPassed
SELECT key FROM pruningData WHERE NOT (key < 88)41 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))34 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 > 8836 msPassed
SELECT key FROM pruningData WHERE key < 1246 msPassed
SELECT key FROM pruningData WHERE key < 12 AND key IS NOT NULL26 msPassed
SELECT key FROM pruningData WHERE key < 2 OR (key > 78 AND key < 92)39 msPassed
SELECT key FROM pruningData WHERE key < 2 OR key > 9940 msPassed
SELECT key FROM pruningData WHERE key <= 1148 msPassed
SELECT key FROM pruningData WHERE key <=> 142 msPassed
SELECT key FROM pruningData WHERE key = 173 msPassed
SELECT key FROM pruningData WHERE key > 8 AND key <= 2141 msPassed
SELECT key FROM pruningData WHERE key > 8866 msPassed
SELECT key FROM pruningData WHERE key >= 8943 msPassed
SELECT key FROM pruningData WHERE key IN (1)27 msPassed
SELECT key FROM pruningData WHERE key IN (1, 11)40 msPassed
SELECT key FROM pruningData WHERE key IN (1, 2)46 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)33 msPassed
SELECT key FROM pruningData WHERE key IN (1, 21, 41, 61, 81)41 msPassed
SELECT key FROM pruningData WHERE value IS NOT NULL42 msPassed
SELECT key FROM pruningData WHERE value IS NULL46 msPassed
disable IN_MEMORY_PARTITION_PRUNING26 msPassed