Debian Codegraph @

mysql-test/suite/group_replication/r/gr_row_implicit_commit_binlog.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 # CONFIGURATION
8 #########################################################################
9 CREATE TABLE tt_1 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE = innodb;
10 CREATE TABLE tt_2 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE = innodb;
11 CREATE TABLE nt_1 (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 #########################################################################
15 # CHECK IMPLICT COMMIT
16 #########################################################################
17 SET AUTOCOMMIT= 0;
18 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
19 INSERT INTO tt_1(ddl_case) VALUES (31);
20 LOAD INDEX INTO CACHE nt_1 IGNORE LEAVES;
21 Table Op Msg_type Msg_text
22 test.nt_1 preload_keys note The storage engine for the table doesn't support preload_keys
23 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
24 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
25 include/show_binlog_events.inc
26 Log_name Pos Event_type Server_id End_log_pos Info
27 server-binary-log.000001 # Query # # BEGIN
28 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
29 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
30 server-binary-log.000001 # Xid # # COMMIT /* XID */
31 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
32
33 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
34 INSERT INTO tt_1(ddl_case) VALUES (30);
35 LOAD INDEX INTO CACHE tt_1, tt_2 IGNORE LEAVES;
36 Table Op Msg_type Msg_text
37 test.tt_1 preload_keys note The storage engine for the table doesn't support preload_keys
38 test.tt_2 preload_keys note The storage engine for the table doesn't support preload_keys
39 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
40 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
41 include/show_binlog_events.inc
42 Log_name Pos Event_type Server_id End_log_pos Info
43 server-binary-log.000001 # Query # # BEGIN
44 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
45 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
46 server-binary-log.000001 # Xid # # COMMIT /* XID */
47 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
48
49 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
50 INSERT INTO tt_1(ddl_case) VALUES (29);
51 ANALYZE TABLE nt_1;
52 Table Op Msg_type Msg_text
53 test.nt_1 analyze status OK
54 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
55 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
56 include/show_binlog_events.inc
57 Log_name Pos Event_type Server_id End_log_pos Info
58 server-binary-log.000001 # Query # # BEGIN
59 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
60 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
61 server-binary-log.000001 # Xid # # COMMIT /* XID */
62 server-binary-log.000001 # Query # # use `test`; ANALYZE TABLE nt_1
63 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
64
65 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
66 INSERT INTO tt_1(ddl_case) VALUES (28);
67 CHECK TABLE nt_1;
68 Table Op Msg_type Msg_text
69 test.nt_1 check status OK
70 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
71 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
72 include/show_binlog_events.inc
73 Log_name Pos Event_type Server_id End_log_pos Info
74 server-binary-log.000001 # Query # # BEGIN
75 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
76 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
77 server-binary-log.000001 # Xid # # COMMIT /* XID */
78 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
79
80 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
81 INSERT INTO tt_1(ddl_case) VALUES (27);
82 OPTIMIZE TABLE nt_1;
83 Table Op Msg_type Msg_text
84 test.nt_1 optimize note Table does not support optimize, doing recreate + analyze instead
85 test.nt_1 optimize status OK
86 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
87 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
88 include/show_binlog_events.inc
89 Log_name Pos Event_type Server_id End_log_pos Info
90 server-binary-log.000001 # Query # # BEGIN
91 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
92 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
93 server-binary-log.000001 # Xid # # COMMIT /* XID */
94 server-binary-log.000001 # Query # # use `test`; OPTIMIZE TABLE nt_1
95 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
96
97 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
98 INSERT INTO tt_1(ddl_case) VALUES (26);
99 REPAIR TABLE nt_1;
100 Table Op Msg_type Msg_text
101 test.nt_1 repair note The storage engine for the table doesn't support repair
102 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
103 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
104 include/show_binlog_events.inc
105 Log_name Pos Event_type Server_id End_log_pos Info
106 server-binary-log.000001 # Query # # BEGIN
107 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
108 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
109 server-binary-log.000001 # Xid # # COMMIT /* XID */
110 server-binary-log.000001 # Query # # use `test`; REPAIR TABLE nt_1
111 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
112
113 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
114 INSERT INTO tt_1(ddl_case) VALUES (25);
115 LOCK TABLES tt_1 WRITE;
116 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
117 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
118 include/show_binlog_events.inc
119 Log_name Pos Event_type Server_id End_log_pos Info
120 server-binary-log.000001 # Query # # BEGIN
121 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
122 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
123 server-binary-log.000001 # Xid # # COMMIT /* XID */
124 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
125
126 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
127 INSERT INTO tt_1(ddl_case) VALUES (24);
128 UNLOCK TABLES;
129 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
130 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
131 include/show_binlog_events.inc
132 Log_name Pos Event_type Server_id End_log_pos Info
133 server-binary-log.000001 # Query # # BEGIN
134 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
135 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
136 server-binary-log.000001 # Xid # # COMMIT /* XID */
137 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
138
139 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
140 INSERT INTO tt_1(ddl_case) VALUES (23);
141 CREATE USER 'user'@'localhost';
142 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
143 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
144 include/show_binlog_events.inc
145 Log_name Pos Event_type Server_id End_log_pos Info
146 server-binary-log.000001 # Query # # BEGIN
147 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
148 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
149 server-binary-log.000001 # Xid # # COMMIT /* XID */
150 server-binary-log.000001 # Query # # use `test`; CREATE USER 'user'@'localhost' IDENTIFIED WITH 'caching_sha2_password'
151 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
152
153 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
154 INSERT INTO tt_1(ddl_case) VALUES (22);
155 GRANT ALL ON *.* TO 'user'@'localhost';
156 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
157 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
158 include/show_binlog_events.inc
159 Log_name Pos Event_type Server_id End_log_pos Info
160 server-binary-log.000001 # Query # # BEGIN
161 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
162 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
163 server-binary-log.000001 # Xid # # COMMIT /* XID */
164 server-binary-log.000001 # Query # # use `test`; GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost'
165 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
166
167 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
168 INSERT INTO tt_1(ddl_case) VALUES (21);
169 SET PASSWORD FOR 'user'@'localhost' = 'newpass';
170 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
171 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
172 include/show_binlog_events.inc
173 Log_name Pos Event_type Server_id End_log_pos Info
174 server-binary-log.000001 # Query # # BEGIN
175 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
176 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
177 server-binary-log.000001 # Xid # # COMMIT /* XID */
178 server-binary-log.000001 # Query # # use `test`; ALTER USER 'user'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
179 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
180
181 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
182 INSERT INTO tt_1(ddl_case) VALUES (20);
183 REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user'@'localhost';
184 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
185 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
186 include/show_binlog_events.inc
187 Log_name Pos Event_type Server_id End_log_pos Info
188 server-binary-log.000001 # Query # # BEGIN
189 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
190 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
191 server-binary-log.000001 # Xid # # COMMIT /* XID */
192 server-binary-log.000001 # Query # # use `test`; REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user'@'localhost'
193 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
194
195 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
196 INSERT INTO tt_1(ddl_case) VALUES (19);
197 RENAME USER 'user'@'localhost' TO 'user_new'@'localhost';
198 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
199 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
200 include/show_binlog_events.inc
201 Log_name Pos Event_type Server_id End_log_pos Info
202 server-binary-log.000001 # Query # # BEGIN
203 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
204 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
205 server-binary-log.000001 # Xid # # COMMIT /* XID */
206 server-binary-log.000001 # Query # # use `test`; RENAME USER 'user'@'localhost' TO 'user_new'@'localhost'
207 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
208
209 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
210 INSERT INTO tt_1(ddl_case) VALUES (18);
211 DROP USER 'user_new'@'localhost';
212 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
213 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
214 include/show_binlog_events.inc
215 Log_name Pos Event_type Server_id End_log_pos Info
216 server-binary-log.000001 # Query # # BEGIN
217 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
218 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
219 server-binary-log.000001 # Xid # # COMMIT /* XID */
220 server-binary-log.000001 # Query # # use `test`; DROP USER 'user_new'@'localhost'
221 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
222
223 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
224 INSERT INTO tt_1(ddl_case) VALUES (17);
225 CREATE EVENT evt ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO SELECT * FROM tt_1;
226 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
227 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
228 include/show_binlog_events.inc
229 Log_name Pos Event_type Server_id End_log_pos Info
230 server-binary-log.000001 # Query # # BEGIN
231 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
232 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
233 server-binary-log.000001 # Xid # # COMMIT /* XID */
234 server-binary-log.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` EVENT evt ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO SELECT * FROM tt_1
235 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
236
237 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
238 INSERT INTO tt_1(ddl_case) VALUES (16);
239 ALTER EVENT evt COMMENT 'evt';
240 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
241 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
242 include/show_binlog_events.inc
243 Log_name Pos Event_type Server_id End_log_pos Info
244 server-binary-log.000001 # Query # # BEGIN
245 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
246 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
247 server-binary-log.000001 # Xid # # COMMIT /* XID */
248 server-binary-log.000001 # Query # # use `test`; ALTER EVENT evt COMMENT 'evt'
249 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
250
251 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
252 INSERT INTO tt_1(ddl_case) VALUES (15);
253 DROP EVENT evt;
254 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
255 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
256 include/show_binlog_events.inc
257 Log_name Pos Event_type Server_id End_log_pos Info
258 server-binary-log.000001 # Query # # BEGIN
259 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
260 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
261 server-binary-log.000001 # Xid # # COMMIT /* XID */
262 server-binary-log.000001 # Query # # use `test`; DROP EVENT evt
263 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
264
265 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
266 INSERT INTO tt_1(ddl_case) VALUES (14);
267 CREATE FUNCTION fc () RETURNS VARCHAR(64) CHARSET utf8mb4 RETURN "fc";
268 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
269 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
270 include/show_binlog_events.inc
271 Log_name Pos Event_type Server_id End_log_pos Info
272 server-binary-log.000001 # Query # # BEGIN
273 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
274 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
275 server-binary-log.000001 # Xid # # COMMIT /* XID */
276 server-binary-log.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `fc`() RETURNS varchar(64) CHARSET utf8mb4
277 RETURN "fc"
278 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
279
280 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
281 INSERT INTO tt_1(ddl_case) VALUES (13);
282 ALTER FUNCTION fc COMMENT 'fc';
283 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
284 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
285 include/show_binlog_events.inc
286 Log_name Pos Event_type Server_id End_log_pos Info
287 server-binary-log.000001 # Query # # BEGIN
288 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
289 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
290 server-binary-log.000001 # Xid # # COMMIT /* XID */
291 server-binary-log.000001 # Query # # use `test`; ALTER FUNCTION fc COMMENT 'fc'
292 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
293
294 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
295 INSERT INTO tt_1(ddl_case) VALUES (12);
296 DROP FUNCTION fc;
297 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
298 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
299 include/show_binlog_events.inc
300 Log_name Pos Event_type Server_id End_log_pos Info
301 server-binary-log.000001 # Query # # BEGIN
302 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
303 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
304 server-binary-log.000001 # Xid # # COMMIT /* XID */
305 server-binary-log.000001 # Query # # use `test`; DROP FUNCTION fc
306 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
307
308 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
309 INSERT INTO tt_1(ddl_case) VALUES (11);
310 CREATE PROCEDURE pc () UPDATE tt_2 SET ddl_case = ddl_case WHERE ddl_case= NEW.ddl_case;
311 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
312 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
313 include/show_binlog_events.inc
314 Log_name Pos Event_type Server_id End_log_pos Info
315 server-binary-log.000001 # Query # # BEGIN
316 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
317 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
318 server-binary-log.000001 # Xid # # COMMIT /* XID */
319 server-binary-log.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `pc`()
320 UPDATE tt_2 SET ddl_case = ddl_case WHERE ddl_case= NEW.ddl_case
321 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
322
323 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
324 INSERT INTO tt_1(ddl_case) VALUES (10);
325 ALTER PROCEDURE pc COMMENT 'pc';
326 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
327 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
328 include/show_binlog_events.inc
329 Log_name Pos Event_type Server_id End_log_pos Info
330 server-binary-log.000001 # Query # # BEGIN
331 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
332 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
333 server-binary-log.000001 # Xid # # COMMIT /* XID */
334 server-binary-log.000001 # Query # # use `test`; ALTER PROCEDURE pc COMMENT 'pc'
335 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
336
337 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
338 INSERT INTO tt_1(ddl_case) VALUES (9);
339 CREATE VIEW v AS SELECT * FROM tt_1;
340 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
341 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
342 include/show_binlog_events.inc
343 Log_name Pos Event_type Server_id End_log_pos Info
344 server-binary-log.000001 # Query # # BEGIN
345 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
346 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
347 server-binary-log.000001 # Xid # # COMMIT /* XID */
348 server-binary-log.000001 # Query # # use `test`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v` AS SELECT * FROM tt_1
349 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
350
351 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
352 INSERT INTO tt_1(ddl_case) VALUES (8);
353 DROP PROCEDURE pc;
354 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
355 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
356 include/show_binlog_events.inc
357 Log_name Pos Event_type Server_id End_log_pos Info
358 server-binary-log.000001 # Query # # BEGIN
359 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
360 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
361 server-binary-log.000001 # Xid # # COMMIT /* XID */
362 server-binary-log.000001 # Query # # use `test`; DROP PROCEDURE pc
363 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
364
365 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
366 INSERT INTO tt_1(ddl_case) VALUES (7);
367 ALTER VIEW v AS SELECT * FROM tt_1;
368 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
369 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
370 include/show_binlog_events.inc
371 Log_name Pos Event_type Server_id End_log_pos Info
372 server-binary-log.000001 # Query # # BEGIN
373 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
374 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
375 server-binary-log.000001 # Xid # # COMMIT /* XID */
376 server-binary-log.000001 # Query # # use `test`; ALTER ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v` AS SELECT * FROM tt_1
377 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
378
379 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
380 INSERT INTO tt_1(ddl_case) VALUES (6);
381 DROP VIEW v;
382 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
383 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
384 include/show_binlog_events.inc
385 Log_name Pos Event_type Server_id End_log_pos Info
386 server-binary-log.000001 # Query # # BEGIN
387 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
388 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
389 server-binary-log.000001 # Xid # # COMMIT /* XID */
390 server-binary-log.000001 # Query # # use `test`; DROP VIEW v
391 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
392
393 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
394 INSERT INTO tt_1(ddl_case) VALUES (5);
395 CREATE TABLE tt_xx (a int);
396 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
397 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
398 include/show_binlog_events.inc
399 Log_name Pos Event_type Server_id End_log_pos Info
400 server-binary-log.000001 # Query # # BEGIN
401 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
402 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
403 server-binary-log.000001 # Xid # # COMMIT /* XID */
404 server-binary-log.000001 # Query # # use `test`; CREATE TABLE tt_xx (a int)
405 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
406
407 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
408 INSERT INTO tt_1(ddl_case) VALUES (4);
409 RENAME TABLE tt_xx TO new_tt_xx;
410 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
411 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
412 include/show_binlog_events.inc
413 Log_name Pos Event_type Server_id End_log_pos Info
414 server-binary-log.000001 # Query # # BEGIN
415 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
416 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
417 server-binary-log.000001 # Xid # # COMMIT /* XID */
418 server-binary-log.000001 # Query # # use `test`; RENAME TABLE tt_xx TO new_tt_xx
419 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
420
421 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
422 INSERT INTO tt_1(ddl_case) VALUES (3);
423 DROP TABLE IF EXISTS tt_xx, new_tt_xx;
424 Warnings:
425 Note 1051 Unknown table 'test.tt_xx'
426 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
427 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
428 include/show_binlog_events.inc
429 Log_name Pos Event_type Server_id End_log_pos Info
430 server-binary-log.000001 # Query # # BEGIN
431 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
432 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
433 server-binary-log.000001 # Xid # # COMMIT /* XID */
434 server-binary-log.000001 # Query # # use `test`; DROP TABLE IF EXISTS `new_tt_xx`,`tt_xx` /* generated by server */
435 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
436
437 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
438 INSERT INTO tt_1(ddl_case) VALUES (2);
439 CREATE DATABASE db;
440 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
441 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
442 include/show_binlog_events.inc
443 Log_name Pos Event_type Server_id End_log_pos Info
444 server-binary-log.000001 # Query # # BEGIN
445 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
446 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
447 server-binary-log.000001 # Xid # # COMMIT /* XID */
448 server-binary-log.000001 # Query # # CREATE DATABASE db
449 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
450
451 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
452 INSERT INTO tt_1(ddl_case) VALUES (1);
453 DROP DATABASE IF EXISTS db;
454 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
455 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
456 include/show_binlog_events.inc
457 Log_name Pos Event_type Server_id End_log_pos Info
458 server-binary-log.000001 # Query # # BEGIN
459 server-binary-log.000001 # Table_map # # table_id: # (test.tt_1)
460 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
461 server-binary-log.000001 # Xid # # COMMIT /* XID */
462 server-binary-log.000001 # Query # # DROP DATABASE IF EXISTS db
463 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
464
465 ###################################################################################
466 # CHECK CONSISTENCY
467 ###################################################################################
468 include/rpl_sync.inc
469 include/diff_tables.inc [server1:tt_1,server2:tt_1]
470 include/diff_tables.inc [server1:tt_2,server2:tt_2]
471 include/diff_tables.inc [server1:nt_1,server2:nt_1]
472 ###################################################################################
473 # CLEAN
474 ###################################################################################
475 include/rpl_sync.inc
476 include/group_replication_end.inc