Debian Codegraph @

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

raw
1 ##############################################
2 # Test instant ADD COLUMN for REDUNDANT format
3 ##############################################
4 #
5 # Scenario 1:
6 # Create normal table and partitioned table, DML on them, restart
7 #
8 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b INT) ROW_FORMAT=REDUNDANT;
9 INSERT INTO t1 VALUES(0, 1), (0, 2), (0, 3), (0, 4), (0, 5);
10 ALTER TABLE t1 ADD COLUMN c1 INT DEFAULT 10;
11 Table id did not change
12 count(*) = 1
13 1
14 CHECK TABLE t1;
15 Table Op Msg_type Msg_text
16 test.t1 check status OK
17 INSERT INTO t1 VALUES(0, 6, 20), (0, 7, 20);
18 # restart
19 CHECK TABLE t1;
20 Table Op Msg_type Msg_text
21 test.t1 check status OK
22 SELECT * FROM t1;
23 a b c1
24 1 1 10
25 2 2 10
26 3 3 10
27 4 4 10
28 5 5 10
29 6 6 20
30 7 7 20
31 UPDATE t1 SET b = 10;
32 # restart
33 CHECK TABLE t1;
34 Table Op Msg_type Msg_text
35 test.t1 check status OK
36 SELECT * FROM t1;
37 a b c1
38 1 10 10
39 2 10 10
40 3 10 10
41 4 10 10
42 5 10 10
43 6 10 20
44 7 10 20
45 UPDATE t1 SET c1 = 15;
46 # restart
47 CHECK TABLE t1;
48 Table Op Msg_type Msg_text
49 test.t1 check status OK
50 DELETE FROM t1 WHERE a > 0;
51 # restart
52 CHECK TABLE t1;
53 Table Op Msg_type Msg_text
54 test.t1 check status OK
55 SELECT * FROM t1;
56 a b c1
57 INSERT INTO t1(a, b) VALUES(0, 1), (0, 2), (0, 3), (0, 4), (0, 5);
58 ALTER TABLE t1 ADD COLUMN c2 VARCHAR(100) DEFAULT 'Hello World!';
59 Table id did not change
60 count(*) = 2
61 1
62 CHECK TABLE t1;
63 Table Op Msg_type Msg_text
64 test.t1 check status OK
65 UPDATE t1 SET c2 = 'Hello MySQL!';
66 # restart
67 CHECK TABLE t1;
68 Table Op Msg_type Msg_text
69 test.t1 check status OK
70 SELECT * FROM t1;
71 a b c1 c2
72 8 1 10 Hello MySQL!
73 9 2 10 Hello MySQL!
74 10 3 10 Hello MySQL!
75 11 4 10 Hello MySQL!
76 12 5 10 Hello MySQL!
77 DROP TABLE t1;
78 #
79 # Scenario 2:
80 # Create normal table and partitioned table, DML on them, crash
81 #
82 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b INT) ROW_FORMAT=REDUNDANT;
83 INSERT INTO t1 VALUES(0, 1), (0, 2), (0, 3), (0, 4), (0, 5);
84 ALTER TABLE t1 ADD COLUMN c1 INT DEFAULT 10;
85 Table id did not change
86 count(*) = 1
87 1
88 CHECK TABLE t1;
89 Table Op Msg_type Msg_text
90 test.t1 check status OK
91 START TRANSACTION;
92 INSERT INTO t1 VALUES(0, 6, 20), (0, 7, 20);
93 SET SESSION DEBUG="+d,crash_commit_after";
94 CR_SERVER_LOST
95 COMMIT;
96 ERROR HY000: Lost connection to MySQL server during query
97 # restart
98 CHECK TABLE t1;
99 Table Op Msg_type Msg_text
100 test.t1 check status OK
101 SELECT * FROM t1;
102 a b c1
103 1 1 10
104 2 2 10
105 3 3 10
106 4 4 10
107 5 5 10
108 6 6 20
109 7 7 20
110 INSERT INTO t1 VALUES(0, 6, 20), (0, 7, 20);
111 START TRANSACTION;
112 UPDATE t1 SET b = 10;
113 SET SESSION DEBUG="+d,crash_commit_after";
114 CR_SERVER_LOST
115 COMMIT;
116 ERROR HY000: Lost connection to MySQL server during query
117 # restart
118 CHECK TABLE t1;
119 Table Op Msg_type Msg_text
120 test.t1 check status OK
121 SELECT * FROM t1;
122 a b c1
123 1 10 10
124 2 10 10
125 3 10 10
126 4 10 10
127 5 10 10
128 6 10 20
129 7 10 20
130 8 10 20
131 9 10 20
132 UPDATE t1 SET b = 10;
133 START TRANSACTION;
134 UPDATE t1 SET c1 = 11;
135 SET SESSION DEBUG="+d,crash_commit_after";
136 CR_SERVER_LOST
137 COMMIT;
138 ERROR HY000: Lost connection to MySQL server during query
139 # restart
140 CHECK TABLE t1;
141 Table Op Msg_type Msg_text
142 test.t1 check status OK
143 SELECT * FROM t1;
144 a b c1
145 1 10 11
146 2 10 11
147 3 10 11
148 4 10 11
149 5 10 11
150 6 10 11
151 7 10 11
152 8 10 11
153 9 10 11
154 UPDATE t1 SET c1 = 11;
155 START TRANSACTION;
156 DELETE FROM t1 WHERE a > 0;
157 SET SESSION DEBUG="+d,crash_commit_after";
158 CR_SERVER_LOST
159 COMMIT;
160 ERROR HY000: Lost connection to MySQL server during query
161 # restart
162 CHECK TABLE t1;
163 Table Op Msg_type Msg_text
164 test.t1 check status OK
165 SELECT * FROM t1;
166 a b c1
167 DELETE FROM t1 WHERE a > 0;
168 SELECT * FROM t1;
169 a b c1
170 CHECK TABLE t1;
171 Table Op Msg_type Msg_text
172 test.t1 check status OK
173 DROP TABLE t1;
174 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b INT) ROW_FORMAT=REDUNDANT;
175 INSERT INTO t1 VALUES(0, 1), (0, 2), (0, 3), (0, 4), (0, 5);
176 ALTER TABLE t1 ADD COLUMN c1 INT DEFAULT 10;
177 Table id did not change
178 count(*) = 1
179 1
180 CHECK TABLE t1;
181 Table Op Msg_type Msg_text
182 test.t1 check status OK
183 START TRANSACTION;
184 INSERT INTO t1 VALUES(6, 6, 20), (7, 7, 20);
185 SET SESSION DEBUG="+d,crash_commit_before";
186 CR_SERVER_LOST
187 COMMIT;
188 ERROR HY000: Lost connection to MySQL server during query
189 # restart
190 CHECK TABLE t1;
191 Table Op Msg_type Msg_text
192 test.t1 check status OK
193 SELECT * FROM t1;
194 a b c1
195 1 1 10
196 2 2 10
197 3 3 10
198 4 4 10
199 5 5 10
200 INSERT INTO t1 VALUES(6, 6, 20), (7, 7, 20);
201 START TRANSACTION;
202 UPDATE t1 SET b = 10;
203 SET SESSION DEBUG="+d,crash_commit_before";
204 CR_SERVER_LOST
205 COMMIT;
206 ERROR HY000: Lost connection to MySQL server during query
207 # restart
208 CHECK TABLE t1;
209 Table Op Msg_type Msg_text
210 test.t1 check status OK
211 SELECT * FROM t1;
212 a b c1
213 1 1 10
214 2 2 10
215 3 3 10
216 4 4 10
217 5 5 10
218 6 6 20
219 7 7 20
220 UPDATE t1 SET b = 10;
221 START TRANSACTION;
222 UPDATE t1 SET c1 = 11;
223 SET SESSION DEBUG="+d,crash_commit_before";
224 CR_SERVER_LOST
225 COMMIT;
226 ERROR HY000: Lost connection to MySQL server during query
227 # restart
228 CHECK TABLE t1;
229 Table Op Msg_type Msg_text
230 test.t1 check status OK
231 SELECT * FROM t1;
232 a b c1
233 1 10 10
234 2 10 10
235 3 10 10
236 4 10 10
237 5 10 10
238 6 10 20
239 7 10 20
240 UPDATE t1 SET c1 = 11;
241 START TRANSACTION;
242 DELETE FROM t1 WHERE a > 0;
243 SET SESSION DEBUG="+d,crash_commit_before";
244 CR_SERVER_LOST
245 COMMIT;
246 ERROR HY000: Lost connection to MySQL server during query
247 # restart
248 CHECK TABLE t1;
249 Table Op Msg_type Msg_text
250 test.t1 check status OK
251 SELECT * FROM t1;
252 a b c1
253 1 10 11
254 2 10 11
255 3 10 11
256 4 10 11
257 5 10 11
258 6 10 11
259 7 10 11
260 DELETE FROM t1 WHERE a > 0;
261 SELECT * FROM t1;
262 a b c1
263 CHECK TABLE t1;
264 Table Op Msg_type Msg_text
265 test.t1 check status OK
266 DROP TABLE t1;
267 ############################################
268 # Test instant ADD COLUMN for DYNAMIC format
269 ############################################
270 #
271 # Scenario 1:
272 # Create normal table and partitioned table, DML on them, restart
273 #
274 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b INT) ROW_FORMAT=DYNAMIC;
275 INSERT INTO t1 VALUES(0, 1), (0, 2), (0, 3), (0, 4), (0, 5);
276 ALTER TABLE t1 ADD COLUMN c1 INT DEFAULT 10;
277 Table id did not change
278 count(*) = 1
279 1
280 CHECK TABLE t1;
281 Table Op Msg_type Msg_text
282 test.t1 check status OK
283 INSERT INTO t1 VALUES(0, 6, 20), (0, 7, 20);
284 # restart
285 CHECK TABLE t1;
286 Table Op Msg_type Msg_text
287 test.t1 check status OK
288 SELECT * FROM t1;
289 a b c1
290 1 1 10
291 2 2 10
292 3 3 10
293 4 4 10
294 5 5 10
295 6 6 20
296 7 7 20
297 UPDATE t1 SET b = 10;
298 # restart
299 CHECK TABLE t1;
300 Table Op Msg_type Msg_text
301 test.t1 check status OK
302 SELECT * FROM t1;
303 a b c1
304 1 10 10
305 2 10 10
306 3 10 10
307 4 10 10
308 5 10 10
309 6 10 20
310 7 10 20
311 UPDATE t1 SET c1 = 15;
312 # restart
313 CHECK TABLE t1;
314 Table Op Msg_type Msg_text
315 test.t1 check status OK
316 DELETE FROM t1 WHERE a > 0;
317 # restart
318 CHECK TABLE t1;
319 Table Op Msg_type Msg_text
320 test.t1 check status OK
321 SELECT * FROM t1;
322 a b c1
323 INSERT INTO t1(a, b) VALUES(0, 1), (0, 2), (0, 3), (0, 4), (0, 5);
324 ALTER TABLE t1 ADD COLUMN c2 VARCHAR(100) DEFAULT 'Hello World!';
325 Table id did not change
326 count(*) = 2
327 1
328 CHECK TABLE t1;
329 Table Op Msg_type Msg_text
330 test.t1 check status OK
331 UPDATE t1 SET c2 = 'Hello MySQL!';
332 # restart
333 CHECK TABLE t1;
334 Table Op Msg_type Msg_text
335 test.t1 check status OK
336 SELECT * FROM t1;
337 a b c1 c2
338 8 1 10 Hello MySQL!
339 9 2 10 Hello MySQL!
340 10 3 10 Hello MySQL!
341 11 4 10 Hello MySQL!
342 12 5 10 Hello MySQL!
343 DROP TABLE t1;
344 #
345 # Scenario 2:
346 # Create normal table and partitioned table, DML on them, crash
347 #
348 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b INT) ROW_FORMAT=DYNAMIC;
349 INSERT INTO t1 VALUES(0, 1), (0, 2), (0, 3), (0, 4), (0, 5);
350 ALTER TABLE t1 ADD COLUMN c1 INT DEFAULT 10;
351 Table id did not change
352 count(*) = 1
353 1
354 CHECK TABLE t1;
355 Table Op Msg_type Msg_text
356 test.t1 check status OK
357 START TRANSACTION;
358 INSERT INTO t1 VALUES(0, 6, 20), (0, 7, 20);
359 SET SESSION DEBUG="+d,crash_commit_after";
360 CR_SERVER_LOST
361 COMMIT;
362 ERROR HY000: Lost connection to MySQL server during query
363 # restart
364 CHECK TABLE t1;
365 Table Op Msg_type Msg_text
366 test.t1 check status OK
367 SELECT * FROM t1;
368 a b c1
369 1 1 10
370 2 2 10
371 3 3 10
372 4 4 10
373 5 5 10
374 6 6 20
375 7 7 20
376 INSERT INTO t1 VALUES(0, 6, 20), (0, 7, 20);
377 START TRANSACTION;
378 UPDATE t1 SET b = 10;
379 SET SESSION DEBUG="+d,crash_commit_after";
380 CR_SERVER_LOST
381 COMMIT;
382 ERROR HY000: Lost connection to MySQL server during query
383 # restart
384 CHECK TABLE t1;
385 Table Op Msg_type Msg_text
386 test.t1 check status OK
387 SELECT * FROM t1;
388 a b c1
389 1 10 10
390 2 10 10
391 3 10 10
392 4 10 10
393 5 10 10
394 6 10 20
395 7 10 20
396 8 10 20
397 9 10 20
398 UPDATE t1 SET b = 10;
399 START TRANSACTION;
400 UPDATE t1 SET c1 = 11;
401 SET SESSION DEBUG="+d,crash_commit_after";
402 CR_SERVER_LOST
403 COMMIT;
404 ERROR HY000: Lost connection to MySQL server during query
405 # restart
406 CHECK TABLE t1;
407 Table Op Msg_type Msg_text
408 test.t1 check status OK
409 SELECT * FROM t1;
410 a b c1
411 1 10 11
412 2 10 11
413 3 10 11
414 4 10 11
415 5 10 11
416 6 10 11
417 7 10 11
418 8 10 11
419 9 10 11
420 UPDATE t1 SET c1 = 11;
421 START TRANSACTION;
422 DELETE FROM t1 WHERE a > 0;
423 SET SESSION DEBUG="+d,crash_commit_after";
424 CR_SERVER_LOST
425 COMMIT;
426 ERROR HY000: Lost connection to MySQL server during query
427 # restart
428 CHECK TABLE t1;
429 Table Op Msg_type Msg_text
430 test.t1 check status OK
431 SELECT * FROM t1;
432 a b c1
433 DELETE FROM t1 WHERE a > 0;
434 SELECT * FROM t1;
435 a b c1
436 CHECK TABLE t1;
437 Table Op Msg_type Msg_text
438 test.t1 check status OK
439 DROP TABLE t1;
440 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b INT) ROW_FORMAT=DYNAMIC;
441 INSERT INTO t1 VALUES(0, 1), (0, 2), (0, 3), (0, 4), (0, 5);
442 ALTER TABLE t1 ADD COLUMN c1 INT DEFAULT 10;
443 Table id did not change
444 count(*) = 1
445 1
446 CHECK TABLE t1;
447 Table Op Msg_type Msg_text
448 test.t1 check status OK
449 START TRANSACTION;
450 INSERT INTO t1 VALUES(6, 6, 20), (7, 7, 20);
451 SET SESSION DEBUG="+d,crash_commit_before";
452 CR_SERVER_LOST
453 COMMIT;
454 ERROR HY000: Lost connection to MySQL server during query
455 # restart
456 CHECK TABLE t1;
457 Table Op Msg_type Msg_text
458 test.t1 check status OK
459 SELECT * FROM t1;
460 a b c1
461 1 1 10
462 2 2 10
463 3 3 10
464 4 4 10
465 5 5 10
466 INSERT INTO t1 VALUES(6, 6, 20), (7, 7, 20);
467 START TRANSACTION;
468 UPDATE t1 SET b = 10;
469 SET SESSION DEBUG="+d,crash_commit_before";
470 CR_SERVER_LOST
471 COMMIT;
472 ERROR HY000: Lost connection to MySQL server during query
473 # restart
474 CHECK TABLE t1;
475 Table Op Msg_type Msg_text
476 test.t1 check status OK
477 SELECT * FROM t1;
478 a b c1
479 1 1 10
480 2 2 10
481 3 3 10
482 4 4 10
483 5 5 10
484 6 6 20
485 7 7 20
486 UPDATE t1 SET b = 10;
487 START TRANSACTION;
488 UPDATE t1 SET c1 = 11;
489 SET SESSION DEBUG="+d,crash_commit_before";
490 CR_SERVER_LOST
491 COMMIT;
492 ERROR HY000: Lost connection to MySQL server during query
493 # restart
494 CHECK TABLE t1;
495 Table Op Msg_type Msg_text
496 test.t1 check status OK
497 SELECT * FROM t1;
498 a b c1
499 1 10 10
500 2 10 10
501 3 10 10
502 4 10 10
503 5 10 10
504 6 10 20
505 7 10 20
506 UPDATE t1 SET c1 = 11;
507 START TRANSACTION;
508 DELETE FROM t1 WHERE a > 0;
509 SET SESSION DEBUG="+d,crash_commit_before";
510 CR_SERVER_LOST
511 COMMIT;
512 ERROR HY000: Lost connection to MySQL server during query
513 # restart
514 CHECK TABLE t1;
515 Table Op Msg_type Msg_text
516 test.t1 check status OK
517 SELECT * FROM t1;
518 a b c1
519 1 10 11
520 2 10 11
521 3 10 11
522 4 10 11
523 5 10 11
524 6 10 11
525 7 10 11
526 DELETE FROM t1 WHERE a > 0;
527 SELECT * FROM t1;
528 a b c1
529 CHECK TABLE t1;
530 Table Op Msg_type Msg_text
531 test.t1 check status OK
532 DROP TABLE t1;
533 ############################################
534 # Test instant ADD COLUMN for COMPACT format
535 ############################################
536 #
537 # Scenario 1:
538 # Create normal table and partitioned table, DML on them, restart
539 #
540 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b INT) ROW_FORMAT=COMPACT;
541 INSERT INTO t1 VALUES(0, 1), (0, 2), (0, 3), (0, 4), (0, 5);
542 ALTER TABLE t1 ADD COLUMN c1 INT DEFAULT 10;
543 Table id did not change
544 count(*) = 1
545 1
546 CHECK TABLE t1;
547 Table Op Msg_type Msg_text
548 test.t1 check status OK
549 INSERT INTO t1 VALUES(0, 6, 20), (0, 7, 20);
550 # restart
551 CHECK TABLE t1;
552 Table Op Msg_type Msg_text
553 test.t1 check status OK
554 SELECT * FROM t1;
555 a b c1
556 1 1 10
557 2 2 10
558 3 3 10
559 4 4 10
560 5 5 10
561 6 6 20
562 7 7 20
563 UPDATE t1 SET b = 10;
564 # restart
565 CHECK TABLE t1;
566 Table Op Msg_type Msg_text
567 test.t1 check status OK
568 SELECT * FROM t1;
569 a b c1
570 1 10 10
571 2 10 10
572 3 10 10
573 4 10 10
574 5 10 10
575 6 10 20
576 7 10 20
577 UPDATE t1 SET c1 = 15;
578 # restart
579 CHECK TABLE t1;
580 Table Op Msg_type Msg_text
581 test.t1 check status OK
582 DELETE FROM t1 WHERE a > 0;
583 # restart
584 CHECK TABLE t1;
585 Table Op Msg_type Msg_text
586 test.t1 check status OK
587 SELECT * FROM t1;
588 a b c1
589 INSERT INTO t1(a, b) VALUES(0, 1), (0, 2), (0, 3), (0, 4), (0, 5);
590 ALTER TABLE t1 ADD COLUMN c2 VARCHAR(100) DEFAULT 'Hello World!';
591 Table id did not change
592 count(*) = 2
593 1
594 CHECK TABLE t1;
595 Table Op Msg_type Msg_text
596 test.t1 check status OK
597 UPDATE t1 SET c2 = 'Hello MySQL!';
598 # restart
599 CHECK TABLE t1;
600 Table Op Msg_type Msg_text
601 test.t1 check status OK
602 SELECT * FROM t1;
603 a b c1 c2
604 8 1 10 Hello MySQL!
605 9 2 10 Hello MySQL!
606 10 3 10 Hello MySQL!
607 11 4 10 Hello MySQL!
608 12 5 10 Hello MySQL!
609 DROP TABLE t1;
610 #
611 # Scenario 2:
612 # Create normal table and partitioned table, DML on them, crash
613 #
614 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b INT) ROW_FORMAT=COMPACT;
615 INSERT INTO t1 VALUES(0, 1), (0, 2), (0, 3), (0, 4), (0, 5);
616 ALTER TABLE t1 ADD COLUMN c1 INT DEFAULT 10;
617 Table id did not change
618 count(*) = 1
619 1
620 CHECK TABLE t1;
621 Table Op Msg_type Msg_text
622 test.t1 check status OK
623 START TRANSACTION;
624 INSERT INTO t1 VALUES(0, 6, 20), (0, 7, 20);
625 SET SESSION DEBUG="+d,crash_commit_after";
626 CR_SERVER_LOST
627 COMMIT;
628 ERROR HY000: Lost connection to MySQL server during query
629 # restart
630 CHECK TABLE t1;
631 Table Op Msg_type Msg_text
632 test.t1 check status OK
633 SELECT * FROM t1;
634 a b c1
635 1 1 10
636 2 2 10
637 3 3 10
638 4 4 10
639 5 5 10
640 6 6 20
641 7 7 20
642 INSERT INTO t1 VALUES(0, 6, 20), (0, 7, 20);
643 START TRANSACTION;
644 UPDATE t1 SET b = 10;
645 SET SESSION DEBUG="+d,crash_commit_after";
646 CR_SERVER_LOST
647 COMMIT;
648 ERROR HY000: Lost connection to MySQL server during query
649 # restart
650 CHECK TABLE t1;
651 Table Op Msg_type Msg_text
652 test.t1 check status OK
653 SELECT * FROM t1;
654 a b c1
655 1 10 10
656 2 10 10
657 3 10 10
658 4 10 10
659 5 10 10
660 6 10 20
661 7 10 20
662 8 10 20
663 9 10 20
664 UPDATE t1 SET b = 10;
665 START TRANSACTION;
666 UPDATE t1 SET c1 = 11;
667 SET SESSION DEBUG="+d,crash_commit_after";
668 CR_SERVER_LOST
669 COMMIT;
670 ERROR HY000: Lost connection to MySQL server during query
671 # restart
672 CHECK TABLE t1;
673 Table Op Msg_type Msg_text
674 test.t1 check status OK
675 SELECT * FROM t1;
676 a b c1
677 1 10 11
678 2 10 11
679 3 10 11
680 4 10 11
681 5 10 11
682 6 10 11
683 7 10 11
684 8 10 11
685 9 10 11
686 UPDATE t1 SET c1 = 11;
687 START TRANSACTION;
688 DELETE FROM t1 WHERE a > 0;
689 SET SESSION DEBUG="+d,crash_commit_after";
690 CR_SERVER_LOST
691 COMMIT;
692 ERROR HY000: Lost connection to MySQL server during query
693 # restart
694 CHECK TABLE t1;
695 Table Op Msg_type Msg_text
696 test.t1 check status OK
697 SELECT * FROM t1;
698 a b c1
699 DELETE FROM t1 WHERE a > 0;
700 SELECT * FROM t1;
701 a b c1
702 CHECK TABLE t1;
703 Table Op Msg_type Msg_text
704 test.t1 check status OK
705 DROP TABLE t1;
706 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b INT) ROW_FORMAT=COMPACT;
707 INSERT INTO t1 VALUES(0, 1), (0, 2), (0, 3), (0, 4), (0, 5);
708 ALTER TABLE t1 ADD COLUMN c1 INT DEFAULT 10;
709 Table id did not change
710 count(*) = 1
711 1
712 CHECK TABLE t1;
713 Table Op Msg_type Msg_text
714 test.t1 check status OK
715 START TRANSACTION;
716 INSERT INTO t1 VALUES(6, 6, 20), (7, 7, 20);
717 SET SESSION DEBUG="+d,crash_commit_before";
718 CR_SERVER_LOST
719 COMMIT;
720 ERROR HY000: Lost connection to MySQL server during query
721 # restart
722 CHECK TABLE t1;
723 Table Op Msg_type Msg_text
724 test.t1 check status OK
725 SELECT * FROM t1;
726 a b c1
727 1 1 10
728 2 2 10
729 3 3 10
730 4 4 10
731 5 5 10
732 INSERT INTO t1 VALUES(6, 6, 20), (7, 7, 20);
733 START TRANSACTION;
734 UPDATE t1 SET b = 10;
735 SET SESSION DEBUG="+d,crash_commit_before";
736 CR_SERVER_LOST
737 COMMIT;
738 ERROR HY000: Lost connection to MySQL server during query
739 # restart
740 CHECK TABLE t1;
741 Table Op Msg_type Msg_text
742 test.t1 check status OK
743 SELECT * FROM t1;
744 a b c1
745 1 1 10
746 2 2 10
747 3 3 10
748 4 4 10
749 5 5 10
750 6 6 20
751 7 7 20
752 UPDATE t1 SET b = 10;
753 START TRANSACTION;
754 UPDATE t1 SET c1 = 11;
755 SET SESSION DEBUG="+d,crash_commit_before";
756 CR_SERVER_LOST
757 COMMIT;
758 ERROR HY000: Lost connection to MySQL server during query
759 # restart
760 CHECK TABLE t1;
761 Table Op Msg_type Msg_text
762 test.t1 check status OK
763 SELECT * FROM t1;
764 a b c1
765 1 10 10
766 2 10 10
767 3 10 10
768 4 10 10
769 5 10 10
770 6 10 20
771 7 10 20
772 UPDATE t1 SET c1 = 11;
773 START TRANSACTION;
774 DELETE FROM t1 WHERE a > 0;
775 SET SESSION DEBUG="+d,crash_commit_before";
776 CR_SERVER_LOST
777 COMMIT;
778 ERROR HY000: Lost connection to MySQL server during query
779 # restart
780 CHECK TABLE t1;
781 Table Op Msg_type Msg_text
782 test.t1 check status OK
783 SELECT * FROM t1;
784 a b c1
785 1 10 11
786 2 10 11
787 3 10 11
788 4 10 11
789 5 10 11
790 6 10 11
791 7 10 11
792 DELETE FROM t1 WHERE a > 0;
793 SELECT * FROM t1;
794 a b c1
795 CHECK TABLE t1;
796 Table Op Msg_type Msg_text
797 test.t1 check status OK
798 DROP TABLE t1;