Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_row_implicit_commit_binlog.result

raw
1 include/master-slave.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 master]
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 = MyIsam;
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 (43);
20 CREATE FUNCTION myfunc_int RETURNS INTEGER SONAME "UDF_EXAMPLE_LIB";
21 include/assert.inc [There should be a COMMIT event at the specified position (test#43)]
22 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
23 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
24 include/show_binlog_events.inc
25 Log_name Pos Event_type Server_id End_log_pos Info
26 master-bin.000001 # Query # # BEGIN
27 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
28 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
29 master-bin.000001 # Xid # # COMMIT /* XID */
30 master-bin.000001 # Query # # use `test`; CREATE FUNCTION myfunc_int RETURNS INTEGER SONAME "LIB"
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 (42);
35 DROP FUNCTION myfunc_int;
36 include/assert.inc [There should be a COMMIT event at the specified position (test#42)]
37 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
38 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
39 include/show_binlog_events.inc
40 Log_name Pos Event_type Server_id End_log_pos Info
41 master-bin.000001 # Query # # BEGIN
42 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
43 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
44 master-bin.000001 # Xid # # COMMIT /* XID */
45 master-bin.000001 # Query # # use `test`; DROP FUNCTION myfunc_int
46 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
47
48 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
49 INSERT INTO tt_1(ddl_case) VALUES (41);
50 LOAD INDEX INTO CACHE nt_1 IGNORE LEAVES;
51 Table Op Msg_type Msg_text
52 test.nt_1 preload_keys status OK
53 include/assert.inc [There should be a COMMIT event at the specified position (test#41)]
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 master-bin.000001 # Query # # BEGIN
59 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
60 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
61 master-bin.000001 # Xid # # COMMIT /* XID */
62 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
63
64 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
65 INSERT INTO tt_1(ddl_case) VALUES (40);
66 LOAD INDEX INTO CACHE tt_1, tt_2 IGNORE LEAVES;
67 Table Op Msg_type Msg_text
68 test.tt_1 preload_keys note The storage engine for the table doesn't support preload_keys
69 test.tt_2 preload_keys note The storage engine for the table doesn't support preload_keys
70 include/assert.inc [There should be a COMMIT event at the specified position (test#40)]
71 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
72 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
73 include/show_binlog_events.inc
74 Log_name Pos Event_type Server_id End_log_pos Info
75 master-bin.000001 # Query # # BEGIN
76 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
77 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
78 master-bin.000001 # Xid # # COMMIT /* XID */
79 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
80
81 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
82 INSERT INTO tt_1(ddl_case) VALUES (39);
83 ANALYZE TABLE nt_1;
84 Table Op Msg_type Msg_text
85 test.nt_1 analyze status Table is already up to date
86 include/assert.inc [There should be a COMMIT event at the specified position (test#39)]
87 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
88 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
89 include/show_binlog_events.inc
90 Log_name Pos Event_type Server_id End_log_pos Info
91 master-bin.000001 # Query # # BEGIN
92 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
93 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
94 master-bin.000001 # Xid # # COMMIT /* XID */
95 master-bin.000001 # Query # # use `test`; ANALYZE TABLE nt_1
96 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
97
98 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
99 INSERT INTO tt_1(ddl_case) VALUES (38);
100 CHECK TABLE nt_1;
101 Table Op Msg_type Msg_text
102 test.nt_1 check status OK
103 include/assert.inc [There should be a COMMIT event at the specified position (test#38)]
104 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
105 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
106 include/show_binlog_events.inc
107 Log_name Pos Event_type Server_id End_log_pos Info
108 master-bin.000001 # Query # # BEGIN
109 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
110 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
111 master-bin.000001 # Xid # # COMMIT /* XID */
112 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
113
114 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
115 INSERT INTO tt_1(ddl_case) VALUES (37);
116 OPTIMIZE TABLE nt_1;
117 Table Op Msg_type Msg_text
118 test.nt_1 optimize status Table is already up to date
119 include/assert.inc [There should be a COMMIT event at the specified position (test#37)]
120 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
121 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
122 include/show_binlog_events.inc
123 Log_name Pos Event_type Server_id End_log_pos Info
124 master-bin.000001 # Query # # BEGIN
125 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
126 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
127 master-bin.000001 # Xid # # COMMIT /* XID */
128 master-bin.000001 # Query # # use `test`; OPTIMIZE TABLE nt_1
129 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
130
131 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
132 INSERT INTO tt_1(ddl_case) VALUES (36);
133 REPAIR TABLE nt_1;
134 Table Op Msg_type Msg_text
135 test.nt_1 repair status OK
136 include/assert.inc [There should be a COMMIT event at the specified position (test#36)]
137 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
138 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
139 include/show_binlog_events.inc
140 Log_name Pos Event_type Server_id End_log_pos Info
141 master-bin.000001 # Query # # BEGIN
142 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
143 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
144 master-bin.000001 # Xid # # COMMIT /* XID */
145 master-bin.000001 # Query # # use `test`; REPAIR TABLE nt_1
146 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
147
148 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
149 INSERT INTO tt_1(ddl_case) VALUES (35);
150 LOCK TABLES tt_1 WRITE;
151 include/assert.inc [There should be a COMMIT event at the specified position (test#35)]
152 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
153 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
154 include/show_binlog_events.inc
155 Log_name Pos Event_type Server_id End_log_pos Info
156 master-bin.000001 # Query # # BEGIN
157 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
158 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
159 master-bin.000001 # Xid # # COMMIT /* XID */
160 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
161
162 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
163 INSERT INTO tt_1(ddl_case) VALUES (34);
164 UNLOCK TABLES;
165 include/assert.inc [There should be a COMMIT event at the specified position (test#34)]
166 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
167 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
168 include/show_binlog_events.inc
169 Log_name Pos Event_type Server_id End_log_pos Info
170 master-bin.000001 # Query # # BEGIN
171 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
172 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
173 master-bin.000001 # Xid # # COMMIT /* XID */
174 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
175
176 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
177 INSERT INTO tt_1(ddl_case) VALUES (33);
178 CREATE USER 'user'@'localhost';
179 include/assert.inc [There should be a COMMIT event at the specified position (test#33)]
180 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
181 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
182 include/show_binlog_events.inc
183 Log_name Pos Event_type Server_id End_log_pos Info
184 master-bin.000001 # Query # # BEGIN
185 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
186 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
187 master-bin.000001 # Xid # # COMMIT /* XID */
188 master-bin.000001 # Query # # use `test`; CREATE USER 'user'@'localhost' IDENTIFIED WITH 'caching_sha2_password'
189 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
190
191 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
192 INSERT INTO tt_1(ddl_case) VALUES (32);
193 GRANT ALL ON *.* TO 'user'@'localhost';
194 include/assert.inc [There should be a COMMIT event at the specified position (test#32)]
195 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
196 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
197 include/show_binlog_events.inc
198 Log_name Pos Event_type Server_id End_log_pos Info
199 master-bin.000001 # Query # # BEGIN
200 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
201 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
202 master-bin.000001 # Xid # # COMMIT /* XID */
203 master-bin.000001 # Query # # use `test`; GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost'
204 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
205
206 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
207 INSERT INTO tt_1(ddl_case) VALUES (31);
208 SET PASSWORD FOR 'user'@'localhost' = 'newpass';
209 include/assert.inc [There should be a COMMIT event at the specified position (test#31)]
210 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
211 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
212 include/show_binlog_events.inc
213 Log_name Pos Event_type Server_id End_log_pos Info
214 master-bin.000001 # Query # # BEGIN
215 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
216 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
217 master-bin.000001 # Xid # # COMMIT /* XID */
218 master-bin.000001 # Query # # use `test`; ALTER USER 'user'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
219 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
220
221 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
222 INSERT INTO tt_1(ddl_case) VALUES (30);
223 REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user'@'localhost';
224 include/assert.inc [There should be a COMMIT event at the specified position (test#30)]
225 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
226 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
227 include/show_binlog_events.inc
228 Log_name Pos Event_type Server_id End_log_pos Info
229 master-bin.000001 # Query # # BEGIN
230 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
231 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
232 master-bin.000001 # Xid # # COMMIT /* XID */
233 master-bin.000001 # Query # # use `test`; REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user'@'localhost'
234 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
235
236 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
237 INSERT INTO tt_1(ddl_case) VALUES (29);
238 RENAME USER 'user'@'localhost' TO 'user_new'@'localhost';
239 include/assert.inc [There should be a COMMIT event at the specified position (test#29)]
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 master-bin.000001 # Query # # BEGIN
245 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
246 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
247 master-bin.000001 # Xid # # COMMIT /* XID */
248 master-bin.000001 # Query # # use `test`; RENAME USER 'user'@'localhost' TO 'user_new'@'localhost'
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 (28);
253 DROP USER 'user_new'@'localhost';
254 include/assert.inc [There should be a COMMIT event at the specified position (test#28)]
255 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
256 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
257 include/show_binlog_events.inc
258 Log_name Pos Event_type Server_id End_log_pos Info
259 master-bin.000001 # Query # # BEGIN
260 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
261 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
262 master-bin.000001 # Xid # # COMMIT /* XID */
263 master-bin.000001 # Query # # use `test`; DROP USER 'user_new'@'localhost'
264 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
265
266 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
267 INSERT INTO tt_1(ddl_case) VALUES (27);
268 CREATE EVENT evt ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO SELECT * FROM tt_1;
269 include/assert.inc [There should be a COMMIT event at the specified position (test#27)]
270 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
271 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
272 include/show_binlog_events.inc
273 Log_name Pos Event_type Server_id End_log_pos Info
274 master-bin.000001 # Query # # BEGIN
275 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
276 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
277 master-bin.000001 # Xid # # COMMIT /* XID */
278 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` EVENT evt ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO SELECT * FROM tt_1
279 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
280
281 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
282 INSERT INTO tt_1(ddl_case) VALUES (26);
283 ALTER EVENT evt COMMENT 'evt';
284 include/assert.inc [There should be a COMMIT event at the specified position (test#26)]
285 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
286 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
287 include/show_binlog_events.inc
288 Log_name Pos Event_type Server_id End_log_pos Info
289 master-bin.000001 # Query # # BEGIN
290 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
291 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
292 master-bin.000001 # Xid # # COMMIT /* XID */
293 master-bin.000001 # Query # # use `test`; ALTER EVENT evt COMMENT 'evt'
294 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
295
296 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
297 INSERT INTO tt_1(ddl_case) VALUES (25);
298 DROP EVENT evt;
299 include/assert.inc [There should be a COMMIT event at the specified position (test#25)]
300 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
301 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
302 include/show_binlog_events.inc
303 Log_name Pos Event_type Server_id End_log_pos Info
304 master-bin.000001 # Query # # BEGIN
305 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
306 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
307 master-bin.000001 # Xid # # COMMIT /* XID */
308 master-bin.000001 # Query # # use `test`; DROP EVENT evt
309 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
310
311 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
312 INSERT INTO tt_1(ddl_case) VALUES (24);
313 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;
314 include/assert.inc [There should be a COMMIT event at the specified position (test#24)]
315 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
316 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
317 include/show_binlog_events.inc
318 Log_name Pos Event_type Server_id End_log_pos Info
319 master-bin.000001 # Query # # BEGIN
320 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
321 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
322 master-bin.000001 # Xid # # COMMIT /* XID */
323 master-bin.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
324 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
325
326 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
327 INSERT INTO tt_1(ddl_case) VALUES (23);
328 DROP TRIGGER tr;
329 include/assert.inc [There should be a COMMIT event at the specified position (test#23)]
330 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
331 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
332 include/show_binlog_events.inc
333 Log_name Pos Event_type Server_id End_log_pos Info
334 master-bin.000001 # Query # # BEGIN
335 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
336 master-bin.000001 # Table_map # # table_id: # (test.tt_2)
337 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
338 master-bin.000001 # Xid # # COMMIT /* XID */
339 master-bin.000001 # Query # # use `test`; DROP TRIGGER tr
340 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
341
342 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
343 INSERT INTO tt_1(ddl_case) VALUES (22);
344 CREATE FUNCTION fc () RETURNS VARCHAR(64) RETURN "fc";
345 include/assert.inc [There should be a COMMIT event at the specified position (test#22)]
346 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
347 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
348 include/show_binlog_events.inc
349 Log_name Pos Event_type Server_id End_log_pos Info
350 master-bin.000001 # Query # # BEGIN
351 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
352 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
353 master-bin.000001 # Xid # # COMMIT /* XID */
354 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `fc`() RETURNS varchar(64) CHARSET utf8mb4
355 RETURN "fc"
356 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
357
358 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
359 INSERT INTO tt_1(ddl_case) VALUES (21);
360 ALTER FUNCTION fc COMMENT 'fc';
361 include/assert.inc [There should be a COMMIT event at the specified position (test#21)]
362 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
363 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
364 include/show_binlog_events.inc
365 Log_name Pos Event_type Server_id End_log_pos Info
366 master-bin.000001 # Query # # BEGIN
367 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
368 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
369 master-bin.000001 # Xid # # COMMIT /* XID */
370 master-bin.000001 # Query # # use `test`; ALTER FUNCTION fc COMMENT 'fc'
371 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
372
373 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
374 INSERT INTO tt_1(ddl_case) VALUES (20);
375 DROP FUNCTION fc;
376 include/assert.inc [There should be a COMMIT event at the specified position (test#20)]
377 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
378 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
379 include/show_binlog_events.inc
380 Log_name Pos Event_type Server_id End_log_pos Info
381 master-bin.000001 # Query # # BEGIN
382 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
383 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
384 master-bin.000001 # Xid # # COMMIT /* XID */
385 master-bin.000001 # Query # # use `test`; DROP FUNCTION fc
386 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
387
388 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
389 INSERT INTO tt_1(ddl_case) VALUES (19);
390 CREATE PROCEDURE pc () UPDATE tt_2 SET ddl_case = ddl_case WHERE ddl_case= NEW.ddl_case;
391 include/assert.inc [There should be a COMMIT event at the specified position (test#19)]
392 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
393 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
394 include/show_binlog_events.inc
395 Log_name Pos Event_type Server_id End_log_pos Info
396 master-bin.000001 # Query # # BEGIN
397 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
398 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
399 master-bin.000001 # Xid # # COMMIT /* XID */
400 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `pc`()
401 UPDATE tt_2 SET ddl_case = ddl_case WHERE ddl_case= NEW.ddl_case
402 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
403
404 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
405 INSERT INTO tt_1(ddl_case) VALUES (18);
406 ALTER PROCEDURE pc COMMENT 'pc';
407 include/assert.inc [There should be a COMMIT event at the specified position (test#18)]
408 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
409 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
410 include/show_binlog_events.inc
411 Log_name Pos Event_type Server_id End_log_pos Info
412 master-bin.000001 # Query # # BEGIN
413 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
414 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
415 master-bin.000001 # Xid # # COMMIT /* XID */
416 master-bin.000001 # Query # # use `test`; ALTER PROCEDURE pc COMMENT 'pc'
417 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
418
419 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
420 INSERT INTO tt_1(ddl_case) VALUES (17);
421 DROP PROCEDURE pc;
422 include/assert.inc [There should be a COMMIT event at the specified position (test#17)]
423 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
424 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
425 include/show_binlog_events.inc
426 Log_name Pos Event_type Server_id End_log_pos Info
427 master-bin.000001 # Query # # BEGIN
428 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
429 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
430 master-bin.000001 # Xid # # COMMIT /* XID */
431 master-bin.000001 # Query # # use `test`; DROP PROCEDURE pc
432 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
433
434 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
435 INSERT INTO tt_1(ddl_case) VALUES (16);
436 CREATE VIEW v AS SELECT * FROM tt_1;
437 include/assert.inc [There should be a COMMIT event at the specified position (test#16)]
438 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
439 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
440 include/show_binlog_events.inc
441 Log_name Pos Event_type Server_id End_log_pos Info
442 master-bin.000001 # Query # # BEGIN
443 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
444 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
445 master-bin.000001 # Xid # # COMMIT /* XID */
446 master-bin.000001 # Query # # use `test`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v` AS SELECT * FROM tt_1
447 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
448
449 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
450 INSERT INTO tt_1(ddl_case) VALUES (15);
451 ALTER VIEW v AS SELECT * FROM tt_1;
452 include/assert.inc [There should be a COMMIT event at the specified position (test#15)]
453 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
454 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
455 include/show_binlog_events.inc
456 Log_name Pos Event_type Server_id End_log_pos Info
457 master-bin.000001 # Query # # BEGIN
458 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
459 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
460 master-bin.000001 # Xid # # COMMIT /* XID */
461 master-bin.000001 # Query # # use `test`; ALTER ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v` AS SELECT * FROM tt_1
462 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
463
464 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
465 INSERT INTO tt_1(ddl_case) VALUES (14);
466 DROP VIEW v;
467 include/assert.inc [There should be a COMMIT event at the specified position (test#14)]
468 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
469 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
470 include/show_binlog_events.inc
471 Log_name Pos Event_type Server_id End_log_pos Info
472 master-bin.000001 # Query # # BEGIN
473 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
474 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
475 master-bin.000001 # Xid # # COMMIT /* XID */
476 master-bin.000001 # Query # # use `test`; DROP VIEW v
477 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
478
479 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
480 INSERT INTO tt_1(ddl_case) VALUES (13);
481 CREATE INDEX ix ON tt_1(ddl_case);
482 include/assert.inc [There should be a COMMIT event at the specified position (test#13)]
483 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
484 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
485 include/show_binlog_events.inc
486 Log_name Pos Event_type Server_id End_log_pos Info
487 master-bin.000001 # Query # # BEGIN
488 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
489 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
490 master-bin.000001 # Xid # # COMMIT /* XID */
491 master-bin.000001 # Query # # use `test`; CREATE INDEX ix ON tt_1(ddl_case)
492 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
493
494 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
495 INSERT INTO tt_1(ddl_case) VALUES (12);
496 DROP INDEX ix ON tt_1;
497 include/assert.inc [There should be a COMMIT event at the specified position (test#12)]
498 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
499 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
500 include/show_binlog_events.inc
501 Log_name Pos Event_type Server_id End_log_pos Info
502 master-bin.000001 # Query # # BEGIN
503 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
504 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
505 master-bin.000001 # Xid # # COMMIT /* XID */
506 master-bin.000001 # Query # # use `test`; DROP INDEX ix ON tt_1
507 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
508
509 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
510 INSERT INTO tt_1(ddl_case) VALUES (11);
511 CREATE TEMPORARY TABLE tt_xx (a int);
512 include/assert.inc [There should be a COMMIT event at the specified position (test#11)]
513 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
514 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
515 include/show_binlog_events.inc
516 Log_name Pos Event_type Server_id End_log_pos Info
517 master-bin.000001 # Query # # BEGIN
518 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
519 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
520 master-bin.000001 # Xid # # COMMIT /* XID */
521 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
522
523 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
524 INSERT INTO tt_1(ddl_case) VALUES (10);
525 ALTER TABLE tt_xx ADD COLUMN (b int);
526 include/assert.inc [There should be a COMMIT event at the specified position (test#10)]
527 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
528 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
529 include/show_binlog_events.inc
530 Log_name Pos Event_type Server_id End_log_pos Info
531 master-bin.000001 # Query # # BEGIN
532 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
533 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
534 master-bin.000001 # Xid # # COMMIT /* XID */
535 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
536
537 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
538 INSERT INTO tt_1(ddl_case) VALUES (9);
539 ALTER TABLE tt_xx RENAME new_tt_xx;
540 include/assert.inc [There should be a COMMIT event at the specified position (test#9)]
541 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
542 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
543 include/show_binlog_events.inc
544 Log_name Pos Event_type Server_id End_log_pos Info
545 master-bin.000001 # Query # # BEGIN
546 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
547 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
548 master-bin.000001 # Xid # # COMMIT /* XID */
549 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
550
551 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
552 INSERT INTO tt_1(ddl_case) VALUES (8);
553 DROP TEMPORARY TABLE IF EXISTS new_tt_xx;
554 include/assert.inc [There should be a COMMIT event at the specified position (test#8)]
555 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
556 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
557 include/show_binlog_events.inc
558 Log_name Pos Event_type Server_id End_log_pos Info
559 master-bin.000001 # Query # # BEGIN
560 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
561 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
562 master-bin.000001 # Xid # # COMMIT /* XID */
563 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
564
565 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
566 INSERT INTO tt_1(ddl_case) VALUES (7);
567 CREATE TABLE tt_xx (a int);
568 include/assert.inc [There should be a COMMIT event at the specified position (test#7)]
569 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
570 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
571 include/show_binlog_events.inc
572 Log_name Pos Event_type Server_id End_log_pos Info
573 master-bin.000001 # Query # # BEGIN
574 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
575 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
576 master-bin.000001 # Xid # # COMMIT /* XID */
577 master-bin.000001 # Query # # use `test`; CREATE TABLE tt_xx (a int)
578 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
579
580 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
581 INSERT INTO tt_1(ddl_case) VALUES (6);
582 ALTER TABLE tt_xx ADD COLUMN (b int);
583 include/assert.inc [There should be a COMMIT event at the specified position (test#6)]
584 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
585 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
586 include/show_binlog_events.inc
587 Log_name Pos Event_type Server_id End_log_pos Info
588 master-bin.000001 # Query # # BEGIN
589 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
590 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
591 master-bin.000001 # Xid # # COMMIT /* XID */
592 master-bin.000001 # Query # # use `test`; ALTER TABLE tt_xx ADD COLUMN (b int)
593 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
594
595 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
596 INSERT INTO tt_1(ddl_case) VALUES (5);
597 RENAME TABLE tt_xx TO new_tt_xx;
598 include/assert.inc [There should be a COMMIT event at the specified position (test#5)]
599 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
600 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
601 include/show_binlog_events.inc
602 Log_name Pos Event_type Server_id End_log_pos Info
603 master-bin.000001 # Query # # BEGIN
604 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
605 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
606 master-bin.000001 # Xid # # COMMIT /* XID */
607 master-bin.000001 # Query # # use `test`; RENAME TABLE tt_xx TO new_tt_xx
608 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
609
610 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
611 INSERT INTO tt_1(ddl_case) VALUES (4);
612 TRUNCATE TABLE new_tt_xx;
613 include/assert.inc [There should be a COMMIT event at the specified position (test#4)]
614 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
615 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
616 include/show_binlog_events.inc
617 Log_name Pos Event_type Server_id End_log_pos Info
618 master-bin.000001 # Query # # BEGIN
619 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
620 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
621 master-bin.000001 # Xid # # COMMIT /* XID */
622 master-bin.000001 # Query # # use `test`; TRUNCATE TABLE new_tt_xx
623 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
624
625 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
626 INSERT INTO tt_1(ddl_case) VALUES (3);
627 DROP TABLE IF EXISTS tt_xx, new_tt_xx;
628 Warnings:
629 Note 1051 Unknown table 'test.tt_xx'
630 include/assert.inc [There should be a COMMIT event at the specified position (test#3)]
631 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
632 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
633 include/show_binlog_events.inc
634 Log_name Pos Event_type Server_id End_log_pos Info
635 master-bin.000001 # Query # # BEGIN
636 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
637 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
638 master-bin.000001 # Xid # # COMMIT /* XID */
639 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `new_tt_xx`,`tt_xx` /* generated by server */
640 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
641
642 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
643 INSERT INTO tt_1(ddl_case) VALUES (2);
644 CREATE DATABASE db;
645 include/assert.inc [There should be a COMMIT event at the specified position (test#2)]
646 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
647 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
648 include/show_binlog_events.inc
649 Log_name Pos Event_type Server_id End_log_pos Info
650 master-bin.000001 # Query # # BEGIN
651 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
652 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
653 master-bin.000001 # Xid # # COMMIT /* XID */
654 master-bin.000001 # Query # # CREATE DATABASE db
655 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
656
657 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
658 INSERT INTO tt_1(ddl_case) VALUES (1);
659 DROP DATABASE IF EXISTS db;
660 include/assert.inc [There should be a COMMIT event at the specified position (test#1)]
661 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
662 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
663 include/show_binlog_events.inc
664 Log_name Pos Event_type Server_id End_log_pos Info
665 master-bin.000001 # Query # # BEGIN
666 master-bin.000001 # Table_map # # table_id: # (test.tt_1)
667 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
668 master-bin.000001 # Xid # # COMMIT /* XID */
669 master-bin.000001 # Query # # DROP DATABASE IF EXISTS db
670 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
671
672 ###################################################################################
673 # CHECK CONSISTENCY
674 ###################################################################################
675 include/sync_slave_sql_with_master.inc
676 include/diff_tables.inc [master:tt_1,slave:tt_1]
677 ###################################################################################
678 # CLEAN
679 ###################################################################################
680 include/sync_slave_sql_with_master.inc
681 include/rpl_end.inc