| 1 |
--source include/have_innodb.inc |
| 2 |
--source include/have_innodb_16k.inc |
| 3 |
--source include/have_sequence.inc |
| 4 |
--source include/test_db_charset_latin1.inc |
| 5 |
|
| 6 |
SET @save_stats_persistent = @@GLOBAL.innodb_stats_persistent; |
| 7 |
SET GLOBAL innodb_stats_persistent = 0; |
| 8 |
|
| 9 |
--echo # Bug #12429576 - Test an assertion failure on purge. |
| 10 |
CREATE TABLE t1_purge ( |
| 11 |
A int, |
| 12 |
B blob, C blob, D blob, E blob, |
| 13 |
F blob, G blob, H blob, |
| 14 |
PRIMARY KEY (B(767), C(767), D(767), E(767), A), |
| 15 |
INDEX (A) |
| 16 |
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; |
| 17 |
|
| 18 |
INSERT INTO t1_purge VALUES (1, |
| 19 |
REPEAT('b', 766), REPEAT('c', 766), REPEAT('d', 766), REPEAT('e', 766), |
| 20 |
REPEAT('f', 766), REPEAT('g', 766), REPEAT('h', 766)); |
| 21 |
|
| 22 |
CREATE TABLE t2_purge ( |
| 23 |
A int PRIMARY KEY, |
| 24 |
B blob, C blob, D blob, E blob, |
| 25 |
F blob, G blob, H blob, I blob, |
| 26 |
J blob, K blob, L blob, |
| 27 |
INDEX (B(767))) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; |
| 28 |
|
| 29 |
INSERT INTO t2_purge VALUES (1, |
| 30 |
REPEAT('b', 766), REPEAT('c', 766), REPEAT('d', 766), REPEAT('e', 766), |
| 31 |
REPEAT('f', 766), REPEAT('g', 766), REPEAT('h', 766), REPEAT('i', 766), |
| 32 |
REPEAT('j', 766), REPEAT('k', 766), REPEAT('l', 766)); |
| 33 |
|
| 34 |
CREATE TABLE t3_purge ( |
| 35 |
A int, |
| 36 |
B varchar(800), C varchar(800), D varchar(800), E varchar(800), |
| 37 |
F varchar(800), G varchar(800), H varchar(800), |
| 38 |
PRIMARY KEY (B(767), C(767), D(767), E(767), A), |
| 39 |
INDEX (A) |
| 40 |
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; |
| 41 |
|
| 42 |
INSERT INTO t3_purge SELECT * FROM t1_purge; |
| 43 |
|
| 44 |
CREATE TABLE t4_purge ( |
| 45 |
A int PRIMARY KEY, |
| 46 |
B varchar(800), C varchar(800), D varchar(800), E varchar(800), |
| 47 |
F varchar(800), G varchar(800), H varchar(800), I varchar(800), |
| 48 |
J varchar(800), K varchar(800), L varchar(800), |
| 49 |
INDEX (B(767))) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; |
| 50 |
|
| 51 |
INSERT INTO t4_purge SELECT * FROM t2_purge; |
| 52 |
|
| 53 |
# This would trigger the failure (Bug #12429576) |
| 54 |
# if purge gets a chance to run before DROP TABLE t1_purge, .... |
| 55 |
DELETE FROM t1_purge; |
| 56 |
DELETE FROM t2_purge; |
| 57 |
DELETE FROM t3_purge; |
| 58 |
DELETE FROM t4_purge; |
| 59 |
# We need to activate the purge thread before DROP TABLE. |
| 60 |
|
| 61 |
# Bug#12637786 - Assertion hit; ut_ad(dict_index_is_clust(index)); |
| 62 |
# A secondary index tuple is found to be too long to fit into a page. |
| 63 |
# This test is not in innodb_8k or innodb_4k since the bug is not about |
| 64 |
# page size. It just tests the condition that caused the assertion. |
| 65 |
SET @r=REPEAT('a',500); |
| 66 |
CREATE TABLE t12637786(a int, |
| 67 |
v1 varchar(500), v2 varchar(500), v3 varchar(500), |
| 68 |
v4 varchar(500), v5 varchar(500), v6 varchar(500), |
| 69 |
v7 varchar(500), v8 varchar(500), v9 varchar(500), |
| 70 |
v10 varchar(500), v11 varchar(500), v12 varchar(500), |
| 71 |
v13 varchar(500), v14 varchar(500), v15 varchar(500), |
| 72 |
v16 varchar(500), v17 varchar(500), v18 varchar(500) |
| 73 |
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; |
| 74 |
CREATE INDEX idx1 ON t12637786(a,v1); |
| 75 |
INSERT INTO t12637786 VALUES(9,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r,@r); |
| 76 |
UPDATE t12637786 SET a=1000; |
| 77 |
DELETE FROM t12637786; |
| 78 |
# We need to activate the purge thread before DROP TABLE |
| 79 |
# to make sure it is able to clean up the old versions. |
| 80 |
|
| 81 |
--echo # Bug#12963823 - Test that the purge thread does not crash when |
| 82 |
# the number of indexes has changed since the UNDO record was logged. |
| 83 |
# This test is not in innodb_8k or innodb_4k since the bug is not about |
| 84 |
# page size. It just tests the condition that caused the crash. |
| 85 |
CREATE TABLE t12963823(a blob,b blob,c blob,d blob,e blob,f blob,g blob,h blob, |
| 86 |
i blob,j blob,k blob,l blob,m blob,n blob,o blob,p blob) |
| 87 |
ENGINE=innodb ROW_FORMAT=dynamic; |
| 88 |
SET @r = REPEAT('a', 767); |
| 89 |
INSERT INTO t12963823 VALUES (@r,@r,@r,@r, @r,@r,@r,@r, @r,@r,@r,@r, @r,@r,@r,@r); |
| 90 |
CREATE INDEX ndx_a ON t12963823 (a(500)); |
| 91 |
CREATE INDEX ndx_b ON t12963823 (b(500)); |
| 92 |
CREATE INDEX ndx_c ON t12963823 (c(500)); |
| 93 |
CREATE INDEX ndx_d ON t12963823 (d(500)); |
| 94 |
CREATE INDEX ndx_e ON t12963823 (e(500)); |
| 95 |
CREATE INDEX ndx_f ON t12963823 (f(500)); |
| 96 |
CREATE INDEX ndx_k ON t12963823 (k(500)); |
| 97 |
CREATE INDEX ndx_l ON t12963823 (l(500)); |
| 98 |
|
| 99 |
SET @r = REPEAT('b', 500); |
| 100 |
UPDATE t12963823 set a=@r,b=@r,c=@r,d=@r; |
| 101 |
UPDATE t12963823 set e=@r,f=@r,g=@r,h=@r; |
| 102 |
UPDATE t12963823 set i=@r,j=@r,k=@r,l=@r; |
| 103 |
UPDATE t12963823 set m=@r,n=@r,o=@r,p=@r; |
| 104 |
ALTER TABLE t12963823 DROP INDEX ndx_a; |
| 105 |
ALTER TABLE t12963823 DROP INDEX ndx_b; |
| 106 |
CREATE INDEX ndx_g ON t12963823 (g(500)); |
| 107 |
CREATE INDEX ndx_h ON t12963823 (h(500)); |
| 108 |
CREATE INDEX ndx_i ON t12963823 (i(500)); |
| 109 |
CREATE INDEX ndx_j ON t12963823 (j(500)); |
| 110 |
CREATE INDEX ndx_m ON t12963823 (m(500)); |
| 111 |
CREATE INDEX ndx_n ON t12963823 (n(500)); |
| 112 |
CREATE INDEX ndx_o ON t12963823 (o(500)); |
| 113 |
CREATE INDEX ndx_p ON t12963823 (p(500)); |
| 114 |
SHOW CREATE TABLE t12963823; |
| 115 |
|
| 116 |
DELIMITER $$; |
| 117 |
--error ER_TOO_MANY_KEY_PARTS |
| 118 |
BEGIN NOT ATOMIC |
| 119 |
DECLARE c TEXT DEFAULT(SELECT CONCAT('CREATE TABLE t1(c', |
| 120 |
GROUP_CONCAT(seq SEPARATOR |
| 121 |
' INT DEFAULT 0, c'), |
| 122 |
' INT DEFAULT 0, PRIMARY KEY(c', |
| 123 |
GROUP_CONCAT(seq SEPARATOR ', c'), |
| 124 |
')) ENGINE=InnoDB;') FROM seq_1_to_33); |
| 125 |
EXECUTE IMMEDIATE c; |
| 126 |
END; |
| 127 |
$$ |
| 128 |
BEGIN NOT ATOMIC |
| 129 |
DECLARE c TEXT DEFAULT(SELECT CONCAT('CREATE TABLE t1(c', |
| 130 |
GROUP_CONCAT(seq SEPARATOR |
| 131 |
' INT DEFAULT 0, c'), |
| 132 |
' INT DEFAULT 0, PRIMARY KEY(c', |
| 133 |
GROUP_CONCAT(seq SEPARATOR ', c'), |
| 134 |
')) ENGINE=InnoDB;') FROM seq_1_to_32); |
| 135 |
EXECUTE IMMEDIATE c; |
| 136 |
END; |
| 137 |
$$ |
| 138 |
DELIMITER ;$$ |
| 139 |
INSERT INTO t1() VALUES(); |
| 140 |
|
| 141 |
# We need to activate the purge thread before DROP TABLE. |
| 142 |
-- source include/wait_all_purged.inc |
| 143 |
|
| 144 |
SET GLOBAL innodb_stats_persistent = @save_stats_persistent; |
| 145 |
DROP TABLE t1; |
| 146 |
DROP TABLE t1_purge, t2_purge, t3_purge, t4_purge, t12637786, t12963823; |
| 147 |
|
| 148 |
--source include/test_db_charset_restore.inc |