1
1
drop table if exists t1, t2;
3
# Bug#13694811: THE OPTIMIZER WRONGLY USES THE FIRST
4
# INNODB PARTITION STATISTICS
12
PARTITION BY RANGE (a)
13
SUBPARTITION BY HASH (a) SUBPARTITIONS 10
14
(PARTITION pNeg VALUES LESS THAN (0),
15
PARTITION p0 VALUES LESS THAN (1000),
16
PARTITION pMAX VALUES LESS THAN MAXVALUE);
17
# Only one row in the first 10 subpartitions
18
INSERT INTO t1 VALUES (-1, 'Only negative pk value');
19
INSERT INTO t1 VALUES (0, 'Mod Zero'), (1, 'One'), (2, 'Two'), (3, 'Three'),
20
(10, 'Zero'), (11, 'Mod One'), (12, 'Mod Two'), (13, 'Mod Three'),
21
(20, '0'), (21, '1'), (22, '2'), (23, '3'),
22
(4, '4'), (5, '5'), (6, '6'), (7, '7'), (8, '8'), (9, '9');
23
INSERT INTO t1 SELECT a + 30, b FROM t1 WHERE a >= 0;
25
Table Op Msg_type Msg_text
26
test.t1 analyze status OK
27
EXPLAIN SELECT b FROM t1 WHERE b between 'L' and 'N' AND a > -100;
28
id select_type table type possible_keys key key_len ref rows Extra
29
1 SIMPLE t1 range PRIMARY,b b 67 NULL 18 Using where; Using index
3
32
# Bug#56287: crash when using Partition datetime in sub in query