Debian Codegraph @

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

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