Debian Codegraph @

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

raw
1 CREATE PROCEDURE populate_t1()
2 BEGIN
3 DECLARE i int DEFAULT 1;
4 START TRANSACTION;
5 WHILE (i <= 10000) DO
6 INSERT INTO t1 VALUES (i, i, CONCAT('a', i));
7 SET i = i + 1;
8 END WHILE;
9 COMMIT;
10 END|
11 CREATE TABLE t1(
12 class INT,
13 id INT,
14 title VARCHAR(100)
15 ) ENGINE=InnoDB ROW_FORMAT=REDUNDANT;
16 SELECT COUNT(*) FROM t1;
17 COUNT(*)
18 10000
19 CREATE INDEX idx_title ON t1(title);
20 affected rows: 0
21 info: Records: 0 Duplicates: 0 Warnings: 0
22 RENAME TABLE t1 TO t0;
23 # Test Blob
24 CREATE TABLE t1(
25 a INT PRIMARY KEY,
26 b TEXT,
27 c TEXT) ENGINE=InnoDB ROW_FORMAT=REDUNDANT;
28 INSERT INTO t1 VALUES
29 (1, REPEAT('a',10000), 'a'),
30 (2, REPEAT('b',20000), 'b'),
31 (3, REPEAT('c',40000), 'c'),
32 (4, REPEAT('d',60000), 'd');
33 SELECT CHAR_LENGTH(b) FROM t1;
34 CHAR_LENGTH(b)
35 10000
36 20000
37 40000
38 60000
39 ALTER TABLE t1 DROP COLUMN c, FORCE;
40 affected rows: 0
41 info: Records: 0 Duplicates: 0 Warnings: 0
42 CHECK TABLE t0,t1;
43 Table Op Msg_type Msg_text
44 test.t0 check status OK
45 test.t1 check status OK
46 SELECT CHAR_LENGTH(b) FROM t1;
47 CHAR_LENGTH(b)
48 10000
49 20000
50 40000
51 60000
52 DROP TABLE t1;
53 RENAME TABLE t0 to t1;
54 CHECK TABLE t1;
55 Table Op Msg_type Msg_text
56 test.t1 check status OK
57 SELECT * FROM t1 WHERE title = 'a10';
58 class id title
59 10 10 a10
60 SELECT * FROM t1 WHERE title = 'a5000';
61 class id title
62 5000 5000 a5000
63 SELECT * FROM t1 WHERE title = 'a10000';
64 class id title
65 10000 10000 a10000
66 SELECT * FROM t1 WHERE title = 'a10010';
67 class id title
68 DROP TABLE t1;
69 CREATE TABLE t1(
70 class INT,
71 id INT,
72 title VARCHAR(100)
73 ) ENGINE=InnoDB ROW_FORMAT=REDUNDANT;
74 connect hang,localhost,root;
75 SET DEBUG_SYNC='alter_table_inplace_trans_commit SIGNAL hung WAIT_FOR ever';
76 CREATE INDEX idx_title ON t1(title);
77 connection default;
78 SET DEBUG_SYNC='now WAIT_FOR hung';
79 disconnect hang;
80 SELECT COUNT(*) FROM t1;
81 COUNT(*)
82 10000
83 CHECK TABLE t1;
84 Table Op Msg_type Msg_text
85 test.t1 check status OK
86 EXPLAIN SELECT * FROM t1 WHERE title = 'a10';
87 id select_type table type possible_keys key key_len ref rows Extra
88 1 SIMPLE t1 ref idx_title idx_title 403 const 1 Using index condition
89 SELECT * FROM t1 WHERE title = 'a10';
90 class id title
91 10 10 a10
92 SELECT * FROM t1 WHERE title = 'a5000';
93 class id title
94 5000 5000 a5000
95 SELECT * FROM t1 WHERE title = 'a10000';
96 class id title
97 10000 10000 a10000
98 SELECT * FROM t1 WHERE title = 'a10010';
99 class id title
100 DROP TABLE t1;
101 # Test Blob
102 CREATE TABLE t1(
103 a INT PRIMARY KEY,
104 b TEXT,
105 c TEXT) ENGINE=InnoDB ROW_FORMAT=REDUNDANT;
106 INSERT INTO t1 VALUES
107 (1, REPEAT('a',10000), 'a'),
108 (2, REPEAT('b',20000), 'b'),
109 (3, REPEAT('c',40000), 'c'),
110 (4, REPEAT('d',60000), 'd');
111 SELECT CHAR_LENGTH(b) FROM t1;
112 CHAR_LENGTH(b)
113 10000
114 20000
115 40000
116 60000
117 connect hang,localhost,root;
118 SET DEBUG_SYNC='alter_table_inplace_trans_commit SIGNAL hung WAIT_FOR ever';
119 ALTER TABLE t1 DROP COLUMN c, FORCE;
120 connection default;
121 SET DEBUG_SYNC='now WAIT_FOR hung';
122 disconnect hang;
123 CHECK TABLE t1;
124 Table Op Msg_type Msg_text
125 test.t1 check status OK
126 SELECT CHAR_LENGTH(b) FROM t1;
127 CHAR_LENGTH(b)
128 10000
129 20000
130 40000
131 60000
132 DROP TABLE t1;
133 DROP PROCEDURE populate_t1;
134 CREATE PROCEDURE populate_t1()
135 BEGIN
136 DECLARE i int DEFAULT 1;
137 START TRANSACTION;
138 WHILE (i <= 10000) DO
139 INSERT INTO t1 VALUES (i, i, CONCAT('a', i));
140 SET i = i + 1;
141 END WHILE;
142 COMMIT;
143 END|
144 CREATE TABLE t1(
145 class INT,
146 id INT,
147 title VARCHAR(100)
148 ) ENGINE=InnoDB ROW_FORMAT=COMPACT;
149 SELECT COUNT(*) FROM t1;
150 COUNT(*)
151 10000
152 CREATE INDEX idx_title ON t1(title);
153 affected rows: 0
154 info: Records: 0 Duplicates: 0 Warnings: 0
155 RENAME TABLE t1 TO t0;
156 # Test Blob
157 CREATE TABLE t1(
158 a INT PRIMARY KEY,
159 b TEXT,
160 c TEXT) ENGINE=InnoDB ROW_FORMAT=COMPACT;
161 INSERT INTO t1 VALUES
162 (1, REPEAT('a',10000), 'a'),
163 (2, REPEAT('b',20000), 'b'),
164 (3, REPEAT('c',40000), 'c'),
165 (4, REPEAT('d',60000), 'd');
166 SELECT CHAR_LENGTH(b) FROM t1;
167 CHAR_LENGTH(b)
168 10000
169 20000
170 40000
171 60000
172 ALTER TABLE t1 DROP COLUMN c, FORCE;
173 affected rows: 0
174 info: Records: 0 Duplicates: 0 Warnings: 0
175 CHECK TABLE t0,t1;
176 Table Op Msg_type Msg_text
177 test.t0 check status OK
178 test.t1 check status OK
179 SELECT CHAR_LENGTH(b) FROM t1;
180 CHAR_LENGTH(b)
181 10000
182 20000
183 40000
184 60000
185 DROP TABLE t1;
186 RENAME TABLE t0 to t1;
187 CHECK TABLE t1;
188 Table Op Msg_type Msg_text
189 test.t1 check status OK
190 SELECT * FROM t1 WHERE title = 'a10';
191 class id title
192 10 10 a10
193 SELECT * FROM t1 WHERE title = 'a5000';
194 class id title
195 5000 5000 a5000
196 SELECT * FROM t1 WHERE title = 'a10000';
197 class id title
198 10000 10000 a10000
199 SELECT * FROM t1 WHERE title = 'a10010';
200 class id title
201 DROP TABLE t1;
202 CREATE TABLE t1(
203 class INT,
204 id INT,
205 title VARCHAR(100)
206 ) ENGINE=InnoDB ROW_FORMAT=COMPACT;
207 connect hang,localhost,root;
208 SET DEBUG_SYNC='alter_table_inplace_trans_commit SIGNAL hung WAIT_FOR ever';
209 CREATE INDEX idx_title ON t1(title);
210 connection default;
211 SET DEBUG_SYNC='now WAIT_FOR hung';
212 disconnect hang;
213 SELECT COUNT(*) FROM t1;
214 COUNT(*)
215 10000
216 CHECK TABLE t1;
217 Table Op Msg_type Msg_text
218 test.t1 check status OK
219 EXPLAIN SELECT * FROM t1 WHERE title = 'a10';
220 id select_type table type possible_keys key key_len ref rows Extra
221 1 SIMPLE t1 ref idx_title idx_title 403 const 1 Using index condition
222 SELECT * FROM t1 WHERE title = 'a10';
223 class id title
224 10 10 a10
225 SELECT * FROM t1 WHERE title = 'a5000';
226 class id title
227 5000 5000 a5000
228 SELECT * FROM t1 WHERE title = 'a10000';
229 class id title
230 10000 10000 a10000
231 SELECT * FROM t1 WHERE title = 'a10010';
232 class id title
233 DROP TABLE t1;
234 # Test Blob
235 CREATE TABLE t1(
236 a INT PRIMARY KEY,
237 b TEXT,
238 c TEXT) ENGINE=InnoDB ROW_FORMAT=COMPACT;
239 INSERT INTO t1 VALUES
240 (1, REPEAT('a',10000), 'a'),
241 (2, REPEAT('b',20000), 'b'),
242 (3, REPEAT('c',40000), 'c'),
243 (4, REPEAT('d',60000), 'd');
244 SELECT CHAR_LENGTH(b) FROM t1;
245 CHAR_LENGTH(b)
246 10000
247 20000
248 40000
249 60000
250 connect hang,localhost,root;
251 SET DEBUG_SYNC='alter_table_inplace_trans_commit SIGNAL hung WAIT_FOR ever';
252 ALTER TABLE t1 DROP COLUMN c, FORCE;
253 connection default;
254 SET DEBUG_SYNC='now WAIT_FOR hung';
255 disconnect hang;
256 CHECK TABLE t1;
257 Table Op Msg_type Msg_text
258 test.t1 check status OK
259 SELECT CHAR_LENGTH(b) FROM t1;
260 CHAR_LENGTH(b)
261 10000
262 20000
263 40000
264 60000
265 DROP TABLE t1;
266 DROP PROCEDURE populate_t1;
267 CREATE PROCEDURE populate_t1()
268 BEGIN
269 DECLARE i int DEFAULT 1;
270 START TRANSACTION;
271 WHILE (i <= 10000) DO
272 INSERT INTO t1 VALUES (i, i, CONCAT('a', i));
273 SET i = i + 1;
274 END WHILE;
275 COMMIT;
276 END|
277 CREATE TABLE t1(
278 class INT,
279 id INT,
280 title VARCHAR(100)
281 ) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
282 SELECT COUNT(*) FROM t1;
283 COUNT(*)
284 10000
285 CREATE INDEX idx_title ON t1(title);
286 affected rows: 0
287 info: Records: 0 Duplicates: 0 Warnings: 0
288 RENAME TABLE t1 TO t0;
289 # Test Blob
290 CREATE TABLE t1(
291 a INT PRIMARY KEY,
292 b TEXT,
293 c TEXT) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
294 INSERT INTO t1 VALUES
295 (1, REPEAT('a',10000), 'a'),
296 (2, REPEAT('b',20000), 'b'),
297 (3, REPEAT('c',40000), 'c'),
298 (4, REPEAT('d',60000), 'd');
299 SELECT CHAR_LENGTH(b) FROM t1;
300 CHAR_LENGTH(b)
301 10000
302 20000
303 40000
304 60000
305 ALTER TABLE t1 DROP COLUMN c, FORCE;
306 affected rows: 0
307 info: Records: 0 Duplicates: 0 Warnings: 0
308 CHECK TABLE t0,t1;
309 Table Op Msg_type Msg_text
310 test.t0 check status OK
311 test.t1 check status OK
312 SELECT CHAR_LENGTH(b) FROM t1;
313 CHAR_LENGTH(b)
314 10000
315 20000
316 40000
317 60000
318 DROP TABLE t1;
319 RENAME TABLE t0 to t1;
320 CHECK TABLE t1;
321 Table Op Msg_type Msg_text
322 test.t1 check status OK
323 SELECT * FROM t1 WHERE title = 'a10';
324 class id title
325 10 10 a10
326 SELECT * FROM t1 WHERE title = 'a5000';
327 class id title
328 5000 5000 a5000
329 SELECT * FROM t1 WHERE title = 'a10000';
330 class id title
331 10000 10000 a10000
332 SELECT * FROM t1 WHERE title = 'a10010';
333 class id title
334 DROP TABLE t1;
335 CREATE TABLE t1(
336 class INT,
337 id INT,
338 title VARCHAR(100)
339 ) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
340 connect hang,localhost,root;
341 SET DEBUG_SYNC='alter_table_inplace_trans_commit SIGNAL hung WAIT_FOR ever';
342 CREATE INDEX idx_title ON t1(title);
343 connection default;
344 SET DEBUG_SYNC='now WAIT_FOR hung';
345 disconnect hang;
346 SELECT COUNT(*) FROM t1;
347 COUNT(*)
348 10000
349 CHECK TABLE t1;
350 Table Op Msg_type Msg_text
351 test.t1 check status OK
352 EXPLAIN SELECT * FROM t1 WHERE title = 'a10';
353 id select_type table type possible_keys key key_len ref rows Extra
354 1 SIMPLE t1 ref idx_title idx_title 403 const 1 Using index condition
355 SELECT * FROM t1 WHERE title = 'a10';
356 class id title
357 10 10 a10
358 SELECT * FROM t1 WHERE title = 'a5000';
359 class id title
360 5000 5000 a5000
361 SELECT * FROM t1 WHERE title = 'a10000';
362 class id title
363 10000 10000 a10000
364 SELECT * FROM t1 WHERE title = 'a10010';
365 class id title
366 DROP TABLE t1;
367 # Test Blob
368 CREATE TABLE t1(
369 a INT PRIMARY KEY,
370 b TEXT,
371 c TEXT) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
372 INSERT INTO t1 VALUES
373 (1, REPEAT('a',10000), 'a'),
374 (2, REPEAT('b',20000), 'b'),
375 (3, REPEAT('c',40000), 'c'),
376 (4, REPEAT('d',60000), 'd');
377 SELECT CHAR_LENGTH(b) FROM t1;
378 CHAR_LENGTH(b)
379 10000
380 20000
381 40000
382 60000
383 connect hang,localhost,root;
384 SET DEBUG_SYNC='alter_table_inplace_trans_commit SIGNAL hung WAIT_FOR ever';
385 ALTER TABLE t1 DROP COLUMN c, FORCE;
386 connection default;
387 SET DEBUG_SYNC='now WAIT_FOR hung';
388 disconnect hang;
389 CHECK TABLE t1;
390 Table Op Msg_type Msg_text
391 test.t1 check status OK
392 SELECT CHAR_LENGTH(b) FROM t1;
393 CHAR_LENGTH(b)
394 10000
395 20000
396 40000
397 60000
398 DROP TABLE t1;
399 DROP PROCEDURE populate_t1;
400 CREATE PROCEDURE populate_t1()
401 BEGIN
402 DECLARE i int DEFAULT 1;
403 START TRANSACTION;
404 WHILE (i <= 10000) DO
405 INSERT INTO t1 VALUES (i, i, CONCAT('a', i));
406 SET i = i + 1;
407 END WHILE;
408 COMMIT;
409 END|
410 CREATE TABLE t1(
411 class INT,
412 id INT,
413 title VARCHAR(100)
414 ) ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
415 SELECT COUNT(*) FROM t1;
416 COUNT(*)
417 10000
418 CREATE INDEX idx_title ON t1(title);
419 affected rows: 0
420 info: Records: 0 Duplicates: 0 Warnings: 0
421 RENAME TABLE t1 TO t0;
422 # Test Blob
423 CREATE TABLE t1(
424 a INT PRIMARY KEY,
425 b TEXT,
426 c TEXT) ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
427 INSERT INTO t1 VALUES
428 (1, REPEAT('a',10000), 'a'),
429 (2, REPEAT('b',20000), 'b'),
430 (3, REPEAT('c',40000), 'c'),
431 (4, REPEAT('d',60000), 'd');
432 SELECT CHAR_LENGTH(b) FROM t1;
433 CHAR_LENGTH(b)
434 10000
435 20000
436 40000
437 60000
438 ALTER TABLE t1 DROP COLUMN c, FORCE;
439 affected rows: 0
440 info: Records: 0 Duplicates: 0 Warnings: 0
441 CHECK TABLE t0,t1;
442 Table Op Msg_type Msg_text
443 test.t0 check status OK
444 test.t1 check status OK
445 SELECT CHAR_LENGTH(b) FROM t1;
446 CHAR_LENGTH(b)
447 10000
448 20000
449 40000
450 60000
451 DROP TABLE t1;
452 RENAME TABLE t0 to t1;
453 CHECK TABLE t1;
454 Table Op Msg_type Msg_text
455 test.t1 check status OK
456 SELECT * FROM t1 WHERE title = 'a10';
457 class id title
458 10 10 a10
459 SELECT * FROM t1 WHERE title = 'a5000';
460 class id title
461 5000 5000 a5000
462 SELECT * FROM t1 WHERE title = 'a10000';
463 class id title
464 10000 10000 a10000
465 SELECT * FROM t1 WHERE title = 'a10010';
466 class id title
467 DROP TABLE t1;
468 CREATE TABLE t1(
469 class INT,
470 id INT,
471 title VARCHAR(100)
472 ) ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
473 connect hang,localhost,root;
474 SET DEBUG_SYNC='alter_table_inplace_trans_commit SIGNAL hung WAIT_FOR ever';
475 CREATE INDEX idx_title ON t1(title);
476 connection default;
477 SET DEBUG_SYNC='now WAIT_FOR hung';
478 disconnect hang;
479 SELECT COUNT(*) FROM t1;
480 COUNT(*)
481 10000
482 CHECK TABLE t1;
483 Table Op Msg_type Msg_text
484 test.t1 check status OK
485 EXPLAIN SELECT * FROM t1 WHERE title = 'a10';
486 id select_type table type possible_keys key key_len ref rows Extra
487 1 SIMPLE t1 ref idx_title idx_title 403 const 1 Using index condition
488 SELECT * FROM t1 WHERE title = 'a10';
489 class id title
490 10 10 a10
491 SELECT * FROM t1 WHERE title = 'a5000';
492 class id title
493 5000 5000 a5000
494 SELECT * FROM t1 WHERE title = 'a10000';
495 class id title
496 10000 10000 a10000
497 SELECT * FROM t1 WHERE title = 'a10010';
498 class id title
499 DROP TABLE t1;
500 # Test Blob
501 CREATE TABLE t1(
502 a INT PRIMARY KEY,
503 b TEXT,
504 c TEXT) ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
505 INSERT INTO t1 VALUES
506 (1, REPEAT('a',10000), 'a'),
507 (2, REPEAT('b',20000), 'b'),
508 (3, REPEAT('c',40000), 'c'),
509 (4, REPEAT('d',60000), 'd');
510 SELECT CHAR_LENGTH(b) FROM t1;
511 CHAR_LENGTH(b)
512 10000
513 20000
514 40000
515 60000
516 connect hang,localhost,root;
517 SET DEBUG_SYNC='alter_table_inplace_trans_commit SIGNAL hung WAIT_FOR ever';
518 ALTER TABLE t1 DROP COLUMN c, FORCE;
519 connection default;
520 SET DEBUG_SYNC='now WAIT_FOR hung';
521 disconnect hang;
522 CHECK TABLE t1;
523 Table Op Msg_type Msg_text
524 test.t1 check status OK
525 SELECT CHAR_LENGTH(b) FROM t1;
526 CHAR_LENGTH(b)
527 10000
528 20000
529 40000
530 60000
531 DROP TABLE t1;
532 DROP PROCEDURE populate_t1;