2
# Bug#11766879/Bug#60106: DIFF BETWEEN # OF INDEXES IN MYSQL VS INNODB,
3
# PARTITONING, ON INDEX CREATE
4
# Bug#12696518: MEMORY LEAKS IN HA_PARTITION (VALGRIND TESTS ON TRUNK)
7
id bigint NOT NULL AUTO_INCREMENT,
11
) ENGINE=InnoDB DEFAULT CHARSET=utf8
12
/*!50100 PARTITION BY RANGE(TO_DAYS(time))
13
(PARTITION p10 VALUES LESS THAN (734708) ENGINE = InnoDB,
14
PARTITION p20 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */;
15
INSERT INTO t1 (time,id2) VALUES ('2011-07-24',1);
16
INSERT INTO t1 (time,id2) VALUES ('2011-07-25',1);
17
INSERT INTO t1 (time,id2) VALUES ('2011-07-25',1);
18
CREATE UNIQUE INDEX uk_time_id2 on t1(time,id2);
19
ERROR 23000: Duplicate entry '2011-07-25-1' for key 'uk_time_id2'
20
SELECT COUNT(*) FROM t1;
25
t1 CREATE TABLE `t1` (
26
`id` bigint(20) NOT NULL AUTO_INCREMENT,
27
`time` date NOT NULL DEFAULT '0000-00-00',
28
`id2` bigint(20) NOT NULL,
29
PRIMARY KEY (`id`,`time`)
30
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8
31
/*!50100 PARTITION BY RANGE (TO_DAYS(time))
32
(PARTITION p10 VALUES LESS THAN (734708) ENGINE = InnoDB,
33
PARTITION p20 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
1
35
call mtr.add_suppression("nnoDB: Error: table `test`.`t1` .* Partition.* InnoDB internal");
3
37
# Bug#55091: Server crashes on ADD PARTITION after a failed attempt
5
SET @old_innodb_file_format_max = @@global.innodb_file_format_max;
6
39
SET @old_innodb_file_format = @@global.innodb_file_format;
7
40
SET @old_innodb_file_per_table = @@global.innodb_file_per_table;
8
41
SET @old_innodb_strict_mode = @@global.innodb_strict_mode;
70
103
SET @@global.innodb_strict_mode = @old_innodb_strict_mode;
71
104
SET @@global.innodb_file_format = @old_innodb_file_format;
72
105
SET @@global.innodb_file_per_table = @old_innodb_file_per_table;
73
SET @@global.innodb_file_format_max = @old_innodb_file_format_max;
75
107
CREATE TABLE `t``\""e` (a INT, PRIMARY KEY (a))