Test Result : PartitionBatchPruningSuite

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

All Tests

Test nameDurationStatus
SELECT CAST(s AS INT) FROM pruningStringData WHERE '18%' like s94 msPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s < '102'74 msPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s = '100'0.13 secPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s IN ('99', '150', '201')79 msPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s like '%'78 msPassed
SELECT CAST(s AS INT) FROM pruningStringData WHERE s like '18%'87 msPassed
SELECT _1 FROM pruningArrayData WHERE _1 <= array(1)65 msPassed
SELECT _1 FROM pruningArrayData WHERE _1 = array(1)0.11 secPassed
SELECT _1 FROM pruningArrayData WHERE _1 >= array(1)65 msPassed
SELECT _1 FROM pruningArrayData WHERE _1 IN (array(1), array(2, 2))79 msPassed
SELECT _1 FROM pruningBinaryData WHERE _1 == binary(chr(1))0.1 secPassed
SELECT key FROM pruningData WHERE 1 <=> key61 msPassed
SELECT key FROM pruningData WHERE 1 = key71 msPassed
SELECT key FROM pruningData WHERE 11 >= key61 msPassed
SELECT key FROM pruningData WHERE 12 > key63 msPassed
SELECT key FROM pruningData WHERE 88 < key70 msPassed
SELECT key FROM pruningData WHERE 89 <= key71 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))72 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 > 8879 msPassed
SELECT key FROM pruningData WHERE key < 1269 msPassed
SELECT key FROM pruningData WHERE key < 12 AND key IS NOT NULL82 msPassed
SELECT key FROM pruningData WHERE key < 2 OR (key > 78 AND key < 92)84 msPassed
SELECT key FROM pruningData WHERE key < 2 OR key > 9993 msPassed
SELECT key FROM pruningData WHERE key <= 1166 msPassed
SELECT key FROM pruningData WHERE key <=> 161 msPassed
SELECT key FROM pruningData WHERE key = 10.1 secPassed
SELECT key FROM pruningData WHERE key > 8 AND key <= 2173 msPassed
SELECT key FROM pruningData WHERE key > 8873 msPassed
SELECT key FROM pruningData WHERE key >= 8991 msPassed
SELECT key FROM pruningData WHERE key IN (1)56 msPassed
SELECT key FROM pruningData WHERE key IN (1, 11)75 msPassed
SELECT key FROM pruningData WHERE key IN (1, 2)75 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)70 msPassed
SELECT key FROM pruningData WHERE key IN (1, 21, 41, 61, 81)87 msPassed
SELECT key FROM pruningData WHERE value IS NOT NULL70 msPassed
SELECT key FROM pruningData WHERE value IS NULL84 msPassed
disable IN_MEMORY_PARTITION_PRUNING53 msPassed