Debian Codegraph @

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

raw
1 SELECT @@session.binlog_row_image INTO @saved_binlog_row_image;
2 SET binlog_row_image= MINIMAL;
3 SHOW VARIABLES LIKE 'binlog_row_image';
4 Variable_name Value
5 binlog_row_image MINIMAL
6 RESET MASTER;
7 CREATE TABLE t1(a INT PRIMARY KEY, data VARCHAR(100)) ENGINE=Innodb;
8 INSERT INTO t1 VALUES (1,'a'), (2,'b'), (3, 'c');
9 DELETE FROM t1;
10 include/show_binlog_events.inc
11 Log_name Pos Event_type Server_id End_log_pos Info
12 binlog.000001 # Query # # use `test`; CREATE TABLE t1(a INT PRIMARY KEY, data VARCHAR(100)) ENGINE=Innodb
13 binlog.000001 # Query # # BEGIN
14 binlog.000001 # Table_map # # table_id: # (test.t1)
15 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
16 binlog.000001 # Xid # # COMMIT /* XID */
17 binlog.000001 # Query # # BEGIN
18 binlog.000001 # Table_map # # table_id: # (test.t1)
19 binlog.000001 # Delete_rows # # table_id: # flags: STMT_END_F
20 binlog.000001 # Xid # # COMMIT /* XID */
21 DROP TABLE t1;
22 SET binlog_row_image= @saved_binlog_row_image;
23 RESET MASTER;
24 create table t1 (a int) engine=innodb;
25 create table t2 (a int) engine=innodb;
26 begin;
27 insert t1 values (5);
28 commit;
29 begin;
30 insert t2 values (5);
31 commit;
32 include/show_binlog_events.inc
33 Log_name Pos Event_type Server_id End_log_pos Info
34 binlog.000001 # Query # # use `test`; create table t1 (a int) engine=innodb
35 binlog.000001 # Query # # use `test`; create table t2 (a int) engine=innodb
36 binlog.000001 # Query # # BEGIN
37 binlog.000001 # Table_map # # table_id: # (test.t1)
38 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
39 binlog.000001 # Xid # # COMMIT /* XID */
40 binlog.000001 # Query # # BEGIN
41 binlog.000001 # Table_map # # table_id: # (test.t2)
42 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
43 binlog.000001 # Xid # # COMMIT /* XID */
44 drop table t1,t2;
45 reset master;
46 create table t1 (n int) engine=innodb;
47 begin;
48 commit;
49 drop table t1;
50 include/show_binlog_events.inc
51 Log_name Pos Event_type Server_id End_log_pos Info
52 binlog.000001 # Query # # use `test`; create table t1 (n int) engine=innodb
53 binlog.000001 # Query # # BEGIN
54 binlog.000001 # Table_map # # table_id: # (test.t1)
55 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
56 binlog.000001 # Table_map # # table_id: # (test.t1)
57 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
58 binlog.000001 # Table_map # # table_id: # (test.t1)
59 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
60 binlog.000001 # Table_map # # table_id: # (test.t1)
61 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
62 binlog.000001 # Table_map # # table_id: # (test.t1)
63 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
64 binlog.000001 # Table_map # # table_id: # (test.t1)
65 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
66 binlog.000001 # Table_map # # table_id: # (test.t1)
67 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
68 binlog.000001 # Table_map # # table_id: # (test.t1)
69 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
70 binlog.000001 # Table_map # # table_id: # (test.t1)
71 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
72 binlog.000001 # Table_map # # table_id: # (test.t1)
73 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
74 binlog.000001 # Table_map # # table_id: # (test.t1)
75 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
76 binlog.000001 # Table_map # # table_id: # (test.t1)
77 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
78 binlog.000001 # Table_map # # table_id: # (test.t1)
79 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
80 binlog.000001 # Table_map # # table_id: # (test.t1)
81 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
82 binlog.000001 # Table_map # # table_id: # (test.t1)
83 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
84 binlog.000001 # Table_map # # table_id: # (test.t1)
85 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
86 binlog.000001 # Table_map # # table_id: # (test.t1)
87 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
88 binlog.000001 # Table_map # # table_id: # (test.t1)
89 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
90 binlog.000001 # Table_map # # table_id: # (test.t1)
91 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
92 binlog.000001 # Table_map # # table_id: # (test.t1)
93 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
94 binlog.000001 # Table_map # # table_id: # (test.t1)
95 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
96 binlog.000001 # Table_map # # table_id: # (test.t1)
97 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
98 binlog.000001 # Table_map # # table_id: # (test.t1)
99 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
100 binlog.000001 # Table_map # # table_id: # (test.t1)
101 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
102 binlog.000001 # Table_map # # table_id: # (test.t1)
103 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
104 binlog.000001 # Table_map # # table_id: # (test.t1)
105 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
106 binlog.000001 # Table_map # # table_id: # (test.t1)
107 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
108 binlog.000001 # Table_map # # table_id: # (test.t1)
109 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
110 binlog.000001 # Table_map # # table_id: # (test.t1)
111 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
112 binlog.000001 # Table_map # # table_id: # (test.t1)
113 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
114 binlog.000001 # Table_map # # table_id: # (test.t1)
115 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
116 binlog.000001 # Table_map # # table_id: # (test.t1)
117 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
118 binlog.000001 # Table_map # # table_id: # (test.t1)
119 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
120 binlog.000001 # Table_map # # table_id: # (test.t1)
121 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
122 binlog.000001 # Table_map # # table_id: # (test.t1)
123 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
124 binlog.000001 # Table_map # # table_id: # (test.t1)
125 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
126 binlog.000001 # Table_map # # table_id: # (test.t1)
127 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
128 binlog.000001 # Table_map # # table_id: # (test.t1)
129 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
130 binlog.000001 # Table_map # # table_id: # (test.t1)
131 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
132 binlog.000001 # Table_map # # table_id: # (test.t1)
133 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
134 binlog.000001 # Table_map # # table_id: # (test.t1)
135 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
136 binlog.000001 # Table_map # # table_id: # (test.t1)
137 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
138 binlog.000001 # Table_map # # table_id: # (test.t1)
139 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
140 binlog.000001 # Table_map # # table_id: # (test.t1)
141 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
142 binlog.000001 # Table_map # # table_id: # (test.t1)
143 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
144 binlog.000001 # Table_map # # table_id: # (test.t1)
145 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
146 binlog.000001 # Table_map # # table_id: # (test.t1)
147 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
148 binlog.000001 # Table_map # # table_id: # (test.t1)
149 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
150 binlog.000001 # Table_map # # table_id: # (test.t1)
151 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
152 binlog.000001 # Table_map # # table_id: # (test.t1)
153 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
154 binlog.000001 # Table_map # # table_id: # (test.t1)
155 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
156 binlog.000001 # Table_map # # table_id: # (test.t1)
157 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
158 binlog.000001 # Table_map # # table_id: # (test.t1)
159 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
160 binlog.000001 # Table_map # # table_id: # (test.t1)
161 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
162 binlog.000001 # Table_map # # table_id: # (test.t1)
163 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
164 binlog.000001 # Table_map # # table_id: # (test.t1)
165 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
166 binlog.000001 # Table_map # # table_id: # (test.t1)
167 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
168 binlog.000001 # Table_map # # table_id: # (test.t1)
169 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
170 binlog.000001 # Table_map # # table_id: # (test.t1)
171 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
172 binlog.000001 # Table_map # # table_id: # (test.t1)
173 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
174 binlog.000001 # Table_map # # table_id: # (test.t1)
175 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
176 binlog.000001 # Table_map # # table_id: # (test.t1)
177 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
178 binlog.000001 # Table_map # # table_id: # (test.t1)
179 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
180 binlog.000001 # Table_map # # table_id: # (test.t1)
181 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
182 binlog.000001 # Table_map # # table_id: # (test.t1)
183 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
184 binlog.000001 # Table_map # # table_id: # (test.t1)
185 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
186 binlog.000001 # Table_map # # table_id: # (test.t1)
187 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
188 binlog.000001 # Table_map # # table_id: # (test.t1)
189 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
190 binlog.000001 # Table_map # # table_id: # (test.t1)
191 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
192 binlog.000001 # Table_map # # table_id: # (test.t1)
193 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
194 binlog.000001 # Table_map # # table_id: # (test.t1)
195 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
196 binlog.000001 # Table_map # # table_id: # (test.t1)
197 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
198 binlog.000001 # Table_map # # table_id: # (test.t1)
199 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
200 binlog.000001 # Table_map # # table_id: # (test.t1)
201 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
202 binlog.000001 # Table_map # # table_id: # (test.t1)
203 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
204 binlog.000001 # Table_map # # table_id: # (test.t1)
205 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
206 binlog.000001 # Table_map # # table_id: # (test.t1)
207 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
208 binlog.000001 # Table_map # # table_id: # (test.t1)
209 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
210 binlog.000001 # Table_map # # table_id: # (test.t1)
211 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
212 binlog.000001 # Table_map # # table_id: # (test.t1)
213 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
214 binlog.000001 # Table_map # # table_id: # (test.t1)
215 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
216 binlog.000001 # Table_map # # table_id: # (test.t1)
217 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
218 binlog.000001 # Table_map # # table_id: # (test.t1)
219 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
220 binlog.000001 # Table_map # # table_id: # (test.t1)
221 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
222 binlog.000001 # Table_map # # table_id: # (test.t1)
223 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
224 binlog.000001 # Table_map # # table_id: # (test.t1)
225 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
226 binlog.000001 # Table_map # # table_id: # (test.t1)
227 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
228 binlog.000001 # Table_map # # table_id: # (test.t1)
229 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
230 binlog.000001 # Table_map # # table_id: # (test.t1)
231 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
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 # Table_map # # table_id: # (test.t1)
237 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
238 binlog.000001 # Table_map # # table_id: # (test.t1)
239 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
240 binlog.000001 # Table_map # # table_id: # (test.t1)
241 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
242 binlog.000001 # Table_map # # table_id: # (test.t1)
243 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
244 binlog.000001 # Table_map # # table_id: # (test.t1)
245 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
246 binlog.000001 # Table_map # # table_id: # (test.t1)
247 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
248 binlog.000001 # Table_map # # table_id: # (test.t1)
249 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
250 binlog.000001 # Table_map # # table_id: # (test.t1)
251 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
252 binlog.000001 # Table_map # # table_id: # (test.t1)
253 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
254 binlog.000001 # Xid # # COMMIT /* XID */
255 binlog.000001 # Rotate # # binlog.000002;pos=POS
256 include/show_binlog_events.inc
257 Log_name Pos Event_type Server_id End_log_pos Info
258 binlog.000002 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
259 set @ac = @@autocommit;
260 set autocommit= 0;
261 reset master;
262 create table t1(n int) engine=innodb;
263 begin;
264 insert into t1 values (1);
265 insert into t1 values (2);
266 insert into t1 values (3);
267 commit;
268 drop table t1;
269 include/show_binlog_events.inc
270 Log_name Pos Event_type Server_id End_log_pos Info
271 binlog.000001 # Query # # use `test`; create table t1(n int) engine=innodb
272 binlog.000001 # Query # # BEGIN
273 binlog.000001 # Table_map # # table_id: # (test.t1)
274 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
275 binlog.000001 # Table_map # # table_id: # (test.t1)
276 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
277 binlog.000001 # Table_map # # table_id: # (test.t1)
278 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
279 binlog.000001 # Xid # # COMMIT /* XID */
280 binlog.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
281 set @bcs = @@binlog_cache_size;
282 set global binlog_cache_size=4096;
283 reset master;
284 create table t1 (a int, b char(255)) engine=innodb;
285 flush status;
286 show status like "binlog_cache_use";
287 Variable_name Value
288 Binlog_cache_use 0
289 *** the following must show the counter value = 1 ***
290 Variable_name Value
291 Binlog_cache_use 1
292 include/show_binlog_events.inc
293 Log_name Pos Event_type Server_id End_log_pos Info
294 binlog.000001 # Query # # use `test`; create table t1 (a int, b char(255)) engine=innodb
295 binlog.000001 # Query # # use `test`; flush status
296 binlog.000001 # Query # # BEGIN
297 binlog.000001 # Table_map # # table_id: # (test.t1)
298 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
299 binlog.000001 # Table_map # # table_id: # (test.t1)
300 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
301 binlog.000001 # Table_map # # table_id: # (test.t1)
302 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
303 binlog.000001 # Table_map # # table_id: # (test.t1)
304 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
305 binlog.000001 # Table_map # # table_id: # (test.t1)
306 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
307 binlog.000001 # Table_map # # table_id: # (test.t1)
308 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
309 binlog.000001 # Table_map # # table_id: # (test.t1)
310 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
311 binlog.000001 # Table_map # # table_id: # (test.t1)
312 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
313 binlog.000001 # Table_map # # table_id: # (test.t1)
314 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
315 binlog.000001 # Table_map # # table_id: # (test.t1)
316 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
317 binlog.000001 # Table_map # # table_id: # (test.t1)
318 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
319 binlog.000001 # Table_map # # table_id: # (test.t1)
320 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
321 binlog.000001 # Table_map # # table_id: # (test.t1)
322 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
323 binlog.000001 # Table_map # # table_id: # (test.t1)
324 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
325 binlog.000001 # Table_map # # table_id: # (test.t1)
326 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
327 binlog.000001 # Table_map # # table_id: # (test.t1)
328 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
329 binlog.000001 # Table_map # # table_id: # (test.t1)
330 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
331 binlog.000001 # Table_map # # table_id: # (test.t1)
332 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
333 binlog.000001 # Table_map # # table_id: # (test.t1)
334 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
335 binlog.000001 # Table_map # # table_id: # (test.t1)
336 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
337 binlog.000001 # Table_map # # table_id: # (test.t1)
338 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
339 binlog.000001 # Table_map # # table_id: # (test.t1)
340 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
341 binlog.000001 # Table_map # # table_id: # (test.t1)
342 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
343 binlog.000001 # Table_map # # table_id: # (test.t1)
344 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
345 binlog.000001 # Table_map # # table_id: # (test.t1)
346 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
347 binlog.000001 # Table_map # # table_id: # (test.t1)
348 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
349 binlog.000001 # Table_map # # table_id: # (test.t1)
350 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
351 binlog.000001 # Table_map # # table_id: # (test.t1)
352 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
353 binlog.000001 # Table_map # # table_id: # (test.t1)
354 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
355 binlog.000001 # Table_map # # table_id: # (test.t1)
356 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
357 binlog.000001 # Table_map # # table_id: # (test.t1)
358 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
359 binlog.000001 # Table_map # # table_id: # (test.t1)
360 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
361 binlog.000001 # Table_map # # table_id: # (test.t1)
362 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
363 binlog.000001 # Table_map # # table_id: # (test.t1)
364 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
365 binlog.000001 # Table_map # # table_id: # (test.t1)
366 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
367 binlog.000001 # Table_map # # table_id: # (test.t1)
368 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
369 binlog.000001 # Table_map # # table_id: # (test.t1)
370 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
371 binlog.000001 # Table_map # # table_id: # (test.t1)
372 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
373 binlog.000001 # Table_map # # table_id: # (test.t1)
374 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
375 binlog.000001 # Table_map # # table_id: # (test.t1)
376 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
377 binlog.000001 # Table_map # # table_id: # (test.t1)
378 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
379 binlog.000001 # Table_map # # table_id: # (test.t1)
380 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
381 binlog.000001 # Table_map # # table_id: # (test.t1)
382 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
383 binlog.000001 # Table_map # # table_id: # (test.t1)
384 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
385 binlog.000001 # Table_map # # table_id: # (test.t1)
386 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
387 binlog.000001 # Table_map # # table_id: # (test.t1)
388 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
389 binlog.000001 # Table_map # # table_id: # (test.t1)
390 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
391 binlog.000001 # Table_map # # table_id: # (test.t1)
392 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
393 binlog.000001 # Table_map # # table_id: # (test.t1)
394 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
395 binlog.000001 # Table_map # # table_id: # (test.t1)
396 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
397 binlog.000001 # Table_map # # table_id: # (test.t1)
398 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
399 binlog.000001 # Table_map # # table_id: # (test.t1)
400 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
401 binlog.000001 # Table_map # # table_id: # (test.t1)
402 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
403 binlog.000001 # Table_map # # table_id: # (test.t1)
404 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
405 binlog.000001 # Table_map # # table_id: # (test.t1)
406 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
407 binlog.000001 # Table_map # # table_id: # (test.t1)
408 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
409 binlog.000001 # Table_map # # table_id: # (test.t1)
410 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
411 binlog.000001 # Table_map # # table_id: # (test.t1)
412 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
413 binlog.000001 # Table_map # # table_id: # (test.t1)
414 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
415 binlog.000001 # Table_map # # table_id: # (test.t1)
416 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
417 binlog.000001 # Table_map # # table_id: # (test.t1)
418 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
419 binlog.000001 # Table_map # # table_id: # (test.t1)
420 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
421 binlog.000001 # Table_map # # table_id: # (test.t1)
422 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
423 binlog.000001 # Table_map # # table_id: # (test.t1)
424 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
425 binlog.000001 # Table_map # # table_id: # (test.t1)
426 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
427 binlog.000001 # Table_map # # table_id: # (test.t1)
428 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
429 binlog.000001 # Table_map # # table_id: # (test.t1)
430 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
431 binlog.000001 # Table_map # # table_id: # (test.t1)
432 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
433 binlog.000001 # Table_map # # table_id: # (test.t1)
434 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
435 binlog.000001 # Table_map # # table_id: # (test.t1)
436 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
437 binlog.000001 # Table_map # # table_id: # (test.t1)
438 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
439 binlog.000001 # Table_map # # table_id: # (test.t1)
440 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
441 binlog.000001 # Table_map # # table_id: # (test.t1)
442 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
443 binlog.000001 # Table_map # # table_id: # (test.t1)
444 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
445 binlog.000001 # Table_map # # table_id: # (test.t1)
446 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
447 binlog.000001 # Table_map # # table_id: # (test.t1)
448 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
449 binlog.000001 # Table_map # # table_id: # (test.t1)
450 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
451 binlog.000001 # Table_map # # table_id: # (test.t1)
452 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
453 binlog.000001 # Table_map # # table_id: # (test.t1)
454 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
455 binlog.000001 # Table_map # # table_id: # (test.t1)
456 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
457 binlog.000001 # Table_map # # table_id: # (test.t1)
458 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
459 binlog.000001 # Table_map # # table_id: # (test.t1)
460 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
461 binlog.000001 # Table_map # # table_id: # (test.t1)
462 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
463 binlog.000001 # Table_map # # table_id: # (test.t1)
464 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
465 binlog.000001 # Table_map # # table_id: # (test.t1)
466 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
467 binlog.000001 # Table_map # # table_id: # (test.t1)
468 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
469 binlog.000001 # Table_map # # table_id: # (test.t1)
470 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
471 binlog.000001 # Table_map # # table_id: # (test.t1)
472 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
473 binlog.000001 # Table_map # # table_id: # (test.t1)
474 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
475 binlog.000001 # Table_map # # table_id: # (test.t1)
476 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
477 binlog.000001 # Table_map # # table_id: # (test.t1)
478 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
479 binlog.000001 # Table_map # # table_id: # (test.t1)
480 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
481 binlog.000001 # Table_map # # table_id: # (test.t1)
482 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
483 binlog.000001 # Table_map # # table_id: # (test.t1)
484 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
485 binlog.000001 # Table_map # # table_id: # (test.t1)
486 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
487 binlog.000001 # Table_map # # table_id: # (test.t1)
488 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
489 binlog.000001 # Table_map # # table_id: # (test.t1)
490 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
491 binlog.000001 # Table_map # # table_id: # (test.t1)
492 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
493 binlog.000001 # Table_map # # table_id: # (test.t1)
494 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
495 binlog.000001 # Table_map # # table_id: # (test.t1)
496 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
497 binlog.000001 # Xid # # COMMIT /* XID */
498 binlog.000001 # Rotate # # binlog.000002;pos=POS
499 drop table t1;
500 set global binlog_cache_size=@bcs;
501 set session autocommit = @ac;
502 drop table if exists t1;
503 reset master;
504 create table t1 (a bigint unsigned, b bigint(20) unsigned);
505 Warnings:
506 Warning 1681 Integer display width is deprecated and will be removed in a future release.
507 prepare stmt from "insert into t1 values (?,?)";
508 set @a= 9999999999999999;
509 set @b= 14632475938453979136;
510 execute stmt using @a, @b;
511 deallocate prepare stmt;
512 drop table t1;
513 include/show_binlog_events.inc
514 Log_name Pos Event_type Server_id End_log_pos Info
515 binlog.000001 # Query # # use `test`; create table t1 (a bigint unsigned, b bigint(20) unsigned)
516 binlog.000001 # Query # # BEGIN
517 binlog.000001 # Table_map # # table_id: # (test.t1)
518 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
519 binlog.000001 # Xid # # COMMIT /* XID */
520 binlog.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
521 reset master;
522 CREATE DATABASE bug39182 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
523 Warnings:
524 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
525 Warning 3778 'utf8mb3_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
526 USE bug39182;
527 CREATE TABLE t1 (a VARCHAR(255) COLLATE utf8_unicode_ci)
528 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
529 Warnings:
530 Warning 3778 'utf8mb3_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
531 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
532 Warning 3778 'utf8mb3_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
533 CREATE PROCEDURE p1()
534 BEGIN
535 DECLARE s1 VARCHAR(255);
536 SET s1= "test";
537 CREATE TEMPORARY TABLE tmp1
538 SELECT * FROM t1 WHERE a LIKE CONCAT("%", s1, "%");
539 SELECT
540 COLLATION(NAME_CONST('s1', _utf8'test')) c1,
541 COLLATION(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) c2,
542 COLLATION(s1) c3,
543 COERCIBILITY(NAME_CONST('s1', _utf8'test')) d1,
544 COERCIBILITY(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) d2,
545 COERCIBILITY(s1) d3;
546 DROP TEMPORARY TABLE tmp1;
547 END//
548 Warnings:
549 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
550 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
551 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
552 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
553 CALL p1();
554 c1 c2 c3 d1 d2 d3
555 utf8mb3_general_ci utf8mb3_unicode_ci utf8mb3_unicode_ci 4 0 2
556 Warnings:
557 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
558 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
559 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
560 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
561 include/show_binlog_events.inc
562 Log_name Pos Event_type Server_id End_log_pos Info
563 binlog.000001 # Query # # CREATE DATABASE bug39182 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci
564 binlog.000001 # Query # # use `bug39182`; CREATE TABLE t1 (a VARCHAR(255) COLLATE utf8_unicode_ci)
565 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
566 binlog.000001 # Query # # use `bug39182`; CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
567 BEGIN
568 DECLARE s1 VARCHAR(255);
569 SET s1= "test";
570 CREATE TEMPORARY TABLE tmp1
571 SELECT * FROM t1 WHERE a LIKE CONCAT("%", s1, "%");
572 SELECT
573 COLLATION(NAME_CONST('s1', _utf8'test')) c1,
574 COLLATION(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) c2,
575 COLLATION(s1) c3,
576 COERCIBILITY(NAME_CONST('s1', _utf8'test')) d1,
577 COERCIBILITY(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) d2,
578 COERCIBILITY(s1) d3;
579 DROP TEMPORARY TABLE tmp1;
580 END
581 DROP PROCEDURE p1;
582 DROP TABLE t1;
583 DROP DATABASE bug39182;
584 USE test;
585 CREATE PROCEDURE p1(IN v1 INT)
586 BEGIN
587 CREATE TABLE t1 SELECT v1;
588 DROP TABLE t1;
589 END//
590 CREATE PROCEDURE p2()
591 BEGIN
592 DECLARE v1 INT;
593 CREATE TABLE t1 SELECT v1+1;
594 DROP TABLE t1;
595 END//
596 CREATE PROCEDURE p3(IN v1 INT)
597 BEGIN
598 CREATE TABLE t1 SELECT 1 FROM DUAL WHERE v1!=0;
599 DROP TABLE t1;
600 END//
601 CREATE PROCEDURE p4(IN v1 INT)
602 BEGIN
603 DECLARE v2 INT;
604 CREATE TABLE t1 SELECT 1, v1, v2;
605 DROP TABLE t1;
606 CREATE TABLE t1 SELECT 1, v1+1, v2;
607 DROP TABLE t1;
608 END//
609 CALL p1(1);
610 CALL p2();
611 CALL p3(0);
612 CALL p4(0);
613 DROP PROCEDURE p1;
614 DROP PROCEDURE p2;
615 DROP PROCEDURE p3;
616 DROP PROCEDURE p4;
617 End of 5.0 tests
618 reset master;
619 create table t1 (id tinyint auto_increment primary key);
620 set insert_id=128;
621 insert ignore into t1 values(null);
622 Warnings:
623 Warning 1264 Out of range value for column 'id' at row 1
624 select * from t1;
625 id
626 127
627 drop table t1;
628 create table t1 (a int);
629 create table if not exists t2 select * from t1;
630 create temporary table tt1 (a int);
631 create table if not exists t3 like tt1;
632 USE mysql;
633 INSERT IGNORE INTO user SET host='localhost', user='@#@', authentication_string='*1111111111111111111111111111111111111111';
634 UPDATE user SET authentication_string='*67092806AE91BFB6BE72DE6C7BE2B7CCA8CFA9DF' WHERE host='localhost' AND user='@#@';
635 DELETE FROM user WHERE host='localhost' AND user='@#@';
636 use test;
637 include/show_binlog_events.inc
638 Log_name Pos Event_type Server_id End_log_pos Info
639 binlog.000001 # Query # # use `test`; create table t1 (id tinyint auto_increment primary key)
640 binlog.000001 # Query # # BEGIN
641 binlog.000001 # Table_map # # table_id: # (test.t1)
642 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
643 binlog.000001 # Xid # # COMMIT /* XID */
644 binlog.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
645 binlog.000001 # Query # # use `test`; create table t1 (a int)
646 binlog.000001 # Query # # BEGIN
647 binlog.000001 # Query # # use `test`; CREATE TABLE IF NOT EXISTS `t2` (
648 `a` int DEFAULT NULL
649 ) START TRANSACTION
650 binlog.000001 # Xid # # COMMIT /* XID */
651 binlog.000001 # Query # # use `test`; CREATE TABLE IF NOT EXISTS `t3` (
652 `a` int DEFAULT NULL
653 ) ENGINE=InnoDB
654 binlog.000001 # Query # # BEGIN
655 binlog.000001 # Table_map # # table_id: # (mysql.user)
656 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
657 binlog.000001 # Xid # # COMMIT /* XID */
658 binlog.000001 # Query # # BEGIN
659 binlog.000001 # Table_map # # table_id: # (mysql.user)
660 binlog.000001 # Update_rows # # table_id: # flags: STMT_END_F
661 binlog.000001 # Xid # # COMMIT /* XID */
662 binlog.000001 # Query # # BEGIN
663 binlog.000001 # Table_map # # table_id: # (mysql.user)
664 binlog.000001 # Delete_rows # # table_id: # flags: STMT_END_F
665 binlog.000001 # Xid # # COMMIT /* XID */
666 drop table t1,t2,t3,tt1;
667 reset master;
668 drop table if exists t3;
669 create table t3 (a int(11) NOT NULL AUTO_INCREMENT, b text, PRIMARY KEY (a) ) engine=innodb;
670 Warnings:
671 Warning 1681 Integer display width is deprecated and will be removed in a future release.
672 File binlog.000001
673 insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
674 insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
675 insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
676 insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
677 *** show new binlog index after rotating ***
678 File binlog.000002
679 drop table t3;
680 RESET MASTER;
681 #
682 # Bug #45998: database crashes when running "create as select"
683 #
684 CREATE DATABASE test1;
685 USE test1;
686 DROP DATABASE test1;
687 CREATE TABLE test.t1(a int);
688 INSERT INTO test.t1 VALUES (1), (2);
689 CREATE TABLE test.t2 SELECT * FROM test.t1;
690 USE test;
691 DROP TABLES t1, t2;
692 RESET MASTER;
693 CREATE TABLE t1 (a INT PRIMARY KEY);
694 BINLOG '
695 3u9kSA8KAAAAZgAAAGoAAAABAAQANS4xLjM1LW1hcmlhLWJldGExLWRlYnVnLWxvZwAAAAAAAAAA
696 AAAAAAAAAAAAAAAAAADe72RIEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC
697 ';
698 INSERT INTO t1 VALUES (1);
699 BINLOG '
700 3u9kSBMUAAAAKQAAAJEBAAAAABoAAAAAAAAABHRlc3QAAnQxAAEDAAA=
701 3u9kSBcUAAAAIgAAALMBAAAQABoAAAAAAAEAAf/+AgAAAA==
702 ';
703 include/show_binlog_events.inc
704 Log_name Pos Event_type Server_id End_log_pos Info
705 # # Query 1 # use `test`; CREATE TABLE t1 (a INT PRIMARY KEY)
706 # # Query 1 # BEGIN
707 # # Table_map 1 # table_id: # (test.t1)
708 # # Write_rows 1 # table_id: # flags: STMT_END_F
709 # # Xid 1 # COMMIT /* XID */
710 # # Query 1 # BEGIN
711 # # Table_map 1 # table_id: # (test.t1)
712 # # Write_rows 1 # table_id: # flags: STMT_END_F
713 # # Xid 1 # COMMIT /* XID */
714 DROP TABLE t1;
715
716 # BUG#54903 BINLOG statement toggles session variables
717 # ----------------------------------------------------------------------
718 # This test verify that BINLOG statement doesn't change current session's
719 # variables foreign_key_checks and unique_checks.
720
721 CREATE TABLE t1 (c1 INT KEY);
722 SET @@SESSION.foreign_key_checks= ON;
723 SET @@SESSION.unique_checks= ON;
724 # INSERT INTO t1 VALUES (1)
725 # foreign_key_checks=0 and unique_checks=0
726 BINLOG '
727 dfLtTBMBAAAAKQAAANcAAAAAABcAAAAAAAEABHRlc3QAAnQxAAEDAAE=
728 dfLtTBcBAAAAIgAAAPkAAAAAABcAAAAAAAcAAf/+AQAAAA==
729 ';
730 SELECT * FROM t1;
731 c1
732 1
733 # Their values should be ON
734 SHOW SESSION VARIABLES LIKE "%_checks";
735 Variable_name Value
736 foreign_key_checks ON
737 unique_checks ON
738
739 SET @@SESSION.foreign_key_checks= OFF;
740 SET @@SESSION.unique_checks= OFF;
741 # INSERT INTO t1 VALUES(2)
742 # foreign_key_checks=1 and unique_checks=1
743 BINLOG '
744 dfLtTBMBAAAAKQAAAKsBAAAAABcAAAAAAAEABHRlc3QAAnQxAAEDAAE=
745 dfLtTBcBAAAAIgAAAM0BAAAAABcAAAAAAAEAAf/+AgAAAA==
746 ';
747 SELECT * FROM t1;
748 c1
749 1
750 2
751 # Their values should be OFF
752 SHOW SESSION VARIABLES LIKE "%_checks";
753 Variable_name Value
754 foreign_key_checks OFF
755 unique_checks OFF
756 # INSERT INTO t1 VALUES(2)
757 # foreign_key_checks=1 and unique_checks=1
758 # It should not change current session's variables, even error happens
759 call mtr.add_suppression("Replica SQL.*Could not execute Write_rows_v1 event on table test.t1; Duplicate entry .2. for key .t1.PRIMARY., Error_code: 1062");
760 BINLOG '
761 dfLtTBMBAAAAKQAAAKsBAAAAABcAAAAAAAEABHRlc3QAAnQxAAEDAAE=
762 dfLtTBcBAAAAIgAAAM0BAAAAABcAAAAAAAEAAf/+AgAAAA==
763 ';
764 ERROR 23000: Duplicate entry '2' for key 't1.PRIMARY'
765 SELECT * FROM t1;
766 c1
767 1
768 2
769 # Their values should be OFF
770 SHOW SESSION VARIABLES LIKE "%_checks";
771 Variable_name Value
772 foreign_key_checks OFF
773 unique_checks OFF
774 DROP TABLE t1;