Debian Codegraph @

mysql-test/suite/binlog/r/binlog_implicit_commit.result

raw
1 CREATE TABLE t1 (id INT) ENGINE = InnoDB;
2 SET BINLOG_FORMAT = STATEMENT;
3 RESET MASTER;
4 SET AUTOCOMMIT = 0;
5 INSERT INTO t1 VALUES (1);
6 include/show_binlog_events.inc
7 SET AUTOCOMMIT = 1;
8 include/show_binlog_events.inc
9 Log_name Pos Event_type Server_id End_log_pos Info
10 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
11 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1)
12 master-bin.000001 # Xid # # COMMIT /* XID */
13 COMMIT;
14 RESET MASTER;
15 SET AUTOCOMMIT = 0;
16 BEGIN;
17 INSERT INTO t1 VALUES (2);
18 include/show_binlog_events.inc
19 SET AUTOCOMMIT = 1;
20 include/show_binlog_events.inc
21 Log_name Pos Event_type Server_id End_log_pos Info
22 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
23 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2)
24 master-bin.000001 # Xid # # COMMIT /* XID */
25 INSERT INTO t1 VALUES (3);
26 include/show_binlog_events.inc
27 Log_name Pos Event_type Server_id End_log_pos Info
28 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
29 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2)
30 master-bin.000001 # Xid # # COMMIT /* XID */
31 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
32 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3)
33 master-bin.000001 # Xid # # COMMIT /* XID */
34 COMMIT;
35 include/show_binlog_events.inc
36 Log_name Pos Event_type Server_id End_log_pos Info
37 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
38 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2)
39 master-bin.000001 # Xid # # COMMIT /* XID */
40 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
41 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3)
42 master-bin.000001 # Xid # # COMMIT /* XID */
43 COMMIT;
44 RESET MASTER;
45 SET AUTOCOMMIT = 1;
46 INSERT INTO t1 VALUES (1);
47 include/show_binlog_events.inc
48 Log_name Pos Event_type Server_id End_log_pos Info
49 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
50 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1)
51 master-bin.000001 # Xid # # COMMIT /* XID */
52 SET AUTOCOMMIT = 1;
53 include/show_binlog_events.inc
54 Log_name Pos Event_type Server_id End_log_pos Info
55 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
56 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1)
57 master-bin.000001 # Xid # # COMMIT /* XID */
58 COMMIT;
59 RESET MASTER;
60 SET AUTOCOMMIT = 1;
61 BEGIN;
62 INSERT INTO t1 VALUES (2);
63 include/show_binlog_events.inc
64 SET AUTOCOMMIT = 1;
65 include/show_binlog_events.inc
66 INSERT INTO t1 VALUES (3);
67 include/show_binlog_events.inc
68 COMMIT;
69 include/show_binlog_events.inc
70 Log_name Pos Event_type Server_id End_log_pos Info
71 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
72 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2)
73 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3)
74 master-bin.000001 # Xid # # COMMIT /* XID */
75 COMMIT;
76 RESET MASTER;
77 SET AUTOCOMMIT = 0;
78 INSERT INTO t1 VALUES (1);
79 include/show_binlog_events.inc
80 SET AUTOCOMMIT = 0;
81 include/show_binlog_events.inc
82 COMMIT;
83 RESET MASTER;
84 SET AUTOCOMMIT = 0;
85 BEGIN;
86 INSERT INTO t1 VALUES (2);
87 include/show_binlog_events.inc
88 SET AUTOCOMMIT = 0;
89 include/show_binlog_events.inc
90 INSERT INTO t1 VALUES (3);
91 include/show_binlog_events.inc
92 COMMIT;
93 include/show_binlog_events.inc
94 Log_name Pos Event_type Server_id End_log_pos Info
95 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
96 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2)
97 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3)
98 master-bin.000001 # Xid # # COMMIT /* XID */
99 COMMIT;
100 RESET MASTER;
101 SET AUTOCOMMIT = 1;
102 INSERT INTO t1 VALUES (1);
103 include/show_binlog_events.inc
104 Log_name Pos Event_type Server_id End_log_pos Info
105 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
106 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1)
107 master-bin.000001 # Xid # # COMMIT /* XID */
108 SET AUTOCOMMIT = 0;
109 include/show_binlog_events.inc
110 Log_name Pos Event_type Server_id End_log_pos Info
111 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
112 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1)
113 master-bin.000001 # Xid # # COMMIT /* XID */
114 COMMIT;
115 RESET MASTER;
116 SET AUTOCOMMIT = 1;
117 BEGIN;
118 INSERT INTO t1 VALUES (2);
119 include/show_binlog_events.inc
120 SET AUTOCOMMIT = 0;
121 include/show_binlog_events.inc
122 INSERT INTO t1 VALUES (3);
123 include/show_binlog_events.inc
124 COMMIT;
125 include/show_binlog_events.inc
126 Log_name Pos Event_type Server_id End_log_pos Info
127 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
128 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2)
129 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3)
130 master-bin.000001 # Xid # # COMMIT /* XID */
131 COMMIT;
132 SET BINLOG_FORMAT = ROW;
133 RESET MASTER;
134 SET AUTOCOMMIT = 0;
135 INSERT INTO t1 VALUES (1);
136 include/show_binlog_events.inc
137 SET AUTOCOMMIT = 1;
138 include/show_binlog_events.inc
139 Log_name Pos Event_type Server_id End_log_pos Info
140 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
141 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
142 master-bin.000001 # Table_map # # table_id: # (test.t1)
143 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
144 master-bin.000001 # Xid # # COMMIT /* XID */
145 COMMIT;
146 RESET MASTER;
147 SET AUTOCOMMIT = 0;
148 BEGIN;
149 INSERT INTO t1 VALUES (2);
150 include/show_binlog_events.inc
151 SET AUTOCOMMIT = 1;
152 include/show_binlog_events.inc
153 Log_name Pos Event_type Server_id End_log_pos Info
154 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
155 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (2)
156 master-bin.000001 # Table_map # # table_id: # (test.t1)
157 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
158 master-bin.000001 # Xid # # COMMIT /* XID */
159 INSERT INTO t1 VALUES (3);
160 include/show_binlog_events.inc
161 Log_name Pos Event_type Server_id End_log_pos Info
162 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
163 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (2)
164 master-bin.000001 # Table_map # # table_id: # (test.t1)
165 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
166 master-bin.000001 # Xid # # COMMIT /* XID */
167 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
168 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (3)
169 master-bin.000001 # Table_map # # table_id: # (test.t1)
170 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
171 master-bin.000001 # Xid # # COMMIT /* XID */
172 COMMIT;
173 include/show_binlog_events.inc
174 Log_name Pos Event_type Server_id End_log_pos Info
175 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
176 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (2)
177 master-bin.000001 # Table_map # # table_id: # (test.t1)
178 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
179 master-bin.000001 # Xid # # COMMIT /* XID */
180 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
181 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (3)
182 master-bin.000001 # Table_map # # table_id: # (test.t1)
183 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
184 master-bin.000001 # Xid # # COMMIT /* XID */
185 COMMIT;
186 RESET MASTER;
187 SET AUTOCOMMIT = 1;
188 INSERT INTO t1 VALUES (1);
189 include/show_binlog_events.inc
190 Log_name Pos Event_type Server_id End_log_pos Info
191 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
192 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
193 master-bin.000001 # Table_map # # table_id: # (test.t1)
194 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
195 master-bin.000001 # Xid # # COMMIT /* XID */
196 SET AUTOCOMMIT = 1;
197 include/show_binlog_events.inc
198 Log_name Pos Event_type Server_id End_log_pos Info
199 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
200 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
201 master-bin.000001 # Table_map # # table_id: # (test.t1)
202 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
203 master-bin.000001 # Xid # # COMMIT /* XID */
204 COMMIT;
205 RESET MASTER;
206 SET AUTOCOMMIT = 1;
207 BEGIN;
208 INSERT INTO t1 VALUES (2);
209 include/show_binlog_events.inc
210 SET AUTOCOMMIT = 1;
211 include/show_binlog_events.inc
212 INSERT INTO t1 VALUES (3);
213 include/show_binlog_events.inc
214 COMMIT;
215 include/show_binlog_events.inc
216 Log_name Pos Event_type Server_id End_log_pos Info
217 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
218 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (2)
219 master-bin.000001 # Table_map # # table_id: # (test.t1)
220 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
221 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (3)
222 master-bin.000001 # Table_map # # table_id: # (test.t1)
223 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
224 master-bin.000001 # Xid # # COMMIT /* XID */
225 COMMIT;
226 RESET MASTER;
227 SET AUTOCOMMIT = 0;
228 INSERT INTO t1 VALUES (1);
229 include/show_binlog_events.inc
230 SET AUTOCOMMIT = 0;
231 include/show_binlog_events.inc
232 COMMIT;
233 RESET MASTER;
234 SET AUTOCOMMIT = 0;
235 BEGIN;
236 INSERT INTO t1 VALUES (2);
237 include/show_binlog_events.inc
238 SET AUTOCOMMIT = 0;
239 include/show_binlog_events.inc
240 INSERT INTO t1 VALUES (3);
241 include/show_binlog_events.inc
242 COMMIT;
243 include/show_binlog_events.inc
244 Log_name Pos Event_type Server_id End_log_pos Info
245 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
246 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (2)
247 master-bin.000001 # Table_map # # table_id: # (test.t1)
248 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
249 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (3)
250 master-bin.000001 # Table_map # # table_id: # (test.t1)
251 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
252 master-bin.000001 # Xid # # COMMIT /* XID */
253 COMMIT;
254 RESET MASTER;
255 SET AUTOCOMMIT = 1;
256 INSERT INTO t1 VALUES (1);
257 include/show_binlog_events.inc
258 Log_name Pos Event_type Server_id End_log_pos Info
259 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
260 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
261 master-bin.000001 # Table_map # # table_id: # (test.t1)
262 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
263 master-bin.000001 # Xid # # COMMIT /* XID */
264 SET AUTOCOMMIT = 0;
265 include/show_binlog_events.inc
266 Log_name Pos Event_type Server_id End_log_pos Info
267 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
268 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
269 master-bin.000001 # Table_map # # table_id: # (test.t1)
270 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
271 master-bin.000001 # Xid # # COMMIT /* XID */
272 COMMIT;
273 RESET MASTER;
274 SET AUTOCOMMIT = 1;
275 BEGIN;
276 INSERT INTO t1 VALUES (2);
277 include/show_binlog_events.inc
278 SET AUTOCOMMIT = 0;
279 include/show_binlog_events.inc
280 INSERT INTO t1 VALUES (3);
281 include/show_binlog_events.inc
282 COMMIT;
283 include/show_binlog_events.inc
284 Log_name Pos Event_type Server_id End_log_pos Info
285 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
286 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (2)
287 master-bin.000001 # Table_map # # table_id: # (test.t1)
288 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
289 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (3)
290 master-bin.000001 # Table_map # # table_id: # (test.t1)
291 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
292 master-bin.000001 # Xid # # COMMIT /* XID */
293 COMMIT;
294 RESET MASTER;
295 SET AUTOCOMMIT = 0;
296 INSERT INTO t1 VALUES (1);
297 include/show_binlog_events.inc
298 LOCK TABLES t1 WRITE;
299 include/show_binlog_events.inc
300 Log_name Pos Event_type Server_id End_log_pos Info
301 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
302 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
303 master-bin.000001 # Table_map # # table_id: # (test.t1)
304 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
305 master-bin.000001 # Xid # # COMMIT /* XID */
306 INSERT INTO t1 VALUES (2);
307 include/show_binlog_events.inc
308 Log_name Pos Event_type Server_id End_log_pos Info
309 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
310 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
311 master-bin.000001 # Table_map # # table_id: # (test.t1)
312 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
313 master-bin.000001 # Xid # # COMMIT /* XID */
314 UNLOCK TABLES;
315 include/show_binlog_events.inc
316 Log_name Pos Event_type Server_id End_log_pos Info
317 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
318 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
319 master-bin.000001 # Table_map # # table_id: # (test.t1)
320 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
321 master-bin.000001 # Xid # # COMMIT /* XID */
322 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
323 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (2)
324 master-bin.000001 # Table_map # # table_id: # (test.t1)
325 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
326 master-bin.000001 # Xid # # COMMIT /* XID */
327 COMMIT;
328 include/show_binlog_events.inc
329 Log_name Pos Event_type Server_id End_log_pos Info
330 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
331 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
332 master-bin.000001 # Table_map # # table_id: # (test.t1)
333 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
334 master-bin.000001 # Xid # # COMMIT /* XID */
335 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
336 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (2)
337 master-bin.000001 # Table_map # # table_id: # (test.t1)
338 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
339 master-bin.000001 # Xid # # COMMIT /* XID */
340 DROP TABLE t1;