Debian Codegraph @

mysql-test/suite/innodb/t/purge.test

raw
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