Debian Codegraph @

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