Debian Codegraph @

mysql-test/suite/innodb/r/atomic_rename_debug_database.result

raw
1 #
2 # Test rename table with fulltext index crash/recovery rollback.
3 # The table should be renamed from one database to another so
4 # that all tablespaces of aux tables would be renamed too.
5 #
6 CREATE DATABASE db_a;
7 CREATE DATABASE db_b;
8 CREATE TABLE db_a.t1
9 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
10 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
11 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_1';
12 RENAME TABLE db_a.t1 to db_b.t2;
13 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_1';
14 DROP TABLE db_a.t1;
15 CREATE TABLE db_a.t1
16 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
17 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
18 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_2';
19 RENAME TABLE db_a.t1 to db_b.t2;
20 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_2';
21 DROP TABLE db_a.t1;
22 CREATE TABLE db_a.t1
23 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
24 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
25 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_3';
26 RENAME TABLE db_a.t1 to db_b.t2;
27 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_3';
28 DROP TABLE db_a.t1;
29 CREATE TABLE db_a.t1
30 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
31 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
32 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_4';
33 RENAME TABLE db_a.t1 to db_b.t2;
34 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_4';
35 DROP TABLE db_a.t1;
36 CREATE TABLE db_a.t1
37 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
38 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
39 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_5';
40 RENAME TABLE db_a.t1 to db_b.t2;
41 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_5';
42 DROP TABLE db_a.t1;
43 CREATE TABLE db_a.t1
44 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
45 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
46 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_6';
47 RENAME TABLE db_a.t1 to db_b.t2;
48 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_6';
49 DROP TABLE db_a.t1;
50 CREATE TABLE db_a.t1
51 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
52 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
53 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_7';
54 RENAME TABLE db_a.t1 to db_b.t2;
55 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_7';
56 DROP TABLE db_a.t1;
57 CREATE TABLE db_a.t1
58 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
59 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
60 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_8';
61 RENAME TABLE db_a.t1 to db_b.t2;
62 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_8';
63 DROP TABLE db_a.t1;
64 CREATE TABLE db_a.t1
65 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
66 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
67 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_9';
68 RENAME TABLE db_a.t1 to db_b.t2;
69 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_9';
70 DROP TABLE db_a.t1;
71 CREATE TABLE db_a.t1
72 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
73 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
74 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_10';
75 RENAME TABLE db_a.t1 to db_b.t2;
76 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_10';
77 DROP TABLE db_a.t1;
78 CREATE TABLE db_a.t1
79 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
80 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
81 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_11';
82 RENAME TABLE db_a.t1 to db_b.t2;
83 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_11';
84 DROP TABLE db_a.t1;
85 CREATE TABLE db_a.t1
86 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
87 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
88 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_12';
89 RENAME TABLE db_a.t1 to db_b.t2;
90 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_12';
91 DROP TABLE db_a.t1;
92 CREATE TABLE db_a.t1
93 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
94 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
95 SET SESSION DEBUG = '+d,ddl_log_crash_before_rename_space_log_13';
96 RENAME TABLE db_a.t1 to db_b.t2;
97 # No such crash injection, statement did not crash, cleaning up
98 SET SESSION DEBUG = '-d,ddl_log_crash_before_rename_space_log_13';
99 DROP TABLE db_b.t2;
100 CREATE TABLE db_a.t1
101 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
102 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
103 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_1';
104 RENAME TABLE db_a.t1 to db_b.t2;
105 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_1';
106 DROP TABLE db_a.t1;
107 CREATE TABLE db_a.t1
108 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
109 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
110 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_2';
111 RENAME TABLE db_a.t1 to db_b.t2;
112 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_2';
113 DROP TABLE db_a.t1;
114 CREATE TABLE db_a.t1
115 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
116 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
117 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_3';
118 RENAME TABLE db_a.t1 to db_b.t2;
119 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_3';
120 DROP TABLE db_a.t1;
121 CREATE TABLE db_a.t1
122 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
123 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
124 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_4';
125 RENAME TABLE db_a.t1 to db_b.t2;
126 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_4';
127 DROP TABLE db_a.t1;
128 CREATE TABLE db_a.t1
129 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
130 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
131 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_5';
132 RENAME TABLE db_a.t1 to db_b.t2;
133 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_5';
134 DROP TABLE db_a.t1;
135 CREATE TABLE db_a.t1
136 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
137 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
138 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_6';
139 RENAME TABLE db_a.t1 to db_b.t2;
140 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_6';
141 DROP TABLE db_a.t1;
142 CREATE TABLE db_a.t1
143 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
144 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
145 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_7';
146 RENAME TABLE db_a.t1 to db_b.t2;
147 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_7';
148 DROP TABLE db_a.t1;
149 CREATE TABLE db_a.t1
150 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
151 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
152 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_8';
153 RENAME TABLE db_a.t1 to db_b.t2;
154 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_8';
155 DROP TABLE db_a.t1;
156 CREATE TABLE db_a.t1
157 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
158 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
159 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_9';
160 RENAME TABLE db_a.t1 to db_b.t2;
161 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_9';
162 DROP TABLE db_a.t1;
163 CREATE TABLE db_a.t1
164 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
165 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
166 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_10';
167 RENAME TABLE db_a.t1 to db_b.t2;
168 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_10';
169 DROP TABLE db_a.t1;
170 CREATE TABLE db_a.t1
171 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
172 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
173 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_11';
174 RENAME TABLE db_a.t1 to db_b.t2;
175 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_11';
176 DROP TABLE db_a.t1;
177 CREATE TABLE db_a.t1
178 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
179 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
180 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_12';
181 RENAME TABLE db_a.t1 to db_b.t2;
182 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_12';
183 DROP TABLE db_a.t1;
184 CREATE TABLE db_a.t1
185 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
186 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
187 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_log_13';
188 RENAME TABLE db_a.t1 to db_b.t2;
189 # No such crash injection, statement did not crash, cleaning up
190 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_log_13';
191 DROP TABLE db_b.t2;
192 CREATE TABLE db_a.t1
193 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
194 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
195 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_1';
196 RENAME TABLE db_a.t1 to db_b.t2;
197 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_1';
198 DROP TABLE db_a.t1;
199 CREATE TABLE db_a.t1
200 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
201 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
202 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_2';
203 RENAME TABLE db_a.t1 to db_b.t2;
204 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_2';
205 DROP TABLE db_a.t1;
206 CREATE TABLE db_a.t1
207 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
208 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
209 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_3';
210 RENAME TABLE db_a.t1 to db_b.t2;
211 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_3';
212 DROP TABLE db_a.t1;
213 CREATE TABLE db_a.t1
214 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
215 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
216 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_4';
217 RENAME TABLE db_a.t1 to db_b.t2;
218 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_4';
219 DROP TABLE db_a.t1;
220 CREATE TABLE db_a.t1
221 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
222 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
223 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_5';
224 RENAME TABLE db_a.t1 to db_b.t2;
225 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_5';
226 DROP TABLE db_a.t1;
227 CREATE TABLE db_a.t1
228 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
229 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
230 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_6';
231 RENAME TABLE db_a.t1 to db_b.t2;
232 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_6';
233 DROP TABLE db_a.t1;
234 CREATE TABLE db_a.t1
235 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
236 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
237 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_7';
238 RENAME TABLE db_a.t1 to db_b.t2;
239 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_7';
240 DROP TABLE db_a.t1;
241 CREATE TABLE db_a.t1
242 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
243 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
244 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_8';
245 RENAME TABLE db_a.t1 to db_b.t2;
246 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_8';
247 DROP TABLE db_a.t1;
248 CREATE TABLE db_a.t1
249 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
250 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
251 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_9';
252 RENAME TABLE db_a.t1 to db_b.t2;
253 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_9';
254 DROP TABLE db_a.t1;
255 CREATE TABLE db_a.t1
256 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
257 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
258 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_10';
259 RENAME TABLE db_a.t1 to db_b.t2;
260 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_10';
261 DROP TABLE db_a.t1;
262 CREATE TABLE db_a.t1
263 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
264 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
265 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_11';
266 RENAME TABLE db_a.t1 to db_b.t2;
267 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_11';
268 DROP TABLE db_a.t1;
269 CREATE TABLE db_a.t1
270 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
271 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
272 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_12';
273 RENAME TABLE db_a.t1 to db_b.t2;
274 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_12';
275 DROP TABLE db_a.t1;
276 CREATE TABLE db_a.t1
277 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
278 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
279 SET SESSION DEBUG = '+d,ddl_log_crash_after_rename_space_delete_13';
280 RENAME TABLE db_a.t1 to db_b.t2;
281 # No such crash injection, statement did not crash, cleaning up
282 SET SESSION DEBUG = '-d,ddl_log_crash_after_rename_space_delete_13';
283 DROP TABLE db_b.t2;
284 CREATE TABLE db_a.t1
285 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
286 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
287 SET SESSION DEBUG = '+d,ddl_log_before_post_ddl';
288 RENAME TABLE db_a.t1 to db_b.t2;
289 SET SESSION DEBUG = '-d,ddl_log_before_post_ddl';
290 DROP TABLE db_b.t2;
291 CREATE TABLE db_a.t1
292 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, FULLTEXT KEY b_k(b));
293 SET GLOBAL innodb_ddl_log_crash_reset_debug = 1;
294 SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_1';
295 RENAME TABLE db_a.t1 to db_b.t2;
296 # No such crash injection, statement did not crash, cleaning up
297 SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_1';
298 DROP TABLE db_b.t2;
299 SET GLOBAL innodb_ddl_log_crash_reset_debug = 0;
300 DROP DATABASE db_a;
301 DROP DATABASE db_b;