Test Result : PartitionBatchPruningSuite

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

All Tests

Test nameDurationStatus
SELECT CAST(s AS INT) FROM pruningStringData WHERE '18%' like s0.79 secPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s < '102'0.25 secPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s = '100'0.29 secPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s IN ('99', '150', '201')0.19 secPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s like '%'0.55 secPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s like '18%'0.19 secPassed
SELECT _1 FROM pruningArrayData WHERE _1 <= array(1)0.39 secPassed
SELECT _1 FROM pruningArrayData WHERE _1 = array(1)0.39 secPassed
SELECT _1 FROM pruningArrayData WHERE _1 >= array(1)0.19 secPassed
SELECT _1 FROM pruningArrayData WHERE _1 IN (array(1), array(2, 2))0.43 secPassed
SELECT _1 FROM pruningBinaryData WHERE _1 == binary(chr(1))0.7 secPassed
SELECT key FROM pruningData WHERE 1 <=> key95 msPassed
SELECT key FROM pruningData WHERE 1 = key78 msPassed
SELECT key FROM pruningData WHERE 11 >= key0.22 secPassed
SELECT key FROM pruningData WHERE 12 > key0.73 secPassed
SELECT key FROM pruningData WHERE 88 < key0.12 secPassed
SELECT key FROM pruningData WHERE 89 <= key0.37 secPassed
SELECT key FROM pruningData WHERE NOT (key < 88)0.33 secPassed
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))0.27 secPassed
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 > 880.14 secPassed
SELECT key FROM pruningData WHERE key < 1299 msPassed
SELECT key FROM pruningData WHERE key < 12 AND key IS NOT NULL0.34 secPassed
SELECT key FROM pruningData WHERE key < 2 OR (key > 78 AND key < 92)0.14 secPassed
SELECT key FROM pruningData WHERE key < 2 OR key > 990.18 secPassed
SELECT key FROM pruningData WHERE key <= 110.53 secPassed
SELECT key FROM pruningData WHERE key <=> 11 secPassed
SELECT key FROM pruningData WHERE key = 10.69 secPassed
SELECT key FROM pruningData WHERE key > 8 AND key <= 210.23 secPassed
SELECT key FROM pruningData WHERE key > 880.14 secPassed
SELECT key FROM pruningData WHERE key >= 890.68 secPassed
SELECT key FROM pruningData WHERE key IN (1)0.13 secPassed
SELECT key FROM pruningData WHERE key IN (1, 11)0.28 secPassed
SELECT key FROM pruningData WHERE key IN (1, 2)0.24 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)0.36 secPassed
SELECT key FROM pruningData WHERE key IN (1, 21, 41, 61, 81)0.17 secPassed
SELECT key FROM pruningData WHERE value IS NOT NULL0.21 secPassed
SELECT key FROM pruningData WHERE value IS NULL0.38 secPassed
disable IN_MEMORY_PARTITION_PRUNING0.48 secPassed