Test Result : PartitionBatchPruningSuite

0 failures
35 tests
Took 2.4 sec.

All Tests

Test nameDurationStatus
SELECT CAST(s AS INT) FROM pruningStringData WHERE s < '102'54 msPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s = '100'77 msPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s IN ('99', '150', '201')61 msPassed
SELECT _1 FROM pruningArrayData WHERE _1 <= array(1)67 msPassed
SELECT _1 FROM pruningArrayData WHERE _1 = array(1)0.11 secPassed
SELECT _1 FROM pruningArrayData WHERE _1 >= array(1)72 msPassed
SELECT _1 FROM pruningArrayData WHERE _1 IN (array(1), array(2, 2))0.12 secPassed
SELECT _1 FROM pruningBinaryData WHERE _1 == binary(chr(1))63 msPassed
SELECT key FROM pruningData WHERE 1 <=> key64 msPassed
SELECT key FROM pruningData WHERE 1 = key57 msPassed
SELECT key FROM pruningData WHERE 11 >= key53 msPassed
SELECT key FROM pruningData WHERE 12 > key45 msPassed
SELECT key FROM pruningData WHERE 88 < key59 msPassed
SELECT key FROM pruningData WHERE 89 <= key49 msPassed
SELECT key FROM pruningData WHERE NOT (key < 88)76 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))51 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 > 8865 msPassed
SELECT key FROM pruningData WHERE key < 1272 msPassed
SELECT key FROM pruningData WHERE key < 12 AND key IS NOT NULL79 msPassed
SELECT key FROM pruningData WHERE key < 2 OR (key > 78 AND key < 92)87 msPassed
SELECT key FROM pruningData WHERE key < 2 OR key > 9992 msPassed
SELECT key FROM pruningData WHERE key <= 1168 msPassed
SELECT key FROM pruningData WHERE key <=> 160 msPassed
SELECT key FROM pruningData WHERE key = 10.17 secPassed
SELECT key FROM pruningData WHERE key > 8 AND key <= 2171 msPassed
SELECT key FROM pruningData WHERE key > 8861 msPassed
SELECT key FROM pruningData WHERE key >= 8975 msPassed
SELECT key FROM pruningData WHERE key IN (1)47 msPassed
SELECT key FROM pruningData WHERE key IN (1, 11)60 msPassed
SELECT key FROM pruningData WHERE key IN (1, 2)63 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)52 msPassed
SELECT key FROM pruningData WHERE key IN (1, 21, 41, 61, 81)58 msPassed
SELECT key FROM pruningData WHERE value IS NOT NULL70 msPassed
SELECT key FROM pruningData WHERE value IS NULL78 msPassed
disable IN_MEMORY_PARTITION_PRUNING51 msPassed