[tomato.git] / release / src / router / mysql / mysql-test / suite / binlog / r / binlog_row_binlog.result
| blob | e726d236323c51f9671bd0249e135a7fabd74ef7 |
1 drop table if exists t1, t2;
2 reset master;
3 create table t1 (a int) engine=innodb;
4 create table t2 (a int) engine=innodb;
5 begin;
6 insert t1 values (5);
7 commit;
8 begin;
9 insert t2 values (5);
10 commit;
11 show binlog events from <binlog_start>;
12 Log_name Pos Event_type Server_id End_log_pos Info
13 master-bin.000001 # Query # # use `test`; create table t1 (a int) engine=innodb
14 master-bin.000001 # Query # # use `test`; create table t2 (a int) engine=innodb
15 master-bin.000001 # Query # # BEGIN
16 master-bin.000001 # Table_map # # table_id: # (test.t1)
17 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
18 master-bin.000001 # Xid # # COMMIT /* XID */
19 master-bin.000001 # Query # # BEGIN
20 master-bin.000001 # Table_map # # table_id: # (test.t2)
21 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
22 master-bin.000001 # Xid # # COMMIT /* XID */
23 drop table t1,t2;
24 reset master;
25 create table t1 (n int) engine=innodb;
26 begin;
27 commit;
28 drop table t1;
29 show binlog events from <binlog_start>;
30 Log_name Pos Event_type Server_id End_log_pos Info
31 master-bin.000001 # Query # # use `test`; create table t1 (n int) engine=innodb
32 master-bin.000001 # Query # # BEGIN
33 master-bin.000001 # Table_map # # table_id: # (test.t1)
34 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
35 master-bin.000001 # Table_map # # table_id: # (test.t1)
36 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
37 master-bin.000001 # Table_map # # table_id: # (test.t1)
38 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
39 master-bin.000001 # Table_map # # table_id: # (test.t1)
40 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
41 master-bin.000001 # Table_map # # table_id: # (test.t1)
42 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
43 master-bin.000001 # Table_map # # table_id: # (test.t1)
44 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
45 master-bin.000001 # Table_map # # table_id: # (test.t1)
46 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
47 master-bin.000001 # Table_map # # table_id: # (test.t1)
48 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
49 master-bin.000001 # Table_map # # table_id: # (test.t1)
50 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
51 master-bin.000001 # Table_map # # table_id: # (test.t1)
52 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
53 master-bin.000001 # Table_map # # table_id: # (test.t1)
54 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
55 master-bin.000001 # Table_map # # table_id: # (test.t1)
56 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
57 master-bin.000001 # Table_map # # table_id: # (test.t1)
58 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
59 master-bin.000001 # Table_map # # table_id: # (test.t1)
60 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
61 master-bin.000001 # Table_map # # table_id: # (test.t1)
62 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
63 master-bin.000001 # Table_map # # table_id: # (test.t1)
64 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
65 master-bin.000001 # Table_map # # table_id: # (test.t1)
66 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
67 master-bin.000001 # Table_map # # table_id: # (test.t1)
68 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
69 master-bin.000001 # Table_map # # table_id: # (test.t1)
70 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
71 master-bin.000001 # Table_map # # table_id: # (test.t1)
72 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
73 master-bin.000001 # Table_map # # table_id: # (test.t1)
74 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
75 master-bin.000001 # Table_map # # table_id: # (test.t1)
76 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
77 master-bin.000001 # Table_map # # table_id: # (test.t1)
78 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
79 master-bin.000001 # Table_map # # table_id: # (test.t1)
80 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
81 master-bin.000001 # Table_map # # table_id: # (test.t1)
82 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
83 master-bin.000001 # Table_map # # table_id: # (test.t1)
84 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
85 master-bin.000001 # Table_map # # table_id: # (test.t1)
86 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
87 master-bin.000001 # Table_map # # table_id: # (test.t1)
88 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
89 master-bin.000001 # Table_map # # table_id: # (test.t1)
90 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
91 master-bin.000001 # Table_map # # table_id: # (test.t1)
92 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
93 master-bin.000001 # Table_map # # table_id: # (test.t1)
94 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
95 master-bin.000001 # Table_map # # table_id: # (test.t1)
96 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
97 master-bin.000001 # Table_map # # table_id: # (test.t1)
98 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
99 master-bin.000001 # Table_map # # table_id: # (test.t1)
100 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
101 master-bin.000001 # Table_map # # table_id: # (test.t1)
102 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
103 master-bin.000001 # Table_map # # table_id: # (test.t1)
104 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
105 master-bin.000001 # Table_map # # table_id: # (test.t1)
106 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
107 master-bin.000001 # Table_map # # table_id: # (test.t1)
108 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
109 master-bin.000001 # Table_map # # table_id: # (test.t1)
110 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
111 master-bin.000001 # Table_map # # table_id: # (test.t1)
112 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
113 master-bin.000001 # Table_map # # table_id: # (test.t1)
114 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
115 master-bin.000001 # Table_map # # table_id: # (test.t1)
116 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
117 master-bin.000001 # Table_map # # table_id: # (test.t1)
118 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
119 master-bin.000001 # Table_map # # table_id: # (test.t1)
120 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
121 master-bin.000001 # Table_map # # table_id: # (test.t1)
122 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
123 master-bin.000001 # Table_map # # table_id: # (test.t1)
124 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
125 master-bin.000001 # Table_map # # table_id: # (test.t1)
126 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
127 master-bin.000001 # Table_map # # table_id: # (test.t1)
128 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
129 master-bin.000001 # Table_map # # table_id: # (test.t1)
130 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
131 master-bin.000001 # Table_map # # table_id: # (test.t1)
132 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
133 master-bin.000001 # Table_map # # table_id: # (test.t1)
134 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
135 master-bin.000001 # Table_map # # table_id: # (test.t1)
136 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
137 master-bin.000001 # Table_map # # table_id: # (test.t1)
138 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
139 master-bin.000001 # Table_map # # table_id: # (test.t1)
140 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
141 master-bin.000001 # Table_map # # table_id: # (test.t1)
142 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
143 master-bin.000001 # Table_map # # table_id: # (test.t1)
144 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
145 master-bin.000001 # Table_map # # table_id: # (test.t1)
146 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
147 master-bin.000001 # Table_map # # table_id: # (test.t1)
148 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
149 master-bin.000001 # Table_map # # table_id: # (test.t1)
150 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
151 master-bin.000001 # Table_map # # table_id: # (test.t1)
152 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
153 master-bin.000001 # Table_map # # table_id: # (test.t1)
154 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
155 master-bin.000001 # Table_map # # table_id: # (test.t1)
156 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
157 master-bin.000001 # Table_map # # table_id: # (test.t1)
158 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
159 master-bin.000001 # Table_map # # table_id: # (test.t1)
160 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
161 master-bin.000001 # Table_map # # table_id: # (test.t1)
162 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
163 master-bin.000001 # Table_map # # table_id: # (test.t1)
164 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
165 master-bin.000001 # Table_map # # table_id: # (test.t1)
166 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
167 master-bin.000001 # Table_map # # table_id: # (test.t1)
168 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
169 master-bin.000001 # Table_map # # table_id: # (test.t1)
170 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
171 master-bin.000001 # Table_map # # table_id: # (test.t1)
172 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
173 master-bin.000001 # Table_map # # table_id: # (test.t1)
174 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
175 master-bin.000001 # Table_map # # table_id: # (test.t1)
176 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
177 master-bin.000001 # Table_map # # table_id: # (test.t1)
178 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
179 master-bin.000001 # Table_map # # table_id: # (test.t1)
180 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
181 master-bin.000001 # Table_map # # table_id: # (test.t1)
182 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
183 master-bin.000001 # Table_map # # table_id: # (test.t1)
184 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
185 master-bin.000001 # Table_map # # table_id: # (test.t1)
186 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
187 master-bin.000001 # Table_map # # table_id: # (test.t1)
188 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
189 master-bin.000001 # Table_map # # table_id: # (test.t1)
190 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
191 master-bin.000001 # Table_map # # table_id: # (test.t1)
192 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
193 master-bin.000001 # Table_map # # table_id: # (test.t1)
194 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
195 master-bin.000001 # Table_map # # table_id: # (test.t1)
196 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
197 master-bin.000001 # Table_map # # table_id: # (test.t1)
198 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
199 master-bin.000001 # Table_map # # table_id: # (test.t1)
200 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
201 master-bin.000001 # Table_map # # table_id: # (test.t1)
202 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
203 master-bin.000001 # Table_map # # table_id: # (test.t1)
204 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
205 master-bin.000001 # Table_map # # table_id: # (test.t1)
206 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
207 master-bin.000001 # Table_map # # table_id: # (test.t1)
208 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
209 master-bin.000001 # Table_map # # table_id: # (test.t1)
210 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
211 master-bin.000001 # Table_map # # table_id: # (test.t1)
212 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
213 master-bin.000001 # Table_map # # table_id: # (test.t1)
214 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
215 master-bin.000001 # Table_map # # table_id: # (test.t1)
216 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
217 master-bin.000001 # Table_map # # table_id: # (test.t1)
218 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
219 master-bin.000001 # Table_map # # table_id: # (test.t1)
220 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
221 master-bin.000001 # Table_map # # table_id: # (test.t1)
222 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
223 master-bin.000001 # Table_map # # table_id: # (test.t1)
224 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
225 master-bin.000001 # Table_map # # table_id: # (test.t1)
226 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
227 master-bin.000001 # Table_map # # table_id: # (test.t1)
228 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
229 master-bin.000001 # Table_map # # table_id: # (test.t1)
230 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
231 master-bin.000001 # Table_map # # table_id: # (test.t1)
232 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
233 master-bin.000001 # Xid # # COMMIT /* XID */
234 master-bin.000001 # Rotate # # master-bin.000002;pos=4
235 show binlog events in 'master-bin.000002' from <binlog_start>;
236 Log_name Pos Event_type Server_id End_log_pos Info
237 master-bin.000002 # Query # # use `test`; drop table t1
238 set @ac = @@autocommit;
239 set autocommit= 0;
240 reset master;
241 create table t1(n int) engine=innodb;
242 begin;
243 insert into t1 values (1);
244 insert into t1 values (2);
245 insert into t1 values (3);
246 commit;
247 drop table t1;
248 show binlog events from <binlog_start>;
249 Log_name Pos Event_type Server_id End_log_pos Info
250 master-bin.000001 # Query # # use `test`; create table t1(n int) engine=innodb
251 master-bin.000001 # Query # # BEGIN
252 master-bin.000001 # Table_map # # table_id: # (test.t1)
253 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
254 master-bin.000001 # Table_map # # table_id: # (test.t1)
255 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
256 master-bin.000001 # Table_map # # table_id: # (test.t1)
257 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
258 master-bin.000001 # Xid # # COMMIT /* XID */
259 master-bin.000001 # Query # # use `test`; drop table t1
260 set @bcs = @@binlog_cache_size;
261 set global binlog_cache_size=4096;
262 reset master;
263 create table t1 (a int) engine=innodb;
264 show binlog events from <binlog_start>;
265 Log_name Pos Event_type Server_id End_log_pos Info
266 master-bin.000001 # Query # # use `test`; create table t1 (a int) engine=innodb
267 master-bin.000001 # Query # # BEGIN
268 master-bin.000001 # Table_map # # table_id: # (test.t1)
269 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
270 master-bin.000001 # Table_map # # table_id: # (test.t1)
271 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
272 master-bin.000001 # Table_map # # table_id: # (test.t1)
273 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
274 master-bin.000001 # Table_map # # table_id: # (test.t1)
275 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
276 master-bin.000001 # Table_map # # table_id: # (test.t1)
277 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
278 master-bin.000001 # Table_map # # table_id: # (test.t1)
279 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
280 master-bin.000001 # Table_map # # table_id: # (test.t1)
281 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
282 master-bin.000001 # Table_map # # table_id: # (test.t1)
283 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
284 master-bin.000001 # Table_map # # table_id: # (test.t1)
285 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
286 master-bin.000001 # Table_map # # table_id: # (test.t1)
287 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
288 master-bin.000001 # Table_map # # table_id: # (test.t1)
289 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
290 master-bin.000001 # Table_map # # table_id: # (test.t1)
291 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
292 master-bin.000001 # Table_map # # table_id: # (test.t1)
293 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
294 master-bin.000001 # Table_map # # table_id: # (test.t1)
295 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
296 master-bin.000001 # Table_map # # table_id: # (test.t1)
297 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
298 master-bin.000001 # Table_map # # table_id: # (test.t1)
299 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
300 master-bin.000001 # Table_map # # table_id: # (test.t1)
301 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
302 master-bin.000001 # Table_map # # table_id: # (test.t1)
303 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
304 master-bin.000001 # Table_map # # table_id: # (test.t1)
305 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
306 master-bin.000001 # Table_map # # table_id: # (test.t1)
307 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
308 master-bin.000001 # Table_map # # table_id: # (test.t1)
309 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
310 master-bin.000001 # Table_map # # table_id: # (test.t1)
311 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
312 master-bin.000001 # Table_map # # table_id: # (test.t1)
313 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
314 master-bin.000001 # Table_map # # table_id: # (test.t1)
315 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
316 master-bin.000001 # Table_map # # table_id: # (test.t1)
317 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
318 master-bin.000001 # Table_map # # table_id: # (test.t1)
319 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
320 master-bin.000001 # Table_map # # table_id: # (test.t1)
321 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
322 master-bin.000001 # Table_map # # table_id: # (test.t1)
323 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
324 master-bin.000001 # Table_map # # table_id: # (test.t1)
325 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
326 master-bin.000001 # Table_map # # table_id: # (test.t1)
327 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
328 master-bin.000001 # Table_map # # table_id: # (test.t1)
329 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
330 master-bin.000001 # Table_map # # table_id: # (test.t1)
331 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
332 master-bin.000001 # Table_map # # table_id: # (test.t1)
333 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
334 master-bin.000001 # Table_map # # table_id: # (test.t1)
335 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
336 master-bin.000001 # Table_map # # table_id: # (test.t1)
337 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
338 master-bin.000001 # Table_map # # table_id: # (test.t1)
339 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
340 master-bin.000001 # Table_map # # table_id: # (test.t1)
341 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
342 master-bin.000001 # Table_map # # table_id: # (test.t1)
343 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
344 master-bin.000001 # Table_map # # table_id: # (test.t1)
345 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
346 master-bin.000001 # Table_map # # table_id: # (test.t1)
347 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
348 master-bin.000001 # Table_map # # table_id: # (test.t1)
349 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
350 master-bin.000001 # Table_map # # table_id: # (test.t1)
351 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
352 master-bin.000001 # Table_map # # table_id: # (test.t1)
353 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
354 master-bin.000001 # Table_map # # table_id: # (test.t1)
355 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
356 master-bin.000001 # Table_map # # table_id: # (test.t1)
357 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
358 master-bin.000001 # Table_map # # table_id: # (test.t1)
359 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
360 master-bin.000001 # Table_map # # table_id: # (test.t1)
361 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
362 master-bin.000001 # Table_map # # table_id: # (test.t1)
363 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
364 master-bin.000001 # Table_map # # table_id: # (test.t1)
365 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
366 master-bin.000001 # Table_map # # table_id: # (test.t1)
367 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
368 master-bin.000001 # Table_map # # table_id: # (test.t1)
369 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
370 master-bin.000001 # Table_map # # table_id: # (test.t1)
371 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
372 master-bin.000001 # Table_map # # table_id: # (test.t1)
373 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
374 master-bin.000001 # Table_map # # table_id: # (test.t1)
375 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
376 master-bin.000001 # Table_map # # table_id: # (test.t1)
377 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
378 master-bin.000001 # Table_map # # table_id: # (test.t1)
379 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
380 master-bin.000001 # Table_map # # table_id: # (test.t1)
381 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
382 master-bin.000001 # Table_map # # table_id: # (test.t1)
383 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
384 master-bin.000001 # Table_map # # table_id: # (test.t1)
385 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
386 master-bin.000001 # Table_map # # table_id: # (test.t1)
387 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
388 master-bin.000001 # Table_map # # table_id: # (test.t1)
389 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
390 master-bin.000001 # Table_map # # table_id: # (test.t1)
391 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
392 master-bin.000001 # Table_map # # table_id: # (test.t1)
393 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
394 master-bin.000001 # Table_map # # table_id: # (test.t1)
395 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
396 master-bin.000001 # Table_map # # table_id: # (test.t1)
397 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
398 master-bin.000001 # Table_map # # table_id: # (test.t1)
399 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
400 master-bin.000001 # Table_map # # table_id: # (test.t1)
401 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
402 master-bin.000001 # Table_map # # table_id: # (test.t1)
403 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
404 master-bin.000001 # Table_map # # table_id: # (test.t1)
405 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
406 master-bin.000001 # Table_map # # table_id: # (test.t1)
407 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
408 master-bin.000001 # Table_map # # table_id: # (test.t1)
409 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
410 master-bin.000001 # Table_map # # table_id: # (test.t1)
411 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
412 master-bin.000001 # Table_map # # table_id: # (test.t1)
413 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
414 master-bin.000001 # Table_map # # table_id: # (test.t1)
415 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
416 master-bin.000001 # Table_map # # table_id: # (test.t1)
417 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
418 master-bin.000001 # Table_map # # table_id: # (test.t1)
419 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
420 master-bin.000001 # Table_map # # table_id: # (test.t1)
421 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
422 master-bin.000001 # Table_map # # table_id: # (test.t1)
423 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
424 master-bin.000001 # Table_map # # table_id: # (test.t1)
425 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
426 master-bin.000001 # Table_map # # table_id: # (test.t1)
427 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
428 master-bin.000001 # Table_map # # table_id: # (test.t1)
429 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
430 master-bin.000001 # Table_map # # table_id: # (test.t1)
431 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
432 master-bin.000001 # Table_map # # table_id: # (test.t1)
433 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
434 master-bin.000001 # Table_map # # table_id: # (test.t1)
435 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
436 master-bin.000001 # Table_map # # table_id: # (test.t1)
437 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
438 master-bin.000001 # Table_map # # table_id: # (test.t1)
439 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
440 master-bin.000001 # Table_map # # table_id: # (test.t1)
441 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
442 master-bin.000001 # Table_map # # table_id: # (test.t1)
443 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
444 master-bin.000001 # Table_map # # table_id: # (test.t1)
445 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
446 master-bin.000001 # Table_map # # table_id: # (test.t1)
447 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
448 master-bin.000001 # Table_map # # table_id: # (test.t1)
449 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
450 master-bin.000001 # Table_map # # table_id: # (test.t1)
451 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
452 master-bin.000001 # Table_map # # table_id: # (test.t1)
453 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
454 master-bin.000001 # Table_map # # table_id: # (test.t1)
455 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
456 master-bin.000001 # Table_map # # table_id: # (test.t1)
457 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
458 master-bin.000001 # Table_map # # table_id: # (test.t1)
459 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
460 master-bin.000001 # Table_map # # table_id: # (test.t1)
461 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
462 master-bin.000001 # Table_map # # table_id: # (test.t1)
463 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
464 master-bin.000001 # Table_map # # table_id: # (test.t1)
465 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
466 master-bin.000001 # Table_map # # table_id: # (test.t1)
467 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
468 master-bin.000001 # Table_map # # table_id: # (test.t1)
469 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
470 master-bin.000001 # Table_map # # table_id: # (test.t1)
471 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
472 master-bin.000001 # Table_map # # table_id: # (test.t1)
473 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
474 master-bin.000001 # Table_map # # table_id: # (test.t1)
475 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
476 master-bin.000001 # Table_map # # table_id: # (test.t1)
477 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
478 master-bin.000001 # Table_map # # table_id: # (test.t1)
479 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
480 master-bin.000001 # Table_map # # table_id: # (test.t1)
481 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
482 master-bin.000001 # Table_map # # table_id: # (test.t1)
483 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
484 master-bin.000001 # Table_map # # table_id: # (test.t1)
485 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
486 master-bin.000001 # Table_map # # table_id: # (test.t1)
487 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
488 master-bin.000001 # Table_map # # table_id: # (test.t1)
489 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
490 master-bin.000001 # Table_map # # table_id: # (test.t1)
491 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
492 master-bin.000001 # Table_map # # table_id: # (test.t1)
493 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
494 master-bin.000001 # Table_map # # table_id: # (test.t1)
495 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
496 master-bin.000001 # Table_map # # table_id: # (test.t1)
497 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
498 master-bin.000001 # Table_map # # table_id: # (test.t1)
499 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
500 master-bin.000001 # Table_map # # table_id: # (test.t1)
501 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
502 master-bin.000001 # Table_map # # table_id: # (test.t1)
503 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
504 master-bin.000001 # Table_map # # table_id: # (test.t1)
505 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
506 master-bin.000001 # Table_map # # table_id: # (test.t1)
507 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
508 master-bin.000001 # Table_map # # table_id: # (test.t1)
509 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
510 master-bin.000001 # Table_map # # table_id: # (test.t1)
511 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
512 master-bin.000001 # Table_map # # table_id: # (test.t1)
513 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
514 master-bin.000001 # Table_map # # table_id: # (test.t1)
515 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
516 master-bin.000001 # Table_map # # table_id: # (test.t1)
517 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
518 master-bin.000001 # Table_map # # table_id: # (test.t1)
519 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
520 master-bin.000001 # Table_map # # table_id: # (test.t1)
521 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
522 master-bin.000001 # Table_map # # table_id: # (test.t1)
523 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
524 master-bin.000001 # Table_map # # table_id: # (test.t1)
525 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
526 master-bin.000001 # Table_map # # table_id: # (test.t1)
527 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
528 master-bin.000001 # Table_map # # table_id: # (test.t1)
529 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
530 master-bin.000001 # Table_map # # table_id: # (test.t1)
531 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
532 master-bin.000001 # Table_map # # table_id: # (test.t1)
533 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
534 master-bin.000001 # Table_map # # table_id: # (test.t1)
535 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
536 master-bin.000001 # Table_map # # table_id: # (test.t1)
537 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
538 master-bin.000001 # Table_map # # table_id: # (test.t1)
539 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
540 master-bin.000001 # Table_map # # table_id: # (test.t1)
541 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
542 master-bin.000001 # Table_map # # table_id: # (test.t1)
543 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
544 master-bin.000001 # Table_map # # table_id: # (test.t1)
545 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
546 master-bin.000001 # Table_map # # table_id: # (test.t1)
547 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
548 master-bin.000001 # Table_map # # table_id: # (test.t1)
549 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
550 master-bin.000001 # Table_map # # table_id: # (test.t1)
551 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
552 master-bin.000001 # Table_map # # table_id: # (test.t1)
553 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
554 master-bin.000001 # Table_map # # table_id: # (test.t1)
555 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
556 master-bin.000001 # Table_map # # table_id: # (test.t1)
557 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
558 master-bin.000001 # Table_map # # table_id: # (test.t1)
559 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
560 master-bin.000001 # Table_map # # table_id: # (test.t1)
561 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
562 master-bin.000001 # Table_map # # table_id: # (test.t1)
563 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
564 master-bin.000001 # Table_map # # table_id: # (test.t1)
565 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
566 master-bin.000001 # Table_map # # table_id: # (test.t1)
567 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
568 master-bin.000001 # Table_map # # table_id: # (test.t1)
569 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
570 master-bin.000001 # Table_map # # table_id: # (test.t1)
571 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
572 master-bin.000001 # Table_map # # table_id: # (test.t1)
573 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
574 master-bin.000001 # Table_map # # table_id: # (test.t1)
575 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
576 master-bin.000001 # Table_map # # table_id: # (test.t1)
577 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
578 master-bin.000001 # Table_map # # table_id: # (test.t1)
579 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
580 master-bin.000001 # Table_map # # table_id: # (test.t1)
581 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
582 master-bin.000001 # Table_map # # table_id: # (test.t1)
583 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
584 master-bin.000001 # Table_map # # table_id: # (test.t1)
585 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
586 master-bin.000001 # Table_map # # table_id: # (test.t1)
587 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
588 master-bin.000001 # Table_map # # table_id: # (test.t1)
589 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
590 master-bin.000001 # Table_map # # table_id: # (test.t1)
591 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
592 master-bin.000001 # Table_map # # table_id: # (test.t1)
593 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
594 master-bin.000001 # Table_map # # table_id: # (test.t1)
595 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
596 master-bin.000001 # Table_map # # table_id: # (test.t1)
597 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
598 master-bin.000001 # Table_map # # table_id: # (test.t1)
599 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
600 master-bin.000001 # Table_map # # table_id: # (test.t1)
601 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
602 master-bin.000001 # Table_map # # table_id: # (test.t1)
603 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
604 master-bin.000001 # Table_map # # table_id: # (test.t1)
605 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
606 master-bin.000001 # Table_map # # table_id: # (test.t1)
607 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
608 master-bin.000001 # Table_map # # table_id: # (test.t1)
609 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
610 master-bin.000001 # Table_map # # table_id: # (test.t1)
611 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
612 master-bin.000001 # Table_map # # table_id: # (test.t1)
613 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
614 master-bin.000001 # Table_map # # table_id: # (test.t1)
615 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
616 master-bin.000001 # Table_map # # table_id: # (test.t1)
617 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
618 master-bin.000001 # Table_map # # table_id: # (test.t1)
619 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
620 master-bin.000001 # Table_map # # table_id: # (test.t1)
621 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
622 master-bin.000001 # Table_map # # table_id: # (test.t1)
623 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
624 master-bin.000001 # Table_map # # table_id: # (test.t1)
625 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
626 master-bin.000001 # Table_map # # table_id: # (test.t1)
627 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
628 master-bin.000001 # Table_map # # table_id: # (test.t1)
629 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
630 master-bin.000001 # Table_map # # table_id: # (test.t1)
631 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
632 master-bin.000001 # Table_map # # table_id: # (test.t1)
633 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
634 master-bin.000001 # Table_map # # table_id: # (test.t1)
635 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
636 master-bin.000001 # Table_map # # table_id: # (test.t1)
637 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
638 master-bin.000001 # Table_map # # table_id: # (test.t1)
639 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
640 master-bin.000001 # Table_map # # table_id: # (test.t1)
641 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
642 master-bin.000001 # Table_map # # table_id: # (test.t1)
643 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
644 master-bin.000001 # Table_map # # table_id: # (test.t1)
645 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
646 master-bin.000001 # Table_map # # table_id: # (test.t1)
647 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
648 master-bin.000001 # Table_map # # table_id: # (test.t1)
649 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
650 master-bin.000001 # Table_map # # table_id: # (test.t1)
651 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
652 master-bin.000001 # Table_map # # table_id: # (test.t1)
653 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
654 master-bin.000001 # Table_map # # table_id: # (test.t1)
655 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
656 master-bin.000001 # Table_map # # table_id: # (test.t1)
657 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
658 master-bin.000001 # Table_map # # table_id: # (test.t1)
659 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
660 master-bin.000001 # Table_map # # table_id: # (test.t1)
661 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
662 master-bin.000001 # Table_map # # table_id: # (test.t1)
663 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
664 master-bin.000001 # Table_map # # table_id: # (test.t1)
665 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
666 master-bin.000001 # Table_map # # table_id: # (test.t1)
667 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
668 master-bin.000001 # Table_map # # table_id: # (test.t1)
669 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
670 master-bin.000001 # Table_map # # table_id: # (test.t1)
671 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
672 master-bin.000001 # Table_map # # table_id: # (test.t1)
673 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
674 master-bin.000001 # Table_map # # table_id: # (test.t1)
675 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
676 master-bin.000001 # Table_map # # table_id: # (test.t1)
677 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
678 master-bin.000001 # Table_map # # table_id: # (test.t1)
679 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
680 master-bin.000001 # Table_map # # table_id: # (test.t1)
681 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
682 master-bin.000001 # Table_map # # table_id: # (test.t1)
683 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
684 master-bin.000001 # Table_map # # table_id: # (test.t1)
685 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
686 master-bin.000001 # Table_map # # table_id: # (test.t1)
687 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
688 master-bin.000001 # Table_map # # table_id: # (test.t1)
689 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
690 master-bin.000001 # Table_map # # table_id: # (test.t1)
691 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
692 master-bin.000001 # Table_map # # table_id: # (test.t1)
693 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
694 master-bin.000001 # Table_map # # table_id: # (test.t1)
695 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
696 master-bin.000001 # Table_map # # table_id: # (test.t1)
697 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
698 master-bin.000001 # Table_map # # table_id: # (test.t1)
699 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
700 master-bin.000001 # Table_map # # table_id: # (test.t1)
701 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
702 master-bin.000001 # Table_map # # table_id: # (test.t1)
703 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
704 master-bin.000001 # Table_map # # table_id: # (test.t1)
705 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
706 master-bin.000001 # Table_map # # table_id: # (test.t1)
707 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
708 master-bin.000001 # Table_map # # table_id: # (test.t1)
709 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
710 master-bin.000001 # Table_map # # table_id: # (test.t1)
711 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
712 master-bin.000001 # Table_map # # table_id: # (test.t1)
713 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
714 master-bin.000001 # Table_map # # table_id: # (test.t1)
715 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
716 master-bin.000001 # Table_map # # table_id: # (test.t1)
717 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
718 master-bin.000001 # Table_map # # table_id: # (test.t1)
719 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
720 master-bin.000001 # Table_map # # table_id: # (test.t1)
721 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
722 master-bin.000001 # Table_map # # table_id: # (test.t1)
723 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
724 master-bin.000001 # Table_map # # table_id: # (test.t1)
725 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
726 master-bin.000001 # Table_map # # table_id: # (test.t1)
727 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
728 master-bin.000001 # Table_map # # table_id: # (test.t1)
729 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
730 master-bin.000001 # Table_map # # table_id: # (test.t1)
731 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
732 master-bin.000001 # Table_map # # table_id: # (test.t1)
733 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
734 master-bin.000001 # Table_map # # table_id: # (test.t1)
735 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
736 master-bin.000001 # Table_map # # table_id: # (test.t1)
737 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
738 master-bin.000001 # Table_map # # table_id: # (test.t1)
739 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
740 master-bin.000001 # Table_map # # table_id: # (test.t1)
741 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
742 master-bin.000001 # Table_map # # table_id: # (test.t1)
743 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
744 master-bin.000001 # Table_map # # table_id: # (test.t1)
745 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
746 master-bin.000001 # Table_map # # table_id: # (test.t1)
747 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
748 master-bin.000001 # Table_map # # table_id: # (test.t1)
749 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
750 master-bin.000001 # Table_map # # table_id: # (test.t1)
751 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
752 master-bin.000001 # Table_map # # table_id: # (test.t1)
753 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
754 master-bin.000001 # Table_map # # table_id: # (test.t1)
755 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
756 master-bin.000001 # Table_map # # table_id: # (test.t1)
757 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
758 master-bin.000001 # Table_map # # table_id: # (test.t1)
759 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
760 master-bin.000001 # Table_map # # table_id: # (test.t1)
761 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
762 master-bin.000001 # Table_map # # table_id: # (test.t1)
763 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
764 master-bin.000001 # Table_map # # table_id: # (test.t1)
765 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
766 master-bin.000001 # Table_map # # table_id: # (test.t1)
767 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
768 master-bin.000001 # Table_map # # table_id: # (test.t1)
769 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
770 master-bin.000001 # Table_map # # table_id: # (test.t1)
771 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
772 master-bin.000001 # Table_map # # table_id: # (test.t1)
773 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
774 master-bin.000001 # Table_map # # table_id: # (test.t1)
775 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
776 master-bin.000001 # Table_map # # table_id: # (test.t1)
777 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
778 master-bin.000001 # Table_map # # table_id: # (test.t1)
779 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
780 master-bin.000001 # Table_map # # table_id: # (test.t1)
781 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
782 master-bin.000001 # Table_map # # table_id: # (test.t1)
783 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
784 master-bin.000001 # Table_map # # table_id: # (test.t1)
785 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
786 master-bin.000001 # Table_map # # table_id: # (test.t1)
787 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
788 master-bin.000001 # Table_map # # table_id: # (test.t1)
789 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
790 master-bin.000001 # Table_map # # table_id: # (test.t1)
791 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
792 master-bin.000001 # Table_map # # table_id: # (test.t1)
793 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
794 master-bin.000001 # Table_map # # table_id: # (test.t1)
795 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
796 master-bin.000001 # Table_map # # table_id: # (test.t1)
797 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
798 master-bin.000001 # Table_map # # table_id: # (test.t1)
799 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
800 master-bin.000001 # Table_map # # table_id: # (test.t1)
801 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
802 master-bin.000001 # Table_map # # table_id: # (test.t1)
803 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
804 master-bin.000001 # Table_map # # table_id: # (test.t1)
805 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
806 master-bin.000001 # Table_map # # table_id: # (test.t1)
807 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
808 master-bin.000001 # Table_map # # table_id: # (test.t1)
809 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
810 master-bin.000001 # Table_map # # table_id: # (test.t1)
811 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
812 master-bin.000001 # Table_map # # table_id: # (test.t1)
813 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
814 master-bin.000001 # Table_map # # table_id: # (test.t1)
815 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
816 master-bin.000001 # Table_map # # table_id: # (test.t1)
817 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
818 master-bin.000001 # Table_map # # table_id: # (test.t1)
819 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
820 master-bin.000001 # Table_map # # table_id: # (test.t1)
821 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
822 master-bin.000001 # Table_map # # table_id: # (test.t1)
823 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
824 master-bin.000001 # Table_map # # table_id: # (test.t1)
825 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
826 master-bin.000001 # Table_map # # table_id: # (test.t1)
827 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
828 master-bin.000001 # Table_map # # table_id: # (test.t1)
829 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
830 master-bin.000001 # Table_map # # table_id: # (test.t1)
831 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
832 master-bin.000001 # Table_map # # table_id: # (test.t1)
833 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
834 master-bin.000001 # Table_map # # table_id: # (test.t1)
835 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
836 master-bin.000001 # Table_map # # table_id: # (test.t1)
837 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
838 master-bin.000001 # Table_map # # table_id: # (test.t1)
839 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
840 master-bin.000001 # Table_map # # table_id: # (test.t1)
841 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
842 master-bin.000001 # Table_map # # table_id: # (test.t1)
843 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
844 master-bin.000001 # Table_map # # table_id: # (test.t1)
845 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
846 master-bin.000001 # Table_map # # table_id: # (test.t1)
847 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
848 master-bin.000001 # Table_map # # table_id: # (test.t1)
849 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
850 master-bin.000001 # Table_map # # table_id: # (test.t1)
851 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
852 master-bin.000001 # Table_map # # table_id: # (test.t1)
853 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
854 master-bin.000001 # Table_map # # table_id: # (test.t1)
855 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
856 master-bin.000001 # Table_map # # table_id: # (test.t1)
857 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
858 master-bin.000001 # Table_map # # table_id: # (test.t1)
859 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
860 master-bin.000001 # Table_map # # table_id: # (test.t1)
861 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
862 master-bin.000001 # Table_map # # table_id: # (test.t1)
863 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
864 master-bin.000001 # Table_map # # table_id: # (test.t1)
865 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
866 master-bin.000001 # Table_map # # table_id: # (test.t1)
867 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
868 master-bin.000001 # Table_map # # table_id: # (test.t1)
869 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
870 master-bin.000001 # Table_map # # table_id: # (test.t1)
871 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
872 master-bin.000001 # Table_map # # table_id: # (test.t1)
873 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
874 master-bin.000001 # Table_map # # table_id: # (test.t1)
875 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
876 master-bin.000001 # Table_map # # table_id: # (test.t1)
877 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
878 master-bin.000001 # Table_map # # table_id: # (test.t1)
879 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
880 master-bin.000001 # Table_map # # table_id: # (test.t1)
881 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
882 master-bin.000001 # Table_map # # table_id: # (test.t1)
883 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
884 master-bin.000001 # Table_map # # table_id: # (test.t1)
885 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
886 master-bin.000001 # Table_map # # table_id: # (test.t1)
887 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
888 master-bin.000001 # Table_map # # table_id: # (test.t1)
889 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
890 master-bin.000001 # Table_map # # table_id: # (test.t1)
891 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
892 master-bin.000001 # Table_map # # table_id: # (test.t1)
893 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
894 master-bin.000001 # Table_map # # table_id: # (test.t1)
895 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
896 master-bin.000001 # Table_map # # table_id: # (test.t1)
897 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
898 master-bin.000001 # Table_map # # table_id: # (test.t1)
899 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
900 master-bin.000001 # Table_map # # table_id: # (test.t1)
901 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
902 master-bin.000001 # Table_map # # table_id: # (test.t1)
903 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
904 master-bin.000001 # Table_map # # table_id: # (test.t1)
905 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
906 master-bin.000001 # Table_map # # table_id: # (test.t1)
907 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
908 master-bin.000001 # Table_map # # table_id: # (test.t1)
909 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
910 master-bin.000001 # Table_map # # table_id: # (test.t1)
911 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
912 master-bin.000001 # Table_map # # table_id: # (test.t1)
913 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
914 master-bin.000001 # Table_map # # table_id: # (test.t1)
915 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
916 master-bin.000001 # Table_map # # table_id: # (test.t1)
917 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
918 master-bin.000001 # Table_map # # table_id: # (test.t1)
919 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
920 master-bin.000001 # Table_map # # table_id: # (test.t1)
921 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
922 master-bin.000001 # Table_map # # table_id: # (test.t1)
923 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
924 master-bin.000001 # Table_map # # table_id: # (test.t1)
925 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
926 master-bin.000001 # Table_map # # table_id: # (test.t1)
927 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
928 master-bin.000001 # Table_map # # table_id: # (test.t1)
929 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
930 master-bin.000001 # Table_map # # table_id: # (test.t1)
931 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
932 master-bin.000001 # Table_map # # table_id: # (test.t1)
933 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
934 master-bin.000001 # Table_map # # table_id: # (test.t1)
935 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
936 master-bin.000001 # Table_map # # table_id: # (test.t1)
937 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
938 master-bin.000001 # Table_map # # table_id: # (test.t1)
939 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
940 master-bin.000001 # Table_map # # table_id: # (test.t1)
941 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
942 master-bin.000001 # Table_map # # table_id: # (test.t1)
943 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
944 master-bin.000001 # Table_map # # table_id: # (test.t1)
945 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
946 master-bin.000001 # Table_map # # table_id: # (test.t1)
947 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
948 master-bin.000001 # Table_map # # table_id: # (test.t1)
949 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
950 master-bin.000001 # Table_map # # table_id: # (test.t1)
951 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
952 master-bin.000001 # Table_map # # table_id: # (test.t1)
953 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
954 master-bin.000001 # Table_map # # table_id: # (test.t1)
955 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
956 master-bin.000001 # Table_map # # table_id: # (test.t1)
957 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
958 master-bin.000001 # Table_map # # table_id: # (test.t1)
959 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
960 master-bin.000001 # Table_map # # table_id: # (test.t1)
961 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
962 master-bin.000001 # Table_map # # table_id: # (test.t1)
963 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
964 master-bin.000001 # Table_map # # table_id: # (test.t1)
965 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
966 master-bin.000001 # Table_map # # table_id: # (test.t1)
967 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
968 master-bin.000001 # Table_map # # table_id: # (test.t1)
969 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
970 master-bin.000001 # Table_map # # table_id: # (test.t1)
971 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
972 master-bin.000001 # Table_map # # table_id: # (test.t1)
973 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
974 master-bin.000001 # Table_map # # table_id: # (test.t1)
975 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
976 master-bin.000001 # Table_map # # table_id: # (test.t1)
977 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
978 master-bin.000001 # Table_map # # table_id: # (test.t1)
979 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
980 master-bin.000001 # Table_map # # table_id: # (test.t1)
981 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
982 master-bin.000001 # Table_map # # table_id: # (test.t1)
983 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
984 master-bin.000001 # Table_map # # table_id: # (test.t1)
985 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
986 master-bin.000001 # Table_map # # table_id: # (test.t1)
987 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
988 master-bin.000001 # Table_map # # table_id: # (test.t1)
989 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
990 master-bin.000001 # Table_map # # table_id: # (test.t1)
991 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
992 master-bin.000001 # Table_map # # table_id: # (test.t1)
993 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
994 master-bin.000001 # Table_map # # table_id: # (test.t1)
995 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
996 master-bin.000001 # Table_map # # table_id: # (test.t1)
997 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
998 master-bin.000001 # Table_map # # table_id: # (test.t1)
999 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1000 master-bin.000001 # Table_map # # table_id: # (test.t1)
1001 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1002 master-bin.000001 # Table_map # # table_id: # (test.t1)
1003 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1004 master-bin.000001 # Table_map # # table_id: # (test.t1)
1005 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1006 master-bin.000001 # Table_map # # table_id: # (test.t1)
1007 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1008 master-bin.000001 # Table_map # # table_id: # (test.t1)
1009 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1010 master-bin.000001 # Table_map # # table_id: # (test.t1)
1011 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1012 master-bin.000001 # Table_map # # table_id: # (test.t1)
1013 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1014 master-bin.000001 # Table_map # # table_id: # (test.t1)
1015 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1016 master-bin.000001 # Table_map # # table_id: # (test.t1)
1017 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1018 master-bin.000001 # Table_map # # table_id: # (test.t1)
1019 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1020 master-bin.000001 # Table_map # # table_id: # (test.t1)
1021 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1022 master-bin.000001 # Table_map # # table_id: # (test.t1)
1023 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1024 master-bin.000001 # Table_map # # table_id: # (test.t1)
1025 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1026 master-bin.000001 # Table_map # # table_id: # (test.t1)
1027 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1028 master-bin.000001 # Table_map # # table_id: # (test.t1)
1029 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1030 master-bin.000001 # Table_map # # table_id: # (test.t1)
1031 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1032 master-bin.000001 # Table_map # # table_id: # (test.t1)
1033 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1034 master-bin.000001 # Table_map # # table_id: # (test.t1)
1035 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1036 master-bin.000001 # Table_map # # table_id: # (test.t1)
1037 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1038 master-bin.000001 # Table_map # # table_id: # (test.t1)
1039 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1040 master-bin.000001 # Table_map # # table_id: # (test.t1)
1041 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1042 master-bin.000001 # Table_map # # table_id: # (test.t1)
1043 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1044 master-bin.000001 # Table_map # # table_id: # (test.t1)
1045 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1046 master-bin.000001 # Table_map # # table_id: # (test.t1)
1047 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1048 master-bin.000001 # Table_map # # table_id: # (test.t1)
1049 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1050 master-bin.000001 # Table_map # # table_id: # (test.t1)
1051 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1052 master-bin.000001 # Table_map # # table_id: # (test.t1)
1053 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1054 master-bin.000001 # Table_map # # table_id: # (test.t1)
1055 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1056 master-bin.000001 # Table_map # # table_id: # (test.t1)
1057 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1058 master-bin.000001 # Table_map # # table_id: # (test.t1)
1059 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1060 master-bin.000001 # Table_map # # table_id: # (test.t1)
1061 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1062 master-bin.000001 # Table_map # # table_id: # (test.t1)
1063 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1064 master-bin.000001 # Table_map # # table_id: # (test.t1)
1065 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1066 master-bin.000001 # Table_map # # table_id: # (test.t1)
1067 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1068 master-bin.000001 # Xid # # COMMIT /* XID */
1069 master-bin.000001 # Rotate # # master-bin.000002;pos=4
1070 drop table t1;
1071 set global binlog_cache_size=@bcs;
1072 set session autocommit = @ac;
1073 drop table if exists t1;
1074 reset master;
1075 create table t1 (a bigint unsigned, b bigint(20) unsigned);
1076 prepare stmt from "insert into t1 values (?,?)";
1077 set @a= 9999999999999999;
1078 set @b= 14632475938453979136;
1079 execute stmt using @a, @b;
1080 deallocate prepare stmt;
1081 drop table t1;
1082 show binlog events from <binlog_start>;
1083 Log_name Pos Event_type Server_id End_log_pos Info
1084 master-bin.000001 # Query # # use `test`; create table t1 (a bigint unsigned, b bigint(20) unsigned)
1085 master-bin.000001 # Query # # BEGIN
1086 master-bin.000001 # Table_map # # table_id: # (test.t1)
1087 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1088 master-bin.000001 # Query # # COMMIT
1089 master-bin.000001 # Query # # use `test`; drop table t1
1090 reset master;
1091 CREATE DATABASE bug39182 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
1092 USE bug39182;
1093 CREATE TABLE t1 (a VARCHAR(255) COLLATE utf8_unicode_ci)
1094 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1095 CREATE PROCEDURE p1()
1096 BEGIN
1097 DECLARE s1 VARCHAR(255);
1098 SET s1= "test";
1099 CREATE TEMPORARY TABLE tmp1
1100 SELECT * FROM t1 WHERE a LIKE CONCAT("%", s1, "%");
1101 SELECT
1102 COLLATION(NAME_CONST('s1', _utf8'test')) c1,
1103 COLLATION(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) c2,
1104 COLLATION(s1) c3,
1105 COERCIBILITY(NAME_CONST('s1', _utf8'test')) d1,
1106 COERCIBILITY(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) d2,
1107 COERCIBILITY(s1) d3;
1108 DROP TEMPORARY TABLE tmp1;
1109 END//
1110 CALL p1();
1111 c1 c2 c3 d1 d2 d3
1112 utf8_general_ci utf8_unicode_ci utf8_unicode_ci 2 2 2
1113 show binlog events from <binlog_start>;
1114 Log_name Pos Event_type Server_id End_log_pos Info
1115 master-bin.000001 # Query # # CREATE DATABASE bug39182 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci
1116 master-bin.000001 # Query # # use `bug39182`; CREATE TABLE t1 (a VARCHAR(255) COLLATE utf8_unicode_ci)
1117 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
1118 master-bin.000001 # Query # # use `bug39182`; CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
1119 BEGIN
1120 DECLARE s1 VARCHAR(255);
1121 SET s1= "test";
1122 CREATE TEMPORARY TABLE tmp1
1123 SELECT * FROM t1 WHERE a LIKE CONCAT("%", s1, "%");
1124 SELECT
1125 COLLATION(NAME_CONST('s1', _utf8'test')) c1,
1126 COLLATION(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) c2,
1127 COLLATION(s1) c3,
1128 COERCIBILITY(NAME_CONST('s1', _utf8'test')) d1,
1129 COERCIBILITY(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) d2,
1130 COERCIBILITY(s1) d3;
1131 DROP TEMPORARY TABLE tmp1;
1132 END
1133 DROP PROCEDURE p1;
1134 DROP TABLE t1;
1135 DROP DATABASE bug39182;
1136 USE test;
1137 CREATE PROCEDURE p1(IN v1 INT)
1138 BEGIN
1139 CREATE TABLE t1 SELECT v1;
1140 DROP TABLE t1;
1141 END//
1142 CREATE PROCEDURE p2()
1143 BEGIN
1144 DECLARE v1 INT;
1145 CREATE TABLE t1 SELECT v1+1;
1146 DROP TABLE t1;
1147 END//
1148 CREATE PROCEDURE p3(IN v1 INT)
1149 BEGIN
1150 CREATE TABLE t1 SELECT 1 FROM DUAL WHERE v1!=0;
1151 DROP TABLE t1;
1152 END//
1153 CREATE PROCEDURE p4(IN v1 INT)
1154 BEGIN
1155 DECLARE v2 INT;
1156 CREATE TABLE t1 SELECT 1, v1, v2;
1157 DROP TABLE t1;
1158 CREATE TABLE t1 SELECT 1, v1+1, v2;
1159 DROP TABLE t1;
1160 END//
1161 CALL p1(1);
1162 CALL p2();
1163 CALL p3(0);
1164 CALL p4(0);
1165 DROP PROCEDURE p1;
1166 DROP PROCEDURE p2;
1167 DROP PROCEDURE p3;
1168 DROP PROCEDURE p4;
1169 End of 5.0 tests
1170 reset master;
1171 create table t1 (id tinyint auto_increment primary key);
1172 set insert_id=128;
1173 insert into t1 values(null);
1174 Warnings:
1175 Warning 1264 Out of range value for column 'id' at row 1
1176 select * from t1;
1177 id
1178 127
1179 drop table t1;
1180 create table t1 (a int);
1181 create table if not exists t2 select * from t1;
1182 create temporary table tt1 (a int);
1183 create table if not exists t3 like tt1;
1184 USE mysql;
1185 INSERT INTO user SET host='localhost', user='@#@', password=password('Just a test');
1186 UPDATE user SET password=password('Another password') WHERE host='localhost' AND user='@#@';
1187 DELETE FROM user WHERE host='localhost' AND user='@#@';
1188 use test;
1189 show binlog events from <binlog_start>;
1190 Log_name Pos Event_type Server_id End_log_pos Info
1191 master-bin.000001 # Query # # use `test`; create table t1 (id tinyint auto_increment primary key)
1192 master-bin.000001 # Query # # BEGIN
1193 master-bin.000001 # Table_map # # table_id: # (test.t1)
1194 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1195 master-bin.000001 # Query # # COMMIT
1196 master-bin.000001 # Query # # use `test`; drop table t1
1197 master-bin.000001 # Query # # use `test`; create table t1 (a int)
1198 master-bin.000001 # Query # # BEGIN
1199 master-bin.000001 # Query # # use `test`; CREATE TABLE IF NOT EXISTS `t2` (
1200 `a` int(11) DEFAULT NULL
1201 )
1202 master-bin.000001 # Query # # COMMIT
1203 master-bin.000001 # Query # # use `test`; CREATE TABLE IF NOT EXISTS `t3` (
1204 `a` int(11) DEFAULT NULL
1205 )
1206 master-bin.000001 # Query # # BEGIN
1207 master-bin.000001 # Table_map # # table_id: # (mysql.user)
1208 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1209 master-bin.000001 # Query # # COMMIT
1210 master-bin.000001 # Query # # BEGIN
1211 master-bin.000001 # Table_map # # table_id: # (mysql.user)
1212 master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F
1213 master-bin.000001 # Query # # COMMIT
1214 master-bin.000001 # Query # # BEGIN
1215 master-bin.000001 # Table_map # # table_id: # (mysql.user)
1216 master-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F
1217 master-bin.000001 # Query # # COMMIT
1218 drop table t1,t2,t3,tt1;
1219 create table t1 (a int not null auto_increment, primary key (a)) engine=myisam;
1220 insert delayed into t1 values (207);
1221 insert delayed into t1 values (null);
1222 insert delayed into t1 values (300);
1223 FLUSH TABLES;
1224 show binlog events from <binlog_start>;
1225 Log_name Pos Event_type Server_id End_log_pos Info
1226 master-bin.000001 # Query # # use `test`; create table t1 (id tinyint auto_increment primary key)
1227 master-bin.000001 # Query # # BEGIN
1228 master-bin.000001 # Table_map # # table_id: # (test.t1)
1229 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1230 master-bin.000001 # Query # # COMMIT
1231 master-bin.000001 # Query # # use `test`; drop table t1
1232 master-bin.000001 # Query # # use `test`; create table t1 (a int)
1233 master-bin.000001 # Query # # BEGIN
1234 master-bin.000001 # Query # # use `test`; CREATE TABLE IF NOT EXISTS `t2` (
1235 `a` int(11) DEFAULT NULL
1236 )
1237 master-bin.000001 # Query # # COMMIT
1238 master-bin.000001 # Query # # use `test`; CREATE TABLE IF NOT EXISTS `t3` (
1239 `a` int(11) DEFAULT NULL
1240 )
1241 master-bin.000001 # Query # # BEGIN
1242 master-bin.000001 # Table_map # # table_id: # (mysql.user)
1243 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1244 master-bin.000001 # Query # # COMMIT
1245 master-bin.000001 # Query # # BEGIN
1246 master-bin.000001 # Table_map # # table_id: # (mysql.user)
1247 master-bin.000001 # Update_rows # # table_id: # flags: STMT_END_F
1248 master-bin.000001 # Query # # COMMIT
1249 master-bin.000001 # Query # # BEGIN
1250 master-bin.000001 # Table_map # # table_id: # (mysql.user)
1251 master-bin.000001 # Delete_rows # # table_id: # flags: STMT_END_F
1252 master-bin.000001 # Query # # COMMIT
1253 master-bin.000001 # Query # # use `test`; DROP TABLE `t1`,`t2`,`t3` /* generated by server */
1254 master-bin.000001 # Query # # use `test`; create table t1 (a int not null auto_increment, primary key (a)) engine=myisam
1255 master-bin.000001 # Query # # BEGIN
1256 master-bin.000001 # Table_map # # table_id: # (test.t1)
1257 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1258 master-bin.000001 # Query # # COMMIT
1259 master-bin.000001 # Query # # BEGIN
1260 master-bin.000001 # Table_map # # table_id: # (test.t1)
1261 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1262 master-bin.000001 # Query # # COMMIT
1263 master-bin.000001 # Query # # BEGIN
1264 master-bin.000001 # Table_map # # table_id: # (test.t1)
1265 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1266 master-bin.000001 # Query # # COMMIT
1267 master-bin.000001 # Query # # use `test`; FLUSH TABLES
1268 insert delayed into t1 values (null),(null),(null),(null);
1269 insert delayed into t1 values (null),(null),(400),(null);
1270 select * from t1;
1271 a
1272 207
1273 208
1274 300
1275 301
1276 302
1277 303
1278 304
1279 305
1280 306
1281 400
1282 401
1283 drop table t1;
1284 reset master;
1285 drop table if exists t3;
1286 create table t3 (a int(11) NOT NULL AUTO_INCREMENT, b text, PRIMARY KEY (a) ) engine=innodb;
1287 show master status;
1288 File Position Binlog_Do_DB Binlog_Ignore_DB
1289 master-bin.000001 # <Binlog_Do_DB> <Binlog_Ignore_DB>
1290 insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
1291 insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
1292 insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
1293 insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
1294 show master status;
1295 File Position Binlog_Do_DB Binlog_Ignore_DB
1296 master-bin.000002 # <Binlog_Do_DB> <Binlog_Ignore_DB>
1297 drop table t3;
1298 #
1299 # Bug #45998: database crashes when running "create as select"
1300 #
1301 CREATE DATABASE test1;
1302 USE test1;
1303 DROP DATABASE test1;
1304 CREATE TABLE test.t1(a int);
1305 INSERT INTO test.t1 VALUES (1), (2);
1306 CREATE TABLE test.t2 SELECT * FROM test.t1;
1307 USE test;
1308 DROP TABLES t1, t2;
1309 RESET MASTER;
1310 CREATE TABLE t1 (a INT PRIMARY KEY);
1311 BINLOG '
1312 3u9kSA8KAAAAZgAAAGoAAAABAAQANS4xLjM1LW1hcmlhLWJldGExLWRlYnVnLWxvZwAAAAAAAAAA
1313 AAAAAAAAAAAAAAAAAADe72RIEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC
1314 ';
1315 INSERT INTO t1 VALUES (1);
1316 BINLOG '
1317 3u9kSBMUAAAAKQAAAJEBAAAAABoAAAAAAAAABHRlc3QAAnQxAAEDAAA=
1318 3u9kSBcUAAAAIgAAALMBAAAQABoAAAAAAAEAAf/+AgAAAA==
1319 ';
1320 SHOW BINLOG EVENTS;
1321 Log_name Pos Event_type Server_id End_log_pos Info
1322 # # Format_desc 1 # Server ver: #, Binlog ver: #
1323 # # Query 1 # use `test`; CREATE TABLE t1 (a INT PRIMARY KEY)
1324 # # Query 1 # BEGIN
1325 # # Table_map 1 # table_id: # (test.t1)
1326 # # Write_rows 1 # table_id: # flags: STMT_END_F
1327 # # Query 1 # COMMIT
1328 # # Query 1 # BEGIN
1329 # # Table_map 1 # table_id: # (test.t1)
1330 # # Write_rows 1 # table_id: # flags: STMT_END_F
1331 # # Query 1 # COMMIT
1332 DROP TABLE t1;
1334 # BUG#54903 BINLOG statement toggles session variables
1335 # ----------------------------------------------------------------------
1336 # This test verify that BINLOG statement doesn't change current session's
1337 # variables foreign_key_checks and unique_checks.
1339 CREATE TABLE t1 (c1 INT KEY);
1340 SET @@SESSION.foreign_key_checks= ON;
1341 SET @@SESSION.unique_checks= ON;
1342 # INSERT INTO t1 VALUES (1)
1343 # foreign_key_checks=0 and unique_checks=0
1344 BINLOG '
1345 dfLtTBMBAAAAKQAAANcAAAAAABcAAAAAAAEABHRlc3QAAnQxAAEDAAE=
1346 dfLtTBcBAAAAIgAAAPkAAAAAABcAAAAAAAcAAf/+AQAAAA==
1347 ';
1348 SELECT * FROM t1;
1349 c1
1350 1
1351 # Their values should be ON
1352 SHOW SESSION VARIABLES LIKE "%_checks";
1353 Variable_name Value
1354 foreign_key_checks ON
1355 unique_checks ON
1357 SET @@SESSION.foreign_key_checks= OFF;
1358 SET @@SESSION.unique_checks= OFF;
1359 # INSERT INTO t1 VALUES(2)
1360 # foreign_key_checks=1 and unique_checks=1
1361 BINLOG '
1362 dfLtTBMBAAAAKQAAAKsBAAAAABcAAAAAAAEABHRlc3QAAnQxAAEDAAE=
1363 dfLtTBcBAAAAIgAAAM0BAAAAABcAAAAAAAEAAf/+AgAAAA==
1364 ';
1365 SELECT * FROM t1;
1366 c1
1367 1
1368 2
1369 # Their values should be OFF
1370 SHOW SESSION VARIABLES LIKE "%_checks";
1371 Variable_name Value
1372 foreign_key_checks OFF
1373 unique_checks OFF
1374 # INSERT INTO t1 VALUES(2)
1375 # foreign_key_checks=1 and unique_checks=1
1376 # It should not change current session's variables, even error happens
1377 call mtr.add_suppression("Slave SQL.*Could not execute Write_rows event on table test.t1; Duplicate entry .2. for key .PRIMARY., Error_code: 1062");
1378 BINLOG '
1379 dfLtTBMBAAAAKQAAAKsBAAAAABcAAAAAAAEABHRlc3QAAnQxAAEDAAE=
1380 dfLtTBcBAAAAIgAAAM0BAAAAABcAAAAAAAEAAf/+AgAAAA==
1381 ';
1382 ERROR 23000: Duplicate entry '2' for key 'PRIMARY'
1383 SELECT * FROM t1;
1384 c1
1385 1
1386 2
1387 # Their values should be OFF
1388 SHOW SESSION VARIABLES LIKE "%_checks";
1389 Variable_name Value
1390 foreign_key_checks OFF
1391 unique_checks OFF
1392 DROP TABLE t1;