1
1
--source include/have_partition.inc
2
2
--source include/have_innodb_plugin.inc
3
# Remove the line below when bug#53307 is solved.
4
--source include/not_valgrind.inc
6
4
let $MYSQLD_DATADIR= `SELECT @@datadir`;
7
--echo # Bug#11766879/Bug#60106: DIFF BETWEEN # OF INDEXES IN MYSQL VS INNODB,
8
--echo # PARTITONING, ON INDEX CREATE
10
call mtr.add_suppression("contains 2 indexes inside InnoDB, which is different from the number of indexes 1 defined in the MySQL");
12
id bigint NOT NULL AUTO_INCREMENT,
16
) ENGINE=InnoDB DEFAULT CHARSET=utf8
17
/*!50100 PARTITION BY RANGE(TO_DAYS(time))
18
(PARTITION p10 VALUES LESS THAN (734708) ENGINE = InnoDB,
19
PARTITION p20 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */;
21
INSERT INTO t1 (time,id2) VALUES ('2011-07-24',1);
22
INSERT INTO t1 (time,id2) VALUES ('2011-07-25',1);
23
INSERT INTO t1 (time,id2) VALUES ('2011-07-25',1);
26
CREATE UNIQUE INDEX uk_time_id2 on t1(time,id2);
28
SELECT COUNT(*) FROM t1;
8
32
call mtr.add_suppression("nnoDB: Error: table `test`.`t1` .* Partition.* InnoDB internal");
10
34
--echo # Bug#55091: Server crashes on ADD PARTITION after a failed attempt
12
SET @old_innodb_file_format_check = @@global.innodb_file_format_check;
13
36
SET @old_innodb_file_format = @@global.innodb_file_format;
14
37
SET @old_innodb_file_per_table = @@global.innodb_file_per_table;
15
38
SET @old_innodb_strict_mode = @@global.innodb_strict_mode;
68
91
SET @@global.innodb_strict_mode = @old_innodb_strict_mode;
69
92
SET @@global.innodb_file_format = @old_innodb_file_format;
70
93
SET @@global.innodb_file_per_table = @old_innodb_file_per_table;
71
SET @@global.innodb_file_format_check = @old_innodb_file_format_check;
74
96
# Bug#32430 - show engine innodb status causes errors