Debian Codegraph @

mysql-test/suite/rpl/r/rpl_ddl.result

raw
1 include/master-slave.inc
2 [connection master]
3 set global sql_mode='';
4 set local sql_mode='';
5 connection slave;
6 connection master;
7 SET AUTOCOMMIT = 1;
8 CREATE DATABASE mysqltest1;
9 CREATE DATABASE mysqltest2;
10 CREATE TABLE mysqltest1.t1 (f1 BIGINT) ENGINE=InnoDB;
11 connection slave;
12 connection slave;
13 connection master;
14 INSERT INTO mysqltest1.t1 SET f1= 0;
15 CREATE TABLE mysqltest1.t2 (f1 BIGINT) ENGINE=InnoDB;
16 CREATE TABLE mysqltest1.t3 (f1 BIGINT) ENGINE=InnoDB;
17 CREATE TABLE mysqltest1.t4 (f1 BIGINT) ENGINE=InnoDB;
18 CREATE TABLE mysqltest1.t5 (f1 BIGINT) ENGINE=InnoDB;
19 CREATE TABLE mysqltest1.t6 (f1 BIGINT) ENGINE=InnoDB;
20 CREATE INDEX my_idx6 ON mysqltest1.t6(f1);
21 CREATE TABLE mysqltest1.t7 (f1 BIGINT) ENGINE=InnoDB;
22 INSERT INTO mysqltest1.t7 SET f1= 0;
23 CREATE TABLE mysqltest1.t8 (f1 BIGINT) ENGINE=InnoDB;
24 CREATE TABLE mysqltest1.t9 (f1 BIGINT) ENGINE=InnoDB;
25 CREATE TABLE mysqltest1.t10 (f1 BIGINT) ENGINE=InnoDB;
26 CREATE TABLE mysqltest1.t11 (f1 BIGINT) ENGINE=InnoDB;
27 CREATE TABLE mysqltest1.t12 (f1 BIGINT) ENGINE=InnoDB;
28 CREATE TABLE mysqltest1.t13 (f1 BIGINT) ENGINE=InnoDB;
29 CREATE TABLE mysqltest1.t14 (f1 BIGINT) ENGINE=InnoDB;
30 CREATE TABLE mysqltest1.t15 (f1 BIGINT) ENGINE=InnoDB;
31 CREATE TABLE mysqltest1.t16 (f1 BIGINT) ENGINE=InnoDB;
32 CREATE TABLE mysqltest1.t17 (f1 BIGINT) ENGINE=InnoDB;
33 CREATE TABLE mysqltest1.t18 (f1 BIGINT) ENGINE=InnoDB;
34 CREATE TABLE mysqltest1.t19 (f1 BIGINT) ENGINE=InnoDB;
35 CREATE TEMPORARY TABLE mysqltest1.t23 (f1 BIGINT) ENGINE=MEMORY;
36 SET AUTOCOMMIT = 0;
37 use mysqltest1;
38 connection slave;
39 connection slave;
40 SET AUTOCOMMIT = 1;
41 use mysqltest1;
42 connection master;
43
44 ######## SELECT 1 ########
45 connection master;
46 INSERT INTO t1 SET f1= 0 + 1;
47 SELECT MAX(f1) FROM t1;
48 MAX(f1)
49 1
50 connection slave;
51 connection slave;
52 SELECT MAX(f1) FROM t1;
53 MAX(f1)
54 0
55 connection master;
56 SELECT 1;
57 1
58 1
59 SELECT MAX(f1) FROM t1;
60 MAX(f1)
61 1
62 connection slave;
63 connection slave;
64 SELECT MAX(f1) FROM t1;
65 MAX(f1)
66 0
67 connection master;
68 ROLLBACK;
69 SELECT MAX(f1) FROM t1;
70 MAX(f1)
71 0
72
73 TEST-INFO: MASTER: The INSERT is not committed (Succeeded)
74 connection slave;
75 connection slave;
76 SELECT MAX(f1) FROM t1;
77 MAX(f1)
78 0
79
80 TEST-INFO: SLAVE: The INSERT is not committed (Succeeded)
81 connection master;
82
83 ######## SELECT COUNT(*) FROM t1 ########
84 connection master;
85 INSERT INTO t1 SET f1= 0 + 1;
86 SELECT MAX(f1) FROM t1;
87 MAX(f1)
88 1
89 connection slave;
90 connection slave;
91 SELECT MAX(f1) FROM t1;
92 MAX(f1)
93 0
94 connection master;
95 SELECT COUNT(*) FROM t1;
96 COUNT(*)
97 2
98 SELECT MAX(f1) FROM t1;
99 MAX(f1)
100 1
101 connection slave;
102 connection slave;
103 SELECT MAX(f1) FROM t1;
104 MAX(f1)
105 0
106 connection master;
107 ROLLBACK;
108 SELECT MAX(f1) FROM t1;
109 MAX(f1)
110 0
111
112 TEST-INFO: MASTER: The INSERT is not committed (Succeeded)
113 connection slave;
114 connection slave;
115 SELECT MAX(f1) FROM t1;
116 MAX(f1)
117 0
118
119 TEST-INFO: SLAVE: The INSERT is not committed (Succeeded)
120 connection master;
121
122 ######## COMMIT ########
123 connection master;
124 INSERT INTO t1 SET f1= 0 + 1;
125 SELECT MAX(f1) FROM t1;
126 MAX(f1)
127 1
128 connection slave;
129 connection slave;
130 SELECT MAX(f1) FROM t1;
131 MAX(f1)
132 0
133 connection master;
134 COMMIT;
135 SELECT MAX(f1) FROM t1;
136 MAX(f1)
137 1
138 connection slave;
139 connection slave;
140 SELECT MAX(f1) FROM t1;
141 MAX(f1)
142 1
143 connection master;
144 ROLLBACK;
145 SELECT MAX(f1) FROM t1;
146 MAX(f1)
147 1
148
149 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
150 connection slave;
151 connection slave;
152 SELECT MAX(f1) FROM t1;
153 MAX(f1)
154 1
155
156 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
157 connection master;
158
159 ######## ROLLBACK ########
160 connection master;
161 INSERT INTO t1 SET f1= 1 + 1;
162 SELECT MAX(f1) FROM t1;
163 MAX(f1)
164 2
165 connection slave;
166 connection slave;
167 SELECT MAX(f1) FROM t1;
168 MAX(f1)
169 1
170 connection master;
171 ROLLBACK;
172 SELECT MAX(f1) FROM t1;
173 MAX(f1)
174 1
175 connection slave;
176 connection slave;
177 SELECT MAX(f1) FROM t1;
178 MAX(f1)
179 1
180 connection master;
181 ROLLBACK;
182 SELECT MAX(f1) FROM t1;
183 MAX(f1)
184 1
185
186 TEST-INFO: MASTER: The INSERT is not committed (Succeeded)
187 connection slave;
188 connection slave;
189 SELECT MAX(f1) FROM t1;
190 MAX(f1)
191 1
192
193 TEST-INFO: SLAVE: The INSERT is not committed (Succeeded)
194 connection master;
195
196 ######## SET AUTOCOMMIT=1 ########
197 connection master;
198 INSERT INTO t1 SET f1= 1 + 1;
199 SELECT MAX(f1) FROM t1;
200 MAX(f1)
201 2
202 connection slave;
203 connection slave;
204 SELECT MAX(f1) FROM t1;
205 MAX(f1)
206 1
207 connection master;
208 SET AUTOCOMMIT=1;
209 SELECT MAX(f1) FROM t1;
210 MAX(f1)
211 2
212 connection slave;
213 connection slave;
214 SELECT MAX(f1) FROM t1;
215 MAX(f1)
216 2
217 connection master;
218 ROLLBACK;
219 SELECT MAX(f1) FROM t1;
220 MAX(f1)
221 2
222
223 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
224 connection slave;
225 connection slave;
226 SELECT MAX(f1) FROM t1;
227 MAX(f1)
228 2
229
230 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
231 connection master;
232 SET AUTOCOMMIT=0;
233
234 ######## START TRANSACTION ########
235 connection master;
236 INSERT INTO t1 SET f1= 2 + 1;
237 SELECT MAX(f1) FROM t1;
238 MAX(f1)
239 3
240 connection slave;
241 connection slave;
242 SELECT MAX(f1) FROM t1;
243 MAX(f1)
244 2
245 connection master;
246 START TRANSACTION;
247 SELECT MAX(f1) FROM t1;
248 MAX(f1)
249 3
250 connection slave;
251 connection slave;
252 SELECT MAX(f1) FROM t1;
253 MAX(f1)
254 3
255 connection master;
256 ROLLBACK;
257 SELECT MAX(f1) FROM t1;
258 MAX(f1)
259 3
260
261 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
262 connection slave;
263 connection slave;
264 SELECT MAX(f1) FROM t1;
265 MAX(f1)
266 3
267
268 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
269 connection master;
270
271 ######## BEGIN ########
272 connection master;
273 INSERT INTO t1 SET f1= 3 + 1;
274 SELECT MAX(f1) FROM t1;
275 MAX(f1)
276 4
277 connection slave;
278 connection slave;
279 SELECT MAX(f1) FROM t1;
280 MAX(f1)
281 3
282 connection master;
283 BEGIN;
284 SELECT MAX(f1) FROM t1;
285 MAX(f1)
286 4
287 connection slave;
288 connection slave;
289 SELECT MAX(f1) FROM t1;
290 MAX(f1)
291 4
292 connection master;
293 ROLLBACK;
294 SELECT MAX(f1) FROM t1;
295 MAX(f1)
296 4
297
298 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
299 connection slave;
300 connection slave;
301 SELECT MAX(f1) FROM t1;
302 MAX(f1)
303 4
304
305 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
306 connection master;
307
308 ######## DROP TABLE mysqltest1.t2 ########
309 connection master;
310 INSERT INTO t1 SET f1= 4 + 1;
311 SELECT MAX(f1) FROM t1;
312 MAX(f1)
313 5
314 connection slave;
315 connection slave;
316 SELECT MAX(f1) FROM t1;
317 MAX(f1)
318 4
319 connection master;
320 DROP TABLE mysqltest1.t2;
321 SELECT MAX(f1) FROM t1;
322 MAX(f1)
323 5
324 connection slave;
325 connection slave;
326 SELECT MAX(f1) FROM t1;
327 MAX(f1)
328 5
329 connection master;
330 ROLLBACK;
331 SELECT MAX(f1) FROM t1;
332 MAX(f1)
333 5
334
335 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
336 connection slave;
337 connection slave;
338 SELECT MAX(f1) FROM t1;
339 MAX(f1)
340 5
341
342 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
343 connection master;
344 SHOW TABLES LIKE 't2';
345 Tables_in_mysqltest1 (t2)
346 connection slave;
347 SHOW TABLES LIKE 't2';
348 Tables_in_mysqltest1 (t2)
349 connection master;
350
351 ######## DROP TEMPORARY TABLE mysqltest1.t23 ########
352 connection master;
353 INSERT INTO t1 SET f1= 5 + 1;
354 SELECT MAX(f1) FROM t1;
355 MAX(f1)
356 6
357 connection slave;
358 connection slave;
359 SELECT MAX(f1) FROM t1;
360 MAX(f1)
361 5
362 connection master;
363 DROP TEMPORARY TABLE mysqltest1.t23;
364 SELECT MAX(f1) FROM t1;
365 MAX(f1)
366 6
367 connection slave;
368 connection slave;
369 SELECT MAX(f1) FROM t1;
370 MAX(f1)
371 5
372 connection master;
373 ROLLBACK;
374 SELECT MAX(f1) FROM t1;
375 MAX(f1)
376 5
377
378 TEST-INFO: MASTER: The INSERT is not committed (Succeeded)
379 connection slave;
380 connection slave;
381 SELECT MAX(f1) FROM t1;
382 MAX(f1)
383 6
384
385 TEST-INFO: SLAVE: The INSERT is committed (Failed)
386 connection master;
387 SHOW TABLES LIKE 't23';
388 Tables_in_mysqltest1 (t23)
389 connection slave;
390 SHOW TABLES LIKE 't23';
391 Tables_in_mysqltest1 (t23)
392 connection master;
393
394 ######## RENAME TABLE mysqltest1.t3 to mysqltest1.t20 ########
395 connection master;
396 INSERT INTO t1 SET f1= 5 + 1;
397 SELECT MAX(f1) FROM t1;
398 MAX(f1)
399 6
400 connection slave;
401 connection slave;
402 SELECT MAX(f1) FROM t1;
403 MAX(f1)
404 6
405 connection master;
406 RENAME TABLE mysqltest1.t3 to mysqltest1.t20;
407 SELECT MAX(f1) FROM t1;
408 MAX(f1)
409 6
410 connection slave;
411 connection slave;
412 SELECT MAX(f1) FROM t1;
413 MAX(f1)
414 6
415 connection master;
416 ROLLBACK;
417 SELECT MAX(f1) FROM t1;
418 MAX(f1)
419 6
420
421 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
422 connection slave;
423 connection slave;
424 SELECT MAX(f1) FROM t1;
425 MAX(f1)
426 6
427
428 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
429 connection master;
430 SHOW TABLES LIKE 't20';
431 Tables_in_mysqltest1 (t20)
432 t20
433 connection slave;
434 SHOW TABLES LIKE 't20';
435 Tables_in_mysqltest1 (t20)
436 t20
437 connection master;
438
439 ######## ALTER TABLE mysqltest1.t4 ADD column f2 BIGINT ########
440 connection master;
441 INSERT INTO t1 SET f1= 6 + 1;
442 SELECT MAX(f1) FROM t1;
443 MAX(f1)
444 7
445 connection slave;
446 connection slave;
447 SELECT MAX(f1) FROM t1;
448 MAX(f1)
449 6
450 connection master;
451 ALTER TABLE mysqltest1.t4 ADD column f2 BIGINT;
452 SELECT MAX(f1) FROM t1;
453 MAX(f1)
454 7
455 connection slave;
456 connection slave;
457 SELECT MAX(f1) FROM t1;
458 MAX(f1)
459 7
460 connection master;
461 ROLLBACK;
462 SELECT MAX(f1) FROM t1;
463 MAX(f1)
464 7
465
466 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
467 connection slave;
468 connection slave;
469 SELECT MAX(f1) FROM t1;
470 MAX(f1)
471 7
472
473 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
474 connection master;
475 describe mysqltest1.t4;
476 Field Type Null Key Default Extra
477 f1 bigint(20) YES NULL
478 f2 bigint(20) YES NULL
479 connection slave;
480 describe mysqltest1.t4;
481 Field Type Null Key Default Extra
482 f1 bigint(20) YES NULL
483 f2 bigint(20) YES NULL
484 connection master;
485
486 ######## CREATE TABLE mysqltest1.t21 (f1 BIGINT) ENGINE= InnoDB ########
487 connection master;
488 INSERT INTO t1 SET f1= 7 + 1;
489 SELECT MAX(f1) FROM t1;
490 MAX(f1)
491 8
492 connection slave;
493 connection slave;
494 SELECT MAX(f1) FROM t1;
495 MAX(f1)
496 7
497 connection master;
498 CREATE TABLE mysqltest1.t21 (f1 BIGINT) ENGINE= InnoDB;
499 SELECT MAX(f1) FROM t1;
500 MAX(f1)
501 8
502 connection slave;
503 connection slave;
504 SELECT MAX(f1) FROM t1;
505 MAX(f1)
506 8
507 connection master;
508 ROLLBACK;
509 SELECT MAX(f1) FROM t1;
510 MAX(f1)
511 8
512
513 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
514 connection slave;
515 connection slave;
516 SELECT MAX(f1) FROM t1;
517 MAX(f1)
518 8
519
520 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
521 connection master;
522
523 ######## CREATE TEMPORARY TABLE mysqltest1.t22 (f1 BIGINT) ENGINE=MEMORY ########
524 connection master;
525 INSERT INTO t1 SET f1= 8 + 1;
526 SELECT MAX(f1) FROM t1;
527 MAX(f1)
528 9
529 connection slave;
530 connection slave;
531 SELECT MAX(f1) FROM t1;
532 MAX(f1)
533 8
534 connection master;
535 CREATE TEMPORARY TABLE mysqltest1.t22 (f1 BIGINT) ENGINE=MEMORY;
536 SELECT MAX(f1) FROM t1;
537 MAX(f1)
538 9
539 connection slave;
540 connection slave;
541 SELECT MAX(f1) FROM t1;
542 MAX(f1)
543 8
544 connection master;
545 ROLLBACK;
546 SELECT MAX(f1) FROM t1;
547 MAX(f1)
548 8
549
550 TEST-INFO: MASTER: The INSERT is not committed (Succeeded)
551 connection slave;
552 connection slave;
553 SELECT MAX(f1) FROM t1;
554 MAX(f1)
555 9
556
557 TEST-INFO: SLAVE: The INSERT is committed (Failed)
558 connection master;
559
560 ######## TRUNCATE TABLE mysqltest1.t7 ########
561 connection master;
562 INSERT INTO t1 SET f1= 8 + 1;
563 SELECT MAX(f1) FROM t1;
564 MAX(f1)
565 9
566 connection slave;
567 connection slave;
568 SELECT MAX(f1) FROM t1;
569 MAX(f1)
570 9
571 connection master;
572 TRUNCATE TABLE mysqltest1.t7;
573 SELECT MAX(f1) FROM t1;
574 MAX(f1)
575 9
576 connection slave;
577 connection slave;
578 SELECT MAX(f1) FROM t1;
579 MAX(f1)
580 9
581 connection master;
582 ROLLBACK;
583 SELECT MAX(f1) FROM t1;
584 MAX(f1)
585 9
586
587 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
588 connection slave;
589 connection slave;
590 SELECT MAX(f1) FROM t1;
591 MAX(f1)
592 9
593
594 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
595 connection master;
596 SELECT * FROM mysqltest1.t7;
597 f1
598 connection slave;
599 connection slave;
600 SELECT * FROM mysqltest1.t7;
601 f1
602 connection master;
603
604 ######## LOCK TABLES mysqltest1.t1 WRITE, mysqltest1.t8 READ ########
605 connection master;
606 INSERT INTO t1 SET f1= 9 + 1;
607 SELECT MAX(f1) FROM t1;
608 MAX(f1)
609 10
610 connection slave;
611 connection slave;
612 SELECT MAX(f1) FROM t1;
613 MAX(f1)
614 9
615 connection master;
616 LOCK TABLES mysqltest1.t1 WRITE, mysqltest1.t8 READ;
617 SELECT MAX(f1) FROM t1;
618 MAX(f1)
619 10
620 connection slave;
621 connection slave;
622 SELECT MAX(f1) FROM t1;
623 MAX(f1)
624 10
625 connection master;
626 ROLLBACK;
627 SELECT MAX(f1) FROM t1;
628 MAX(f1)
629 10
630
631 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
632 connection slave;
633 connection slave;
634 SELECT MAX(f1) FROM t1;
635 MAX(f1)
636 10
637
638 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
639 connection master;
640 UNLOCK TABLES;
641
642 ######## UNLOCK TABLES ########
643 connection master;
644 INSERT INTO t1 SET f1= 10 + 1;
645 SELECT MAX(f1) FROM t1;
646 MAX(f1)
647 11
648 connection slave;
649 connection slave;
650 SELECT MAX(f1) FROM t1;
651 MAX(f1)
652 10
653 connection master;
654 UNLOCK TABLES;
655 SELECT MAX(f1) FROM t1;
656 MAX(f1)
657 11
658 connection slave;
659 connection slave;
660 SELECT MAX(f1) FROM t1;
661 MAX(f1)
662 10
663 connection master;
664 ROLLBACK;
665 SELECT MAX(f1) FROM t1;
666 MAX(f1)
667 10
668
669 TEST-INFO: MASTER: The INSERT is not committed (Succeeded)
670 connection slave;
671 connection slave;
672 SELECT MAX(f1) FROM t1;
673 MAX(f1)
674 10
675
676 TEST-INFO: SLAVE: The INSERT is not committed (Succeeded)
677 connection master;
678 LOCK TABLES mysqltest1.t1 READ;
679
680 ######## UNLOCK TABLES ########
681 connection master;
682 INSERT INTO t1 SET f1= 10 + 1;
683 ERROR HY000: Table 't1' was locked with a READ lock and can't be updated
684 SELECT MAX(f1) FROM t1;
685 MAX(f1)
686 10
687 connection slave;
688 connection slave;
689 SELECT MAX(f1) FROM t1;
690 MAX(f1)
691 10
692 connection master;
693 UNLOCK TABLES;
694 SELECT MAX(f1) FROM t1;
695 MAX(f1)
696 10
697 connection slave;
698 connection slave;
699 SELECT MAX(f1) FROM t1;
700 MAX(f1)
701 10
702 connection master;
703 ROLLBACK;
704 SELECT MAX(f1) FROM t1;
705 MAX(f1)
706 10
707
708 TEST-INFO: MASTER: The INSERT is not committed (Succeeded)
709 connection slave;
710 connection slave;
711 SELECT MAX(f1) FROM t1;
712 MAX(f1)
713 10
714
715 TEST-INFO: SLAVE: The INSERT is not committed (Succeeded)
716 connection master;
717 LOCK TABLES mysqltest1.t1 WRITE, mysqltest1.t8 READ;
718
719 ######## UNLOCK TABLES ########
720 connection master;
721 INSERT INTO t1 SET f1= 10 + 1;
722 SELECT MAX(f1) FROM t1;
723 MAX(f1)
724 11
725 connection slave;
726 connection slave;
727 SELECT MAX(f1) FROM t1;
728 MAX(f1)
729 10
730 connection master;
731 UNLOCK TABLES;
732 SELECT MAX(f1) FROM t1;
733 MAX(f1)
734 11
735 connection slave;
736 connection slave;
737 SELECT MAX(f1) FROM t1;
738 MAX(f1)
739 11
740 connection master;
741 ROLLBACK;
742 SELECT MAX(f1) FROM t1;
743 MAX(f1)
744 11
745
746 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
747 connection slave;
748 connection slave;
749 SELECT MAX(f1) FROM t1;
750 MAX(f1)
751 11
752
753 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
754 connection master;
755
756 ######## DROP INDEX my_idx6 ON mysqltest1.t6 ########
757 connection master;
758 INSERT INTO t1 SET f1= 11 + 1;
759 SELECT MAX(f1) FROM t1;
760 MAX(f1)
761 12
762 connection slave;
763 connection slave;
764 SELECT MAX(f1) FROM t1;
765 MAX(f1)
766 11
767 connection master;
768 DROP INDEX my_idx6 ON mysqltest1.t6;
769 SELECT MAX(f1) FROM t1;
770 MAX(f1)
771 12
772 connection slave;
773 connection slave;
774 SELECT MAX(f1) FROM t1;
775 MAX(f1)
776 12
777 connection master;
778 ROLLBACK;
779 SELECT MAX(f1) FROM t1;
780 MAX(f1)
781 12
782
783 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
784 connection slave;
785 connection slave;
786 SELECT MAX(f1) FROM t1;
787 MAX(f1)
788 12
789
790 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
791 connection master;
792 SHOW INDEX FROM mysqltest1.t6;
793 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Ignored
794 connection slave;
795 SHOW INDEX FROM mysqltest1.t6;
796 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Ignored
797 connection master;
798
799 ######## CREATE INDEX my_idx5 ON mysqltest1.t5(f1) ########
800 connection master;
801 INSERT INTO t1 SET f1= 12 + 1;
802 SELECT MAX(f1) FROM t1;
803 MAX(f1)
804 13
805 connection slave;
806 connection slave;
807 SELECT MAX(f1) FROM t1;
808 MAX(f1)
809 12
810 connection master;
811 CREATE INDEX my_idx5 ON mysqltest1.t5(f1);
812 SELECT MAX(f1) FROM t1;
813 MAX(f1)
814 13
815 connection slave;
816 connection slave;
817 SELECT MAX(f1) FROM t1;
818 MAX(f1)
819 13
820 connection master;
821 ROLLBACK;
822 SELECT MAX(f1) FROM t1;
823 MAX(f1)
824 13
825
826 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
827 connection slave;
828 connection slave;
829 SELECT MAX(f1) FROM t1;
830 MAX(f1)
831 13
832
833 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
834 connection master;
835 SHOW INDEX FROM mysqltest1.t5;
836 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Ignored
837 t5 1 my_idx5 1 f1 A 0 NULL NULL YES BTREE NO
838 connection slave;
839 SHOW INDEX FROM mysqltest1.t5;
840 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Ignored
841 t5 1 my_idx5 1 f1 A NULL NULL NULL YES BTREE NO
842 connection master;
843
844 ######## DROP DATABASE mysqltest2 ########
845 connection master;
846 INSERT INTO t1 SET f1= 13 + 1;
847 SELECT MAX(f1) FROM t1;
848 MAX(f1)
849 14
850 connection slave;
851 connection slave;
852 SELECT MAX(f1) FROM t1;
853 MAX(f1)
854 13
855 connection master;
856 DROP DATABASE mysqltest2;
857 SELECT MAX(f1) FROM t1;
858 MAX(f1)
859 14
860 connection slave;
861 connection slave;
862 SELECT MAX(f1) FROM t1;
863 MAX(f1)
864 14
865 connection master;
866 ROLLBACK;
867 SELECT MAX(f1) FROM t1;
868 MAX(f1)
869 14
870
871 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
872 connection slave;
873 connection slave;
874 SELECT MAX(f1) FROM t1;
875 MAX(f1)
876 14
877
878 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
879 connection master;
880 SHOW DATABASES LIKE "mysqltest2";
881 Database (mysqltest2)
882 connection slave;
883 SHOW DATABASES LIKE "mysqltest2";
884 Database (mysqltest2)
885 connection master;
886
887 ######## CREATE DATABASE mysqltest3 ########
888 connection master;
889 INSERT INTO t1 SET f1= 14 + 1;
890 SELECT MAX(f1) FROM t1;
891 MAX(f1)
892 15
893 connection slave;
894 connection slave;
895 SELECT MAX(f1) FROM t1;
896 MAX(f1)
897 14
898 connection master;
899 CREATE DATABASE mysqltest3;
900 SELECT MAX(f1) FROM t1;
901 MAX(f1)
902 15
903 connection slave;
904 connection slave;
905 SELECT MAX(f1) FROM t1;
906 MAX(f1)
907 15
908 connection master;
909 ROLLBACK;
910 SELECT MAX(f1) FROM t1;
911 MAX(f1)
912 15
913
914 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
915 connection slave;
916 connection slave;
917 SELECT MAX(f1) FROM t1;
918 MAX(f1)
919 15
920
921 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
922 connection master;
923 SHOW DATABASES LIKE "mysqltest3";
924 Database (mysqltest3)
925 mysqltest3
926 connection slave;
927 SHOW DATABASES LIKE "mysqltest3";
928 Database (mysqltest3)
929 mysqltest3
930 connection master;
931
932 ######## CREATE PROCEDURE p1() READS SQL DATA SELECT "this is p1" ########
933 connection master;
934 INSERT INTO t1 SET f1= 15 + 1;
935 SELECT MAX(f1) FROM t1;
936 MAX(f1)
937 16
938 connection slave;
939 connection slave;
940 SELECT MAX(f1) FROM t1;
941 MAX(f1)
942 15
943 connection master;
944 CREATE PROCEDURE p1() READS SQL DATA SELECT "this is p1";
945 SELECT MAX(f1) FROM t1;
946 MAX(f1)
947 16
948 connection slave;
949 connection slave;
950 SELECT MAX(f1) FROM t1;
951 MAX(f1)
952 16
953 connection master;
954 ROLLBACK;
955 SELECT MAX(f1) FROM t1;
956 MAX(f1)
957 16
958
959 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
960 connection slave;
961 connection slave;
962 SELECT MAX(f1) FROM t1;
963 MAX(f1)
964 16
965
966 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
967 connection master;
968 SHOW PROCEDURE STATUS LIKE 'p1';
969 Db mysqltest1
970 Name p1
971 Type PROCEDURE
972 Definer root@localhost
973 Modified #
974 Created #
975 Security_type DEFINER
976 Comment
977 character_set_client latin1
978 collation_connection latin1_swedish_ci
979 Database Collation utf8mb4_uca1400_ai_ci
980 connection slave;
981 SHOW PROCEDURE STATUS LIKE 'p1';
982 Db mysqltest1
983 Name p1
984 Type PROCEDURE
985 Definer root@localhost
986 Modified #
987 Created #
988 Security_type DEFINER
989 Comment
990 character_set_client latin1
991 collation_connection latin1_swedish_ci
992 Database Collation utf8mb4_uca1400_ai_ci
993 connection master;
994
995 ######## ALTER PROCEDURE p1 COMMENT "I have been altered" ########
996 connection master;
997 INSERT INTO t1 SET f1= 16 + 1;
998 SELECT MAX(f1) FROM t1;
999 MAX(f1)
1000 17
1001 connection slave;
1002 connection slave;
1003 SELECT MAX(f1) FROM t1;
1004 MAX(f1)
1005 16
1006 connection master;
1007 ALTER PROCEDURE p1 COMMENT "I have been altered";
1008 SELECT MAX(f1) FROM t1;
1009 MAX(f1)
1010 17
1011 connection slave;
1012 connection slave;
1013 SELECT MAX(f1) FROM t1;
1014 MAX(f1)
1015 17
1016 connection master;
1017 ROLLBACK;
1018 SELECT MAX(f1) FROM t1;
1019 MAX(f1)
1020 17
1021
1022 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
1023 connection slave;
1024 connection slave;
1025 SELECT MAX(f1) FROM t1;
1026 MAX(f1)
1027 17
1028
1029 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
1030 connection master;
1031 SHOW PROCEDURE STATUS LIKE 'p1';
1032 Db mysqltest1
1033 Name p1
1034 Type PROCEDURE
1035 Definer root@localhost
1036 Modified #
1037 Created #
1038 Security_type DEFINER
1039 Comment I have been altered
1040 character_set_client latin1
1041 collation_connection latin1_swedish_ci
1042 Database Collation utf8mb4_uca1400_ai_ci
1043 connection slave;
1044 SHOW PROCEDURE STATUS LIKE 'p1';
1045 Db mysqltest1
1046 Name p1
1047 Type PROCEDURE
1048 Definer root@localhost
1049 Modified #
1050 Created #
1051 Security_type DEFINER
1052 Comment I have been altered
1053 character_set_client latin1
1054 collation_connection latin1_swedish_ci
1055 Database Collation utf8mb4_uca1400_ai_ci
1056 connection master;
1057
1058 ######## DROP PROCEDURE p1 ########
1059 connection master;
1060 INSERT INTO t1 SET f1= 17 + 1;
1061 SELECT MAX(f1) FROM t1;
1062 MAX(f1)
1063 18
1064 connection slave;
1065 connection slave;
1066 SELECT MAX(f1) FROM t1;
1067 MAX(f1)
1068 17
1069 connection master;
1070 DROP PROCEDURE p1;
1071 SELECT MAX(f1) FROM t1;
1072 MAX(f1)
1073 18
1074 connection slave;
1075 connection slave;
1076 SELECT MAX(f1) FROM t1;
1077 MAX(f1)
1078 18
1079 connection master;
1080 ROLLBACK;
1081 SELECT MAX(f1) FROM t1;
1082 MAX(f1)
1083 18
1084
1085 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
1086 connection slave;
1087 connection slave;
1088 SELECT MAX(f1) FROM t1;
1089 MAX(f1)
1090 18
1091
1092 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
1093 connection master;
1094 SHOW PROCEDURE STATUS LIKE 'p1';
1095 connection slave;
1096 SHOW PROCEDURE STATUS LIKE 'p1';
1097 connection master;
1098
1099 ######## CREATE OR REPLACE VIEW v1 as select * from t1 ########
1100 connection master;
1101 INSERT INTO t1 SET f1= 18 + 1;
1102 SELECT MAX(f1) FROM t1;
1103 MAX(f1)
1104 19
1105 connection slave;
1106 connection slave;
1107 SELECT MAX(f1) FROM t1;
1108 MAX(f1)
1109 18
1110 connection master;
1111 CREATE OR REPLACE VIEW v1 as select * from t1;
1112 SELECT MAX(f1) FROM t1;
1113 MAX(f1)
1114 19
1115 connection slave;
1116 connection slave;
1117 SELECT MAX(f1) FROM t1;
1118 MAX(f1)
1119 19
1120 connection master;
1121 ROLLBACK;
1122 SELECT MAX(f1) FROM t1;
1123 MAX(f1)
1124 19
1125
1126 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
1127 connection slave;
1128 connection slave;
1129 SELECT MAX(f1) FROM t1;
1130 MAX(f1)
1131 19
1132
1133 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
1134 connection master;
1135 SHOW CREATE VIEW v1;
1136 View Create View character_set_client collation_connection
1137 v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`f1` AS `f1` from `t1` latin1 latin1_swedish_ci
1138 connection slave;
1139 SHOW CREATE VIEW v1;
1140 View Create View character_set_client collation_connection
1141 v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`f1` AS `f1` from `t1` latin1 latin1_swedish_ci
1142 connection master;
1143
1144 ######## ALTER VIEW v1 AS select f1 from t1 ########
1145 connection master;
1146 INSERT INTO t1 SET f1= 19 + 1;
1147 SELECT MAX(f1) FROM t1;
1148 MAX(f1)
1149 20
1150 connection slave;
1151 connection slave;
1152 SELECT MAX(f1) FROM t1;
1153 MAX(f1)
1154 19
1155 connection master;
1156 ALTER VIEW v1 AS select f1 from t1;
1157 SELECT MAX(f1) FROM t1;
1158 MAX(f1)
1159 20
1160 connection slave;
1161 connection slave;
1162 SELECT MAX(f1) FROM t1;
1163 MAX(f1)
1164 20
1165 connection master;
1166 ROLLBACK;
1167 SELECT MAX(f1) FROM t1;
1168 MAX(f1)
1169 20
1170
1171 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
1172 connection slave;
1173 connection slave;
1174 SELECT MAX(f1) FROM t1;
1175 MAX(f1)
1176 20
1177
1178 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
1179 connection master;
1180 SHOW CREATE VIEW v1;
1181 View Create View character_set_client collation_connection
1182 v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`f1` AS `f1` from `t1` latin1 latin1_swedish_ci
1183 connection slave;
1184 SHOW CREATE VIEW v1;
1185 View Create View character_set_client collation_connection
1186 v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`f1` AS `f1` from `t1` latin1 latin1_swedish_ci
1187 connection master;
1188
1189 ######## DROP VIEW IF EXISTS v1 ########
1190 connection master;
1191 INSERT INTO t1 SET f1= 20 + 1;
1192 SELECT MAX(f1) FROM t1;
1193 MAX(f1)
1194 21
1195 connection slave;
1196 connection slave;
1197 SELECT MAX(f1) FROM t1;
1198 MAX(f1)
1199 20
1200 connection master;
1201 DROP VIEW IF EXISTS v1;
1202 SELECT MAX(f1) FROM t1;
1203 MAX(f1)
1204 21
1205 connection slave;
1206 connection slave;
1207 SELECT MAX(f1) FROM t1;
1208 MAX(f1)
1209 21
1210 connection master;
1211 ROLLBACK;
1212 SELECT MAX(f1) FROM t1;
1213 MAX(f1)
1214 21
1215
1216 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
1217 connection slave;
1218 connection slave;
1219 SELECT MAX(f1) FROM t1;
1220 MAX(f1)
1221 21
1222
1223 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
1224 connection master;
1225 SHOW CREATE VIEW v1;
1226 ERROR 42S02: Table 'mysqltest1.v1' doesn't exist
1227 connection slave;
1228 SHOW CREATE VIEW v1;
1229 ERROR 42S02: Table 'mysqltest1.v1' doesn't exist
1230 connection master;
1231
1232 ######## CREATE TRIGGER trg1 BEFORE INSERT ON t1 FOR EACH ROW SET @a:=1 ########
1233 connection master;
1234 INSERT INTO t1 SET f1= 21 + 1;
1235 SELECT MAX(f1) FROM t1;
1236 MAX(f1)
1237 22
1238 connection slave;
1239 connection slave;
1240 SELECT MAX(f1) FROM t1;
1241 MAX(f1)
1242 21
1243 connection master;
1244 CREATE TRIGGER trg1 BEFORE INSERT ON t1 FOR EACH ROW SET @a:=1;
1245 SELECT MAX(f1) FROM t1;
1246 MAX(f1)
1247 22
1248 connection slave;
1249 connection slave;
1250 SELECT MAX(f1) FROM t1;
1251 MAX(f1)
1252 22
1253 connection master;
1254 ROLLBACK;
1255 SELECT MAX(f1) FROM t1;
1256 MAX(f1)
1257 22
1258
1259 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
1260 connection slave;
1261 connection slave;
1262 SELECT MAX(f1) FROM t1;
1263 MAX(f1)
1264 22
1265
1266 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
1267 connection master;
1268 SHOW TRIGGERS;
1269 Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
1270 trg1 INSERT t1 SET @a:=1 BEFORE # root@localhost latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
1271 connection slave;
1272 SHOW TRIGGERS;
1273 Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
1274 trg1 INSERT t1 SET @a:=1 BEFORE # root@localhost latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
1275 connection master;
1276
1277 ######## DROP TRIGGER trg1 ########
1278 connection master;
1279 INSERT INTO t1 SET f1= 22 + 1;
1280 SELECT MAX(f1) FROM t1;
1281 MAX(f1)
1282 23
1283 connection slave;
1284 connection slave;
1285 SELECT MAX(f1) FROM t1;
1286 MAX(f1)
1287 22
1288 connection master;
1289 DROP TRIGGER trg1;
1290 SELECT MAX(f1) FROM t1;
1291 MAX(f1)
1292 23
1293 connection slave;
1294 connection slave;
1295 SELECT MAX(f1) FROM t1;
1296 MAX(f1)
1297 23
1298 connection master;
1299 ROLLBACK;
1300 SELECT MAX(f1) FROM t1;
1301 MAX(f1)
1302 23
1303
1304 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
1305 connection slave;
1306 connection slave;
1307 SELECT MAX(f1) FROM t1;
1308 MAX(f1)
1309 23
1310
1311 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
1312 connection master;
1313 SHOW TRIGGERS;
1314 Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
1315 connection slave;
1316 SHOW TRIGGERS;
1317 Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
1318 connection master;
1319
1320 ######## CREATE USER user1@localhost ########
1321 connection master;
1322 INSERT INTO t1 SET f1= 23 + 1;
1323 SELECT MAX(f1) FROM t1;
1324 MAX(f1)
1325 24
1326 connection slave;
1327 connection slave;
1328 SELECT MAX(f1) FROM t1;
1329 MAX(f1)
1330 23
1331 connection master;
1332 CREATE USER user1@localhost;
1333 SELECT MAX(f1) FROM t1;
1334 MAX(f1)
1335 24
1336 connection slave;
1337 connection slave;
1338 SELECT MAX(f1) FROM t1;
1339 MAX(f1)
1340 24
1341 connection master;
1342 ROLLBACK;
1343 SELECT MAX(f1) FROM t1;
1344 MAX(f1)
1345 24
1346
1347 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
1348 connection slave;
1349 connection slave;
1350 SELECT MAX(f1) FROM t1;
1351 MAX(f1)
1352 24
1353
1354 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
1355 connection master;
1356 SELECT user FROM mysql.user WHERE user = 'user1';
1357 User
1358 user1
1359 connection slave;
1360 SELECT user FROM mysql.user WHERE user = 'user1';
1361 User
1362 user1
1363 connection master;
1364
1365 ######## RENAME USER user1@localhost TO rename1@localhost ########
1366 connection master;
1367 INSERT INTO t1 SET f1= 24 + 1;
1368 SELECT MAX(f1) FROM t1;
1369 MAX(f1)
1370 25
1371 connection slave;
1372 connection slave;
1373 SELECT MAX(f1) FROM t1;
1374 MAX(f1)
1375 24
1376 connection master;
1377 RENAME USER user1@localhost TO rename1@localhost;
1378 SELECT MAX(f1) FROM t1;
1379 MAX(f1)
1380 25
1381 connection slave;
1382 connection slave;
1383 SELECT MAX(f1) FROM t1;
1384 MAX(f1)
1385 25
1386 connection master;
1387 ROLLBACK;
1388 SELECT MAX(f1) FROM t1;
1389 MAX(f1)
1390 25
1391
1392 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
1393 connection slave;
1394 connection slave;
1395 SELECT MAX(f1) FROM t1;
1396 MAX(f1)
1397 25
1398
1399 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
1400 connection master;
1401 SELECT user FROM mysql.user WHERE user = 'rename1';
1402 User
1403 rename1
1404 connection slave;
1405 SELECT user FROM mysql.user WHERE user = 'rename1';
1406 User
1407 rename1
1408 connection master;
1409
1410 ######## DROP USER rename1@localhost ########
1411 connection master;
1412 INSERT INTO t1 SET f1= 25 + 1;
1413 SELECT MAX(f1) FROM t1;
1414 MAX(f1)
1415 26
1416 connection slave;
1417 connection slave;
1418 SELECT MAX(f1) FROM t1;
1419 MAX(f1)
1420 25
1421 connection master;
1422 DROP USER rename1@localhost;
1423 SELECT MAX(f1) FROM t1;
1424 MAX(f1)
1425 26
1426 connection slave;
1427 connection slave;
1428 SELECT MAX(f1) FROM t1;
1429 MAX(f1)
1430 26
1431 connection master;
1432 ROLLBACK;
1433 SELECT MAX(f1) FROM t1;
1434 MAX(f1)
1435 26
1436
1437 TEST-INFO: MASTER: The INSERT is committed (Succeeded)
1438 connection slave;
1439 connection slave;
1440 SELECT MAX(f1) FROM t1;
1441 MAX(f1)
1442 26
1443
1444 TEST-INFO: SLAVE: The INSERT is committed (Succeeded)
1445 connection master;
1446 SELECT user FROM mysql.user WHERE user = 'rename1';
1447 User
1448 connection slave;
1449 SELECT user FROM mysql.user WHERE user = 'rename1';
1450 User
1451 use test;
1452 connection master;
1453 DROP TEMPORARY TABLE mysqltest1.t22;
1454 DROP DATABASE mysqltest1;
1455 DROP DATABASE mysqltest3;
1456 set global sql_mode=default;
1457 include/rpl_end.inc