4
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
9
--echo # Bug#12696518: MEMORY LEAKS IN HA_PARTITION (VALGRIND TESTS ON TRUNK)
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;
6
33
call mtr.add_suppression("nnoDB: Error: table `test`.`t1` .* Partition.* InnoDB internal");
8
35
--echo # Bug#55091: Server crashes on ADD PARTITION after a failed attempt
10
SET @old_innodb_file_format_max = @@global.innodb_file_format_max;
11
37
SET @old_innodb_file_format = @@global.innodb_file_format;
12
38
SET @old_innodb_file_per_table = @@global.innodb_file_per_table;
13
39
SET @old_innodb_strict_mode = @@global.innodb_strict_mode;
66
92
SET @@global.innodb_strict_mode = @old_innodb_strict_mode;
67
93
SET @@global.innodb_file_format = @old_innodb_file_format;
68
94
SET @@global.innodb_file_per_table = @old_innodb_file_per_table;
69
SET @@global.innodb_file_format_max = @old_innodb_file_format_max;
72
97
# Bug#32430 - show engine innodb status causes errors