9
9
let $MYSQLD_DATADIR= `SELECT @@datadir`;
12
--echo # Bug#13694811: THE OPTIMIZER WRONGLY USES THE FIRST
13
--echo # INNODB PARTITION STATISTICS
22
PARTITION BY RANGE (a)
23
SUBPARTITION BY HASH (a) SUBPARTITIONS 10
24
(PARTITION pNeg VALUES LESS THAN (0),
25
PARTITION p0 VALUES LESS THAN (1000),
26
PARTITION pMAX VALUES LESS THAN MAXVALUE);
28
--echo # Only one row in the first 10 subpartitions
29
INSERT INTO t1 VALUES (-1, 'Only negative pk value');
31
INSERT INTO t1 VALUES (0, 'Mod Zero'), (1, 'One'), (2, 'Two'), (3, 'Three'),
32
(10, 'Zero'), (11, 'Mod One'), (12, 'Mod Two'), (13, 'Mod Three'),
33
(20, '0'), (21, '1'), (22, '2'), (23, '3'),
34
(4, '4'), (5, '5'), (6, '6'), (7, '7'), (8, '8'), (9, '9');
35
INSERT INTO t1 SELECT a + 30, b FROM t1 WHERE a >= 0;
37
EXPLAIN SELECT b FROM t1 WHERE b between 'L' and 'N' AND a > -100;
12
41
--echo # Bug#56287: crash when using Partition datetime in sub in query