Debian Codegraph @

mysql-test/suite/group_replication/r/gr_ddl_no_autocommit.result

raw
1 include/group_replication.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection server1]
6
7 #############################################################
8 # EXECUTE SEVERAL DDL STATEMENTS WHEN AUTOCOMMIT= 0
9 #############################################################
10 CREATE TABLE tt_1 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE=InnoDB;
11 CREATE TABLE tt_2 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE=InnoDB;
12 INSERT INTO tt_1(ddl_case) VALUES(0);
13 INSERT INTO tt_2(ddl_case) VALUES(0);
14 SET AUTOCOMMIT= 0;
15
16 #############################################################
17 # DDL case: 4
18 INSERT INTO tt_1(ddl_case) VALUES (4);
19 CREATE TRIGGER tr AFTER INSERT ON tt_1 FOR EACH ROW UPDATE tt_2 SET ddl_case = ddl_case WHERE ddl_case= NEW.ddl_case;
20 include/show_binlog_events.inc
21 Log_name Pos Event_type Server_id End_log_pos Info
22 server-binary-log.000001 # Query # # BEGIN
23 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
24 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
25 server-binary-log.000001 # Xid # # COMMIT /* XID */
26 server-binary-log.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER tr AFTER INSERT ON tt_1 FOR EACH ROW UPDATE tt_2 SET ddl_case = ddl_case WHERE ddl_case= NEW.ddl_case
27
28 #############################################################
29 # DDL case: 3
30 INSERT INTO tt_1(ddl_case) VALUES (3);
31 DROP TRIGGER tr;
32 include/show_binlog_events.inc
33 Log_name Pos Event_type Server_id End_log_pos Info
34 server-binary-log.000001 # Query # # BEGIN
35 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
36 server-binary-log.000001 # Table_map # # table_id: # (test.tt_2)
37 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
38 server-binary-log.000001 # Xid # # COMMIT /* XID */
39 server-binary-log.000001 # Query # # use `test`; DROP TRIGGER tr
40
41 #############################################################
42 # DDL case: 2
43 INSERT INTO tt_1(ddl_case) VALUES (2);
44 CREATE INDEX ix ON tt_1(ddl_case);
45 include/show_binlog_events.inc
46 Log_name Pos Event_type Server_id End_log_pos Info
47 server-binary-log.000001 # Query # # BEGIN
48 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
49 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
50 server-binary-log.000001 # Xid # # COMMIT /* XID */
51 server-binary-log.000001 # Query # # use `test`; CREATE INDEX ix ON tt_1(ddl_case)
52
53 #############################################################
54 # DDL case: 1
55 INSERT INTO tt_1(ddl_case) VALUES (1);
56 DROP INDEX ix ON tt_1;
57 include/show_binlog_events.inc
58 Log_name Pos Event_type Server_id End_log_pos Info
59 server-binary-log.000001 # Query # # BEGIN
60 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
61 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
62 server-binary-log.000001 # Xid # # COMMIT /* XID */
63 server-binary-log.000001 # Query # # use `test`; DROP INDEX ix ON tt_1
64 SET AUTOCOMMIT= 1;
65
66 #############################################################
67 # CHECK CONSISTENCY
68 #############################################################
69 include/rpl_sync.inc
70 include/diff_tables.inc [server1:tt_1,server2:tt_1]
71 include/assert.inc ['server1 and server2 GTID_EXECUTED must be equal']
72
73 #############################################################
74 # BINLOG CONTENT
75 #############################################################
76 SERVER 1
77 include/show_binlog_events.inc
78 Log_name Pos Event_type Server_id End_log_pos Info
79 server-binary-log.000001 # Previous_gtids # #
80 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
81 server-binary-log.000001 # Query # # BEGIN
82 server-binary-log.000001 # Query # # COMMIT
83 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
84 server-binary-log.000001 # Query # # BEGIN
85 server-binary-log.000001 # Query # # COMMIT
86 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
87 server-binary-log.000001 # Query # # use `test`; CREATE TABLE tt_1 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE=InnoDB
88 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
89 server-binary-log.000001 # Query # # use `test`; CREATE TABLE tt_2 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE=InnoDB
90 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
91 server-binary-log.000001 # Query # # BEGIN
92 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
93 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
94 server-binary-log.000001 # Xid # # COMMIT /* XID */
95 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
96 server-binary-log.000001 # Query # # BEGIN
97 server-binary-log.000001 # Table_map # # table_id: # (test.tt_2)
98 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
99 server-binary-log.000001 # Xid # # COMMIT /* XID */
100 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
101 server-binary-log.000001 # Query # # BEGIN
102 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
103 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
104 server-binary-log.000001 # Xid # # COMMIT /* XID */
105 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
106 server-binary-log.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER tr AFTER INSERT ON tt_1 FOR EACH ROW UPDATE tt_2 SET ddl_case = ddl_case WHERE ddl_case= NEW.ddl_case
107 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
108 server-binary-log.000001 # Query # # BEGIN
109 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
110 server-binary-log.000001 # Table_map # # table_id: # (test.tt_2)
111 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
112 server-binary-log.000001 # Xid # # COMMIT /* XID */
113 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
114 server-binary-log.000001 # Query # # use `test`; DROP TRIGGER tr
115 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
116 server-binary-log.000001 # Query # # BEGIN
117 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
118 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
119 server-binary-log.000001 # Xid # # COMMIT /* XID */
120 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
121 server-binary-log.000001 # Query # # use `test`; CREATE INDEX ix ON tt_1(ddl_case)
122 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
123 server-binary-log.000001 # Query # # BEGIN
124 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
125 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
126 server-binary-log.000001 # Xid # # COMMIT /* XID */
127 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
128 server-binary-log.000001 # Query # # use `test`; DROP INDEX ix ON tt_1
129 SERVER 2
130 include/show_binlog_events.inc
131 Log_name Pos Event_type Server_id End_log_pos Info
132 server-binary-log.000001 # Previous_gtids # #
133 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
134 server-binary-log.000001 # Query # # BEGIN
135 server-binary-log.000001 # Query # # COMMIT
136 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
137 server-binary-log.000001 # Query # # BEGIN
138 server-binary-log.000001 # Query # # COMMIT
139 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
140 server-binary-log.000001 # Query # # use `test`; CREATE TABLE tt_1 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE=InnoDB
141 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
142 server-binary-log.000001 # Query # # use `test`; CREATE TABLE tt_2 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE=InnoDB
143 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
144 server-binary-log.000001 # Query # # BEGIN
145 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
146 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
147 server-binary-log.000001 # Xid # # COMMIT /* XID */
148 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
149 server-binary-log.000001 # Query # # BEGIN
150 server-binary-log.000001 # Table_map # # table_id: # (test.tt_2)
151 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
152 server-binary-log.000001 # Xid # # COMMIT /* XID */
153 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
154 server-binary-log.000001 # Query # # BEGIN
155 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
156 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
157 server-binary-log.000001 # Xid # # COMMIT /* XID */
158 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
159 server-binary-log.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER tr AFTER INSERT ON tt_1 FOR EACH ROW UPDATE tt_2 SET ddl_case = ddl_case WHERE ddl_case= NEW.ddl_case
160 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
161 server-binary-log.000001 # Query # # BEGIN
162 server-binary-log.000001 # Table_map # # table_id: # (test.tt_2)
163 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
164 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
165 server-binary-log.000001 # Xid # # COMMIT /* XID */
166 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
167 server-binary-log.000001 # Query # # use `test`; DROP TRIGGER tr
168 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
169 server-binary-log.000001 # Query # # BEGIN
170 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
171 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
172 server-binary-log.000001 # Xid # # COMMIT /* XID */
173 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
174 server-binary-log.000001 # Query # # use `test`; CREATE INDEX ix ON tt_1(ddl_case)
175 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
176 server-binary-log.000001 # Query # # BEGIN
177 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
178 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
179 server-binary-log.000001 # Xid # # COMMIT /* XID */
180 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
181 server-binary-log.000001 # Query # # use `test`; DROP INDEX ix ON tt_1
182
183 #############################################################
184 # CLEAN
185 #############################################################
186 DROP TABLE tt_1;
187 DROP TABLE tt_2;
188 include/group_replication_end.inc