12
--echo # Bug#53806: Wrong estimates for range query in partitioned MyISAM table
13
--echo # Bug#46754: 'rows' field doesn't reflect partition pruning
15
CREATE TABLE t1 (a INT PRIMARY KEY)
16
PARTITION BY RANGE (a) (
17
PARTITION p0 VALUES LESS THAN (1),
18
PARTITION p1 VALUES LESS THAN (2),
19
PARTITION p2 VALUES LESS THAN (3),
20
PARTITION p3 VALUES LESS THAN (4),
21
PARTITION p4 VALUES LESS THAN (5),
22
PARTITION p5 VALUES LESS THAN (6),
23
PARTITION max VALUES LESS THAN MAXVALUE);
25
INSERT INTO t1 VALUES (-1),(0),(1),(2),(3),(4),(5),(6),(7),(8);
27
--replace_column 1 # 2 # 3 # 4 # 5 # 6 # 7 # 8 # 9 # 11 #
28
EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a <= 1;
29
--replace_column 1 # 2 # 3 # 4 # 5 # 6 # 7 # 8 # 9 # 11 #
30
EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a < 7;
31
--replace_column 1 # 2 # 3 # 4 # 5 # 6 # 7 # 8 # 9 # 11 #
32
EXPLAIN PARTITIONS SELECT * FROM t1 WHERE a <= 1;
12
36
--echo # Bug#49742: Partition Pruning not working correctly for RANGE
14
38
CREATE TABLE t1 (a INT PRIMARY KEY)