~drizzle-trunk/drizzle/development

1 by brian
clean slate
1
create table t1 (a int, b int) engine=innodb;
2
begin;
3
insert into t1 values (1,2);
4
commit;
5
show binlog events;
6
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
7
master-bin.000001	4	Format_desc	1	107	Server ver: #, Binlog ver: #
8
master-bin.000001	107	Query	1	214	use `test`; create table t1 (a int, b int) engine=innodb
9
master-bin.000001	214	Query	1	282	use `test`; BEGIN
10
master-bin.000001	282	Query	1	372	use `test`; insert into t1 values (1,2)
11
master-bin.000001	372	Xid	1	399	COMMIT /* XID */
12
drop table t1;
13
drop table if exists t1, t2;
14
reset master;
15
create table t1 (a int) engine=innodb;
16
create table t2 (a int) engine=innodb;
17
begin;
18
insert t1 values (5);
19
commit;
20
begin;
21
insert t2 values (5);
22
commit;
23
show binlog events from <binlog_start>;
24
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
25
master-bin.000001	#	Query	#	#	use `test`; create table t1 (a int) engine=innodb
26
master-bin.000001	#	Query	#	#	use `test`; create table t2 (a int) engine=innodb
27
master-bin.000001	#	Query	#	#	use `test`; BEGIN
28
master-bin.000001	#	Query	#	#	use `test`; insert t1 values (5)
29
master-bin.000001	#	Xid	#	#	COMMIT /* XID */
30
master-bin.000001	#	Query	#	#	use `test`; BEGIN
31
master-bin.000001	#	Query	#	#	use `test`; insert t2 values (5)
32
master-bin.000001	#	Xid	#	#	COMMIT /* XID */
33
drop table t1,t2;
34
reset master;
35
create table t1 (n int) engine=innodb;
36
begin;
37
commit;
38
drop table t1;
39
show binlog events in 'master-bin.000001' from 107;
40
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
41
master-bin.000001	#	Query	1	#	use `test`; create table t1 (n int) engine=innodb
42
master-bin.000001	#	Query	1	#	use `test`; BEGIN
43
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(100 + 4)
44
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(99 + 4)
45
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(98 + 4)
46
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(97 + 4)
47
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(96 + 4)
48
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(95 + 4)
49
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(94 + 4)
50
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(93 + 4)
51
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(92 + 4)
52
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(91 + 4)
53
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(90 + 4)
54
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(89 + 4)
55
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(88 + 4)
56
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(87 + 4)
57
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(86 + 4)
58
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(85 + 4)
59
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(84 + 4)
60
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(83 + 4)
61
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(82 + 4)
62
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(81 + 4)
63
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(80 + 4)
64
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(79 + 4)
65
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(78 + 4)
66
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(77 + 4)
67
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(76 + 4)
68
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(75 + 4)
69
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(74 + 4)
70
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(73 + 4)
71
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(72 + 4)
72
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(71 + 4)
73
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(70 + 4)
74
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(69 + 4)
75
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(68 + 4)
76
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(67 + 4)
77
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(66 + 4)
78
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(65 + 4)
79
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(64 + 4)
80
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(63 + 4)
81
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(62 + 4)
82
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(61 + 4)
83
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(60 + 4)
84
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(59 + 4)
85
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(58 + 4)
86
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(57 + 4)
87
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(56 + 4)
88
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(55 + 4)
89
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(54 + 4)
90
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(53 + 4)
91
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(52 + 4)
92
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(51 + 4)
93
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(50 + 4)
94
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(49 + 4)
95
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(48 + 4)
96
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(47 + 4)
97
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(46 + 4)
98
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(45 + 4)
99
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(44 + 4)
100
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(43 + 4)
101
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(42 + 4)
102
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(41 + 4)
103
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(40 + 4)
104
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(39 + 4)
105
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(38 + 4)
106
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(37 + 4)
107
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(36 + 4)
108
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(35 + 4)
109
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(34 + 4)
110
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(33 + 4)
111
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(32 + 4)
112
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(31 + 4)
113
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(30 + 4)
114
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(29 + 4)
115
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(28 + 4)
116
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(27 + 4)
117
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(26 + 4)
118
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(25 + 4)
119
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(24 + 4)
120
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(23 + 4)
121
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(22 + 4)
122
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(21 + 4)
123
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(20 + 4)
124
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(19 + 4)
125
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(18 + 4)
126
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(17 + 4)
127
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(16 + 4)
128
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(15 + 4)
129
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(14 + 4)
130
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(13 + 4)
131
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(12 + 4)
132
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(11 + 4)
133
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(10 + 4)
134
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(9 + 4)
135
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(8 + 4)
136
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(7 + 4)
137
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(6 + 4)
138
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(5 + 4)
139
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(4 + 4)
140
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(3 + 4)
141
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(2 + 4)
142
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values(1 + 4)
143
master-bin.000001	#	Xid	1	#	COMMIT /* xid= */
144
master-bin.000001	#	Rotate	1	#	master-bin.000002;pos=4
145
show binlog events in 'master-bin.000002' from 107;
146
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
147
master-bin.000002	#	Query	1	#	use `test`; drop table t1
148
set @ac = @@autocommit;
149
set autocommit= 0;
150
reset master;
151
create table t1(n int) engine=innodb;
152
begin;
153
insert into t1 values (1);
154
insert into t1 values (2);
155
insert into t1 values (3);
156
commit;
157
drop table t1;
158
show binlog events from 0;
159
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
160
master-bin.000001	4	Format_desc	1	107	Server version, Binlog ver: 4
161
master-bin.000001	107	Query	1	206	use `test`; create table t1(n int) engine=innodb
162
master-bin.000001	206	Query	1	274	use `test`; BEGIN
163
master-bin.000001	274	Query	1	362	use `test`; insert into t1 values (1)
164
master-bin.000001	362	Query	1	450	use `test`; insert into t1 values (2)
165
master-bin.000001	450	Query	1	538	use `test`; insert into t1 values (3)
166
master-bin.000001	538	Xid	1	565	COMMIT /* XID */
167
master-bin.000001	565	Query	1	641	use `test`; drop table t1
168
set @bcs = @@binlog_cache_size;
169
set global binlog_cache_size=4096;
170
reset master;
171
create table t1 (a int) engine=innodb;
172
show binlog events from 0;
173
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
174
master-bin.000001	4	Format_desc	1	107	Server version, Binlog ver: 4
175
master-bin.000001	107	Query	1	207	use `test`; create table t1 (a int) engine=innodb
176
master-bin.000001	207	Query	1	275	use `test`; BEGIN
177
master-bin.000001	275	Query	1	366	use `test`; insert into t1 values( 400 )
178
master-bin.000001	366	Query	1	457	use `test`; insert into t1 values( 399 )
179
master-bin.000001	457	Query	1	548	use `test`; insert into t1 values( 398 )
180
master-bin.000001	548	Query	1	639	use `test`; insert into t1 values( 397 )
181
master-bin.000001	639	Query	1	730	use `test`; insert into t1 values( 396 )
182
master-bin.000001	730	Query	1	821	use `test`; insert into t1 values( 395 )
183
master-bin.000001	821	Query	1	912	use `test`; insert into t1 values( 394 )
184
master-bin.000001	912	Query	1	1003	use `test`; insert into t1 values( 393 )
185
master-bin.000001	1003	Query	1	1094	use `test`; insert into t1 values( 392 )
186
master-bin.000001	1094	Query	1	1185	use `test`; insert into t1 values( 391 )
187
master-bin.000001	1185	Query	1	1276	use `test`; insert into t1 values( 390 )
188
master-bin.000001	1276	Query	1	1367	use `test`; insert into t1 values( 389 )
189
master-bin.000001	1367	Query	1	1458	use `test`; insert into t1 values( 388 )
190
master-bin.000001	1458	Query	1	1549	use `test`; insert into t1 values( 387 )
191
master-bin.000001	1549	Query	1	1640	use `test`; insert into t1 values( 386 )
192
master-bin.000001	1640	Query	1	1731	use `test`; insert into t1 values( 385 )
193
master-bin.000001	1731	Query	1	1822	use `test`; insert into t1 values( 384 )
194
master-bin.000001	1822	Query	1	1913	use `test`; insert into t1 values( 383 )
195
master-bin.000001	1913	Query	1	2004	use `test`; insert into t1 values( 382 )
196
master-bin.000001	2004	Query	1	2095	use `test`; insert into t1 values( 381 )
197
master-bin.000001	2095	Query	1	2186	use `test`; insert into t1 values( 380 )
198
master-bin.000001	2186	Query	1	2277	use `test`; insert into t1 values( 379 )
199
master-bin.000001	2277	Query	1	2368	use `test`; insert into t1 values( 378 )
200
master-bin.000001	2368	Query	1	2459	use `test`; insert into t1 values( 377 )
201
master-bin.000001	2459	Query	1	2550	use `test`; insert into t1 values( 376 )
202
master-bin.000001	2550	Query	1	2641	use `test`; insert into t1 values( 375 )
203
master-bin.000001	2641	Query	1	2732	use `test`; insert into t1 values( 374 )
204
master-bin.000001	2732	Query	1	2823	use `test`; insert into t1 values( 373 )
205
master-bin.000001	2823	Query	1	2914	use `test`; insert into t1 values( 372 )
206
master-bin.000001	2914	Query	1	3005	use `test`; insert into t1 values( 371 )
207
master-bin.000001	3005	Query	1	3096	use `test`; insert into t1 values( 370 )
208
master-bin.000001	3096	Query	1	3187	use `test`; insert into t1 values( 369 )
209
master-bin.000001	3187	Query	1	3278	use `test`; insert into t1 values( 368 )
210
master-bin.000001	3278	Query	1	3369	use `test`; insert into t1 values( 367 )
211
master-bin.000001	3369	Query	1	3460	use `test`; insert into t1 values( 366 )
212
master-bin.000001	3460	Query	1	3551	use `test`; insert into t1 values( 365 )
213
master-bin.000001	3551	Query	1	3642	use `test`; insert into t1 values( 364 )
214
master-bin.000001	3642	Query	1	3733	use `test`; insert into t1 values( 363 )
215
master-bin.000001	3733	Query	1	3824	use `test`; insert into t1 values( 362 )
216
master-bin.000001	3824	Query	1	3915	use `test`; insert into t1 values( 361 )
217
master-bin.000001	3915	Query	1	4006	use `test`; insert into t1 values( 360 )
218
master-bin.000001	4006	Query	1	4097	use `test`; insert into t1 values( 359 )
219
master-bin.000001	4097	Query	1	4188	use `test`; insert into t1 values( 358 )
220
master-bin.000001	4188	Query	1	4279	use `test`; insert into t1 values( 357 )
221
master-bin.000001	4279	Query	1	4370	use `test`; insert into t1 values( 356 )
222
master-bin.000001	4370	Query	1	4461	use `test`; insert into t1 values( 355 )
223
master-bin.000001	4461	Query	1	4552	use `test`; insert into t1 values( 354 )
224
master-bin.000001	4552	Query	1	4643	use `test`; insert into t1 values( 353 )
225
master-bin.000001	4643	Query	1	4734	use `test`; insert into t1 values( 352 )
226
master-bin.000001	4734	Query	1	4825	use `test`; insert into t1 values( 351 )
227
master-bin.000001	4825	Query	1	4916	use `test`; insert into t1 values( 350 )
228
master-bin.000001	4916	Query	1	5007	use `test`; insert into t1 values( 349 )
229
master-bin.000001	5007	Query	1	5098	use `test`; insert into t1 values( 348 )
230
master-bin.000001	5098	Query	1	5189	use `test`; insert into t1 values( 347 )
231
master-bin.000001	5189	Query	1	5280	use `test`; insert into t1 values( 346 )
232
master-bin.000001	5280	Query	1	5371	use `test`; insert into t1 values( 345 )
233
master-bin.000001	5371	Query	1	5462	use `test`; insert into t1 values( 344 )
234
master-bin.000001	5462	Query	1	5553	use `test`; insert into t1 values( 343 )
235
master-bin.000001	5553	Query	1	5644	use `test`; insert into t1 values( 342 )
236
master-bin.000001	5644	Query	1	5735	use `test`; insert into t1 values( 341 )
237
master-bin.000001	5735	Query	1	5826	use `test`; insert into t1 values( 340 )
238
master-bin.000001	5826	Query	1	5917	use `test`; insert into t1 values( 339 )
239
master-bin.000001	5917	Query	1	6008	use `test`; insert into t1 values( 338 )
240
master-bin.000001	6008	Query	1	6099	use `test`; insert into t1 values( 337 )
241
master-bin.000001	6099	Query	1	6190	use `test`; insert into t1 values( 336 )
242
master-bin.000001	6190	Query	1	6281	use `test`; insert into t1 values( 335 )
243
master-bin.000001	6281	Query	1	6372	use `test`; insert into t1 values( 334 )
244
master-bin.000001	6372	Query	1	6463	use `test`; insert into t1 values( 333 )
245
master-bin.000001	6463	Query	1	6554	use `test`; insert into t1 values( 332 )
246
master-bin.000001	6554	Query	1	6645	use `test`; insert into t1 values( 331 )
247
master-bin.000001	6645	Query	1	6736	use `test`; insert into t1 values( 330 )
248
master-bin.000001	6736	Query	1	6827	use `test`; insert into t1 values( 329 )
249
master-bin.000001	6827	Query	1	6918	use `test`; insert into t1 values( 328 )
250
master-bin.000001	6918	Query	1	7009	use `test`; insert into t1 values( 327 )
251
master-bin.000001	7009	Query	1	7100	use `test`; insert into t1 values( 326 )
252
master-bin.000001	7100	Query	1	7191	use `test`; insert into t1 values( 325 )
253
master-bin.000001	7191	Query	1	7282	use `test`; insert into t1 values( 324 )
254
master-bin.000001	7282	Query	1	7373	use `test`; insert into t1 values( 323 )
255
master-bin.000001	7373	Query	1	7464	use `test`; insert into t1 values( 322 )
256
master-bin.000001	7464	Query	1	7555	use `test`; insert into t1 values( 321 )
257
master-bin.000001	7555	Query	1	7646	use `test`; insert into t1 values( 320 )
258
master-bin.000001	7646	Query	1	7737	use `test`; insert into t1 values( 319 )
259
master-bin.000001	7737	Query	1	7828	use `test`; insert into t1 values( 318 )
260
master-bin.000001	7828	Query	1	7919	use `test`; insert into t1 values( 317 )
261
master-bin.000001	7919	Query	1	8010	use `test`; insert into t1 values( 316 )
262
master-bin.000001	8010	Query	1	8101	use `test`; insert into t1 values( 315 )
263
master-bin.000001	8101	Query	1	8192	use `test`; insert into t1 values( 314 )
264
master-bin.000001	8192	Query	1	8283	use `test`; insert into t1 values( 313 )
265
master-bin.000001	8283	Query	1	8374	use `test`; insert into t1 values( 312 )
266
master-bin.000001	8374	Query	1	8465	use `test`; insert into t1 values( 311 )
267
master-bin.000001	8465	Query	1	8556	use `test`; insert into t1 values( 310 )
268
master-bin.000001	8556	Query	1	8647	use `test`; insert into t1 values( 309 )
269
master-bin.000001	8647	Query	1	8738	use `test`; insert into t1 values( 308 )
270
master-bin.000001	8738	Query	1	8829	use `test`; insert into t1 values( 307 )
271
master-bin.000001	8829	Query	1	8920	use `test`; insert into t1 values( 306 )
272
master-bin.000001	8920	Query	1	9011	use `test`; insert into t1 values( 305 )
273
master-bin.000001	9011	Query	1	9102	use `test`; insert into t1 values( 304 )
274
master-bin.000001	9102	Query	1	9193	use `test`; insert into t1 values( 303 )
275
master-bin.000001	9193	Query	1	9284	use `test`; insert into t1 values( 302 )
276
master-bin.000001	9284	Query	1	9375	use `test`; insert into t1 values( 301 )
277
master-bin.000001	9375	Query	1	9466	use `test`; insert into t1 values( 300 )
278
master-bin.000001	9466	Query	1	9557	use `test`; insert into t1 values( 299 )
279
master-bin.000001	9557	Query	1	9648	use `test`; insert into t1 values( 298 )
280
master-bin.000001	9648	Query	1	9739	use `test`; insert into t1 values( 297 )
281
master-bin.000001	9739	Query	1	9830	use `test`; insert into t1 values( 296 )
282
master-bin.000001	9830	Query	1	9921	use `test`; insert into t1 values( 295 )
283
master-bin.000001	9921	Query	1	10012	use `test`; insert into t1 values( 294 )
284
master-bin.000001	10012	Query	1	10103	use `test`; insert into t1 values( 293 )
285
master-bin.000001	10103	Query	1	10194	use `test`; insert into t1 values( 292 )
286
master-bin.000001	10194	Query	1	10285	use `test`; insert into t1 values( 291 )
287
master-bin.000001	10285	Query	1	10376	use `test`; insert into t1 values( 290 )
288
master-bin.000001	10376	Query	1	10467	use `test`; insert into t1 values( 289 )
289
master-bin.000001	10467	Query	1	10558	use `test`; insert into t1 values( 288 )
290
master-bin.000001	10558	Query	1	10649	use `test`; insert into t1 values( 287 )
291
master-bin.000001	10649	Query	1	10740	use `test`; insert into t1 values( 286 )
292
master-bin.000001	10740	Query	1	10831	use `test`; insert into t1 values( 285 )
293
master-bin.000001	10831	Query	1	10922	use `test`; insert into t1 values( 284 )
294
master-bin.000001	10922	Query	1	11013	use `test`; insert into t1 values( 283 )
295
master-bin.000001	11013	Query	1	11104	use `test`; insert into t1 values( 282 )
296
master-bin.000001	11104	Query	1	11195	use `test`; insert into t1 values( 281 )
297
master-bin.000001	11195	Query	1	11286	use `test`; insert into t1 values( 280 )
298
master-bin.000001	11286	Query	1	11377	use `test`; insert into t1 values( 279 )
299
master-bin.000001	11377	Query	1	11468	use `test`; insert into t1 values( 278 )
300
master-bin.000001	11468	Query	1	11559	use `test`; insert into t1 values( 277 )
301
master-bin.000001	11559	Query	1	11650	use `test`; insert into t1 values( 276 )
302
master-bin.000001	11650	Query	1	11741	use `test`; insert into t1 values( 275 )
303
master-bin.000001	11741	Query	1	11832	use `test`; insert into t1 values( 274 )
304
master-bin.000001	11832	Query	1	11923	use `test`; insert into t1 values( 273 )
305
master-bin.000001	11923	Query	1	12014	use `test`; insert into t1 values( 272 )
306
master-bin.000001	12014	Query	1	12105	use `test`; insert into t1 values( 271 )
307
master-bin.000001	12105	Query	1	12196	use `test`; insert into t1 values( 270 )
308
master-bin.000001	12196	Query	1	12287	use `test`; insert into t1 values( 269 )
309
master-bin.000001	12287	Query	1	12378	use `test`; insert into t1 values( 268 )
310
master-bin.000001	12378	Query	1	12469	use `test`; insert into t1 values( 267 )
311
master-bin.000001	12469	Query	1	12560	use `test`; insert into t1 values( 266 )
312
master-bin.000001	12560	Query	1	12651	use `test`; insert into t1 values( 265 )
313
master-bin.000001	12651	Query	1	12742	use `test`; insert into t1 values( 264 )
314
master-bin.000001	12742	Query	1	12833	use `test`; insert into t1 values( 263 )
315
master-bin.000001	12833	Query	1	12924	use `test`; insert into t1 values( 262 )
316
master-bin.000001	12924	Query	1	13015	use `test`; insert into t1 values( 261 )
317
master-bin.000001	13015	Query	1	13106	use `test`; insert into t1 values( 260 )
318
master-bin.000001	13106	Query	1	13197	use `test`; insert into t1 values( 259 )
319
master-bin.000001	13197	Query	1	13288	use `test`; insert into t1 values( 258 )
320
master-bin.000001	13288	Query	1	13379	use `test`; insert into t1 values( 257 )
321
master-bin.000001	13379	Query	1	13470	use `test`; insert into t1 values( 256 )
322
master-bin.000001	13470	Query	1	13561	use `test`; insert into t1 values( 255 )
323
master-bin.000001	13561	Query	1	13652	use `test`; insert into t1 values( 254 )
324
master-bin.000001	13652	Query	1	13743	use `test`; insert into t1 values( 253 )
325
master-bin.000001	13743	Query	1	13834	use `test`; insert into t1 values( 252 )
326
master-bin.000001	13834	Query	1	13925	use `test`; insert into t1 values( 251 )
327
master-bin.000001	13925	Query	1	14016	use `test`; insert into t1 values( 250 )
328
master-bin.000001	14016	Query	1	14107	use `test`; insert into t1 values( 249 )
329
master-bin.000001	14107	Query	1	14198	use `test`; insert into t1 values( 248 )
330
master-bin.000001	14198	Query	1	14289	use `test`; insert into t1 values( 247 )
331
master-bin.000001	14289	Query	1	14380	use `test`; insert into t1 values( 246 )
332
master-bin.000001	14380	Query	1	14471	use `test`; insert into t1 values( 245 )
333
master-bin.000001	14471	Query	1	14562	use `test`; insert into t1 values( 244 )
334
master-bin.000001	14562	Query	1	14653	use `test`; insert into t1 values( 243 )
335
master-bin.000001	14653	Query	1	14744	use `test`; insert into t1 values( 242 )
336
master-bin.000001	14744	Query	1	14835	use `test`; insert into t1 values( 241 )
337
master-bin.000001	14835	Query	1	14926	use `test`; insert into t1 values( 240 )
338
master-bin.000001	14926	Query	1	15017	use `test`; insert into t1 values( 239 )
339
master-bin.000001	15017	Query	1	15108	use `test`; insert into t1 values( 238 )
340
master-bin.000001	15108	Query	1	15199	use `test`; insert into t1 values( 237 )
341
master-bin.000001	15199	Query	1	15290	use `test`; insert into t1 values( 236 )
342
master-bin.000001	15290	Query	1	15381	use `test`; insert into t1 values( 235 )
343
master-bin.000001	15381	Query	1	15472	use `test`; insert into t1 values( 234 )
344
master-bin.000001	15472	Query	1	15563	use `test`; insert into t1 values( 233 )
345
master-bin.000001	15563	Query	1	15654	use `test`; insert into t1 values( 232 )
346
master-bin.000001	15654	Query	1	15745	use `test`; insert into t1 values( 231 )
347
master-bin.000001	15745	Query	1	15836	use `test`; insert into t1 values( 230 )
348
master-bin.000001	15836	Query	1	15927	use `test`; insert into t1 values( 229 )
349
master-bin.000001	15927	Query	1	16018	use `test`; insert into t1 values( 228 )
350
master-bin.000001	16018	Query	1	16109	use `test`; insert into t1 values( 227 )
351
master-bin.000001	16109	Query	1	16200	use `test`; insert into t1 values( 226 )
352
master-bin.000001	16200	Query	1	16291	use `test`; insert into t1 values( 225 )
353
master-bin.000001	16291	Query	1	16382	use `test`; insert into t1 values( 224 )
354
master-bin.000001	16382	Query	1	16473	use `test`; insert into t1 values( 223 )
355
master-bin.000001	16473	Query	1	16564	use `test`; insert into t1 values( 222 )
356
master-bin.000001	16564	Query	1	16655	use `test`; insert into t1 values( 221 )
357
master-bin.000001	16655	Query	1	16746	use `test`; insert into t1 values( 220 )
358
master-bin.000001	16746	Query	1	16837	use `test`; insert into t1 values( 219 )
359
master-bin.000001	16837	Query	1	16928	use `test`; insert into t1 values( 218 )
360
master-bin.000001	16928	Query	1	17019	use `test`; insert into t1 values( 217 )
361
master-bin.000001	17019	Query	1	17110	use `test`; insert into t1 values( 216 )
362
master-bin.000001	17110	Query	1	17201	use `test`; insert into t1 values( 215 )
363
master-bin.000001	17201	Query	1	17292	use `test`; insert into t1 values( 214 )
364
master-bin.000001	17292	Query	1	17383	use `test`; insert into t1 values( 213 )
365
master-bin.000001	17383	Query	1	17474	use `test`; insert into t1 values( 212 )
366
master-bin.000001	17474	Query	1	17565	use `test`; insert into t1 values( 211 )
367
master-bin.000001	17565	Query	1	17656	use `test`; insert into t1 values( 210 )
368
master-bin.000001	17656	Query	1	17747	use `test`; insert into t1 values( 209 )
369
master-bin.000001	17747	Query	1	17838	use `test`; insert into t1 values( 208 )
370
master-bin.000001	17838	Query	1	17929	use `test`; insert into t1 values( 207 )
371
master-bin.000001	17929	Query	1	18020	use `test`; insert into t1 values( 206 )
372
master-bin.000001	18020	Query	1	18111	use `test`; insert into t1 values( 205 )
373
master-bin.000001	18111	Query	1	18202	use `test`; insert into t1 values( 204 )
374
master-bin.000001	18202	Query	1	18293	use `test`; insert into t1 values( 203 )
375
master-bin.000001	18293	Query	1	18384	use `test`; insert into t1 values( 202 )
376
master-bin.000001	18384	Query	1	18475	use `test`; insert into t1 values( 201 )
377
master-bin.000001	18475	Query	1	18566	use `test`; insert into t1 values( 200 )
378
master-bin.000001	18566	Query	1	18657	use `test`; insert into t1 values( 199 )
379
master-bin.000001	18657	Query	1	18748	use `test`; insert into t1 values( 198 )
380
master-bin.000001	18748	Query	1	18839	use `test`; insert into t1 values( 197 )
381
master-bin.000001	18839	Query	1	18930	use `test`; insert into t1 values( 196 )
382
master-bin.000001	18930	Query	1	19021	use `test`; insert into t1 values( 195 )
383
master-bin.000001	19021	Query	1	19112	use `test`; insert into t1 values( 194 )
384
master-bin.000001	19112	Query	1	19203	use `test`; insert into t1 values( 193 )
385
master-bin.000001	19203	Query	1	19294	use `test`; insert into t1 values( 192 )
386
master-bin.000001	19294	Query	1	19385	use `test`; insert into t1 values( 191 )
387
master-bin.000001	19385	Query	1	19476	use `test`; insert into t1 values( 190 )
388
master-bin.000001	19476	Query	1	19567	use `test`; insert into t1 values( 189 )
389
master-bin.000001	19567	Query	1	19658	use `test`; insert into t1 values( 188 )
390
master-bin.000001	19658	Query	1	19749	use `test`; insert into t1 values( 187 )
391
master-bin.000001	19749	Query	1	19840	use `test`; insert into t1 values( 186 )
392
master-bin.000001	19840	Query	1	19931	use `test`; insert into t1 values( 185 )
393
master-bin.000001	19931	Query	1	20022	use `test`; insert into t1 values( 184 )
394
master-bin.000001	20022	Query	1	20113	use `test`; insert into t1 values( 183 )
395
master-bin.000001	20113	Query	1	20204	use `test`; insert into t1 values( 182 )
396
master-bin.000001	20204	Query	1	20295	use `test`; insert into t1 values( 181 )
397
master-bin.000001	20295	Query	1	20386	use `test`; insert into t1 values( 180 )
398
master-bin.000001	20386	Query	1	20477	use `test`; insert into t1 values( 179 )
399
master-bin.000001	20477	Query	1	20568	use `test`; insert into t1 values( 178 )
400
master-bin.000001	20568	Query	1	20659	use `test`; insert into t1 values( 177 )
401
master-bin.000001	20659	Query	1	20750	use `test`; insert into t1 values( 176 )
402
master-bin.000001	20750	Query	1	20841	use `test`; insert into t1 values( 175 )
403
master-bin.000001	20841	Query	1	20932	use `test`; insert into t1 values( 174 )
404
master-bin.000001	20932	Query	1	21023	use `test`; insert into t1 values( 173 )
405
master-bin.000001	21023	Query	1	21114	use `test`; insert into t1 values( 172 )
406
master-bin.000001	21114	Query	1	21205	use `test`; insert into t1 values( 171 )
407
master-bin.000001	21205	Query	1	21296	use `test`; insert into t1 values( 170 )
408
master-bin.000001	21296	Query	1	21387	use `test`; insert into t1 values( 169 )
409
master-bin.000001	21387	Query	1	21478	use `test`; insert into t1 values( 168 )
410
master-bin.000001	21478	Query	1	21569	use `test`; insert into t1 values( 167 )
411
master-bin.000001	21569	Query	1	21660	use `test`; insert into t1 values( 166 )
412
master-bin.000001	21660	Query	1	21751	use `test`; insert into t1 values( 165 )
413
master-bin.000001	21751	Query	1	21842	use `test`; insert into t1 values( 164 )
414
master-bin.000001	21842	Query	1	21933	use `test`; insert into t1 values( 163 )
415
master-bin.000001	21933	Query	1	22024	use `test`; insert into t1 values( 162 )
416
master-bin.000001	22024	Query	1	22115	use `test`; insert into t1 values( 161 )
417
master-bin.000001	22115	Query	1	22206	use `test`; insert into t1 values( 160 )
418
master-bin.000001	22206	Query	1	22297	use `test`; insert into t1 values( 159 )
419
master-bin.000001	22297	Query	1	22388	use `test`; insert into t1 values( 158 )
420
master-bin.000001	22388	Query	1	22479	use `test`; insert into t1 values( 157 )
421
master-bin.000001	22479	Query	1	22570	use `test`; insert into t1 values( 156 )
422
master-bin.000001	22570	Query	1	22661	use `test`; insert into t1 values( 155 )
423
master-bin.000001	22661	Query	1	22752	use `test`; insert into t1 values( 154 )
424
master-bin.000001	22752	Query	1	22843	use `test`; insert into t1 values( 153 )
425
master-bin.000001	22843	Query	1	22934	use `test`; insert into t1 values( 152 )
426
master-bin.000001	22934	Query	1	23025	use `test`; insert into t1 values( 151 )
427
master-bin.000001	23025	Query	1	23116	use `test`; insert into t1 values( 150 )
428
master-bin.000001	23116	Query	1	23207	use `test`; insert into t1 values( 149 )
429
master-bin.000001	23207	Query	1	23298	use `test`; insert into t1 values( 148 )
430
master-bin.000001	23298	Query	1	23389	use `test`; insert into t1 values( 147 )
431
master-bin.000001	23389	Query	1	23480	use `test`; insert into t1 values( 146 )
432
master-bin.000001	23480	Query	1	23571	use `test`; insert into t1 values( 145 )
433
master-bin.000001	23571	Query	1	23662	use `test`; insert into t1 values( 144 )
434
master-bin.000001	23662	Query	1	23753	use `test`; insert into t1 values( 143 )
435
master-bin.000001	23753	Query	1	23844	use `test`; insert into t1 values( 142 )
436
master-bin.000001	23844	Query	1	23935	use `test`; insert into t1 values( 141 )
437
master-bin.000001	23935	Query	1	24026	use `test`; insert into t1 values( 140 )
438
master-bin.000001	24026	Query	1	24117	use `test`; insert into t1 values( 139 )
439
master-bin.000001	24117	Query	1	24208	use `test`; insert into t1 values( 138 )
440
master-bin.000001	24208	Query	1	24299	use `test`; insert into t1 values( 137 )
441
master-bin.000001	24299	Query	1	24390	use `test`; insert into t1 values( 136 )
442
master-bin.000001	24390	Query	1	24481	use `test`; insert into t1 values( 135 )
443
master-bin.000001	24481	Query	1	24572	use `test`; insert into t1 values( 134 )
444
master-bin.000001	24572	Query	1	24663	use `test`; insert into t1 values( 133 )
445
master-bin.000001	24663	Query	1	24754	use `test`; insert into t1 values( 132 )
446
master-bin.000001	24754	Query	1	24845	use `test`; insert into t1 values( 131 )
447
master-bin.000001	24845	Query	1	24936	use `test`; insert into t1 values( 130 )
448
master-bin.000001	24936	Query	1	25027	use `test`; insert into t1 values( 129 )
449
master-bin.000001	25027	Query	1	25118	use `test`; insert into t1 values( 128 )
450
master-bin.000001	25118	Query	1	25209	use `test`; insert into t1 values( 127 )
451
master-bin.000001	25209	Query	1	25300	use `test`; insert into t1 values( 126 )
452
master-bin.000001	25300	Query	1	25391	use `test`; insert into t1 values( 125 )
453
master-bin.000001	25391	Query	1	25482	use `test`; insert into t1 values( 124 )
454
master-bin.000001	25482	Query	1	25573	use `test`; insert into t1 values( 123 )
455
master-bin.000001	25573	Query	1	25664	use `test`; insert into t1 values( 122 )
456
master-bin.000001	25664	Query	1	25755	use `test`; insert into t1 values( 121 )
457
master-bin.000001	25755	Query	1	25846	use `test`; insert into t1 values( 120 )
458
master-bin.000001	25846	Query	1	25937	use `test`; insert into t1 values( 119 )
459
master-bin.000001	25937	Query	1	26028	use `test`; insert into t1 values( 118 )
460
master-bin.000001	26028	Query	1	26119	use `test`; insert into t1 values( 117 )
461
master-bin.000001	26119	Query	1	26210	use `test`; insert into t1 values( 116 )
462
master-bin.000001	26210	Query	1	26301	use `test`; insert into t1 values( 115 )
463
master-bin.000001	26301	Query	1	26392	use `test`; insert into t1 values( 114 )
464
master-bin.000001	26392	Query	1	26483	use `test`; insert into t1 values( 113 )
465
master-bin.000001	26483	Query	1	26574	use `test`; insert into t1 values( 112 )
466
master-bin.000001	26574	Query	1	26665	use `test`; insert into t1 values( 111 )
467
master-bin.000001	26665	Query	1	26756	use `test`; insert into t1 values( 110 )
468
master-bin.000001	26756	Query	1	26847	use `test`; insert into t1 values( 109 )
469
master-bin.000001	26847	Query	1	26938	use `test`; insert into t1 values( 108 )
470
master-bin.000001	26938	Query	1	27029	use `test`; insert into t1 values( 107 )
471
master-bin.000001	27029	Query	1	27120	use `test`; insert into t1 values( 106 )
472
master-bin.000001	27120	Query	1	27211	use `test`; insert into t1 values( 105 )
473
master-bin.000001	27211	Query	1	27302	use `test`; insert into t1 values( 104 )
474
master-bin.000001	27302	Query	1	27393	use `test`; insert into t1 values( 103 )
475
master-bin.000001	27393	Query	1	27484	use `test`; insert into t1 values( 102 )
476
master-bin.000001	27484	Query	1	27575	use `test`; insert into t1 values( 101 )
477
master-bin.000001	27575	Query	1	27666	use `test`; insert into t1 values( 100 )
478
master-bin.000001	27666	Query	1	27756	use `test`; insert into t1 values( 99 )
479
master-bin.000001	27756	Query	1	27846	use `test`; insert into t1 values( 98 )
480
master-bin.000001	27846	Query	1	27936	use `test`; insert into t1 values( 97 )
481
master-bin.000001	27936	Query	1	28026	use `test`; insert into t1 values( 96 )
482
master-bin.000001	28026	Query	1	28116	use `test`; insert into t1 values( 95 )
483
master-bin.000001	28116	Query	1	28206	use `test`; insert into t1 values( 94 )
484
master-bin.000001	28206	Query	1	28296	use `test`; insert into t1 values( 93 )
485
master-bin.000001	28296	Query	1	28386	use `test`; insert into t1 values( 92 )
486
master-bin.000001	28386	Query	1	28476	use `test`; insert into t1 values( 91 )
487
master-bin.000001	28476	Query	1	28566	use `test`; insert into t1 values( 90 )
488
master-bin.000001	28566	Query	1	28656	use `test`; insert into t1 values( 89 )
489
master-bin.000001	28656	Query	1	28746	use `test`; insert into t1 values( 88 )
490
master-bin.000001	28746	Query	1	28836	use `test`; insert into t1 values( 87 )
491
master-bin.000001	28836	Query	1	28926	use `test`; insert into t1 values( 86 )
492
master-bin.000001	28926	Query	1	29016	use `test`; insert into t1 values( 85 )
493
master-bin.000001	29016	Query	1	29106	use `test`; insert into t1 values( 84 )
494
master-bin.000001	29106	Query	1	29196	use `test`; insert into t1 values( 83 )
495
master-bin.000001	29196	Query	1	29286	use `test`; insert into t1 values( 82 )
496
master-bin.000001	29286	Query	1	29376	use `test`; insert into t1 values( 81 )
497
master-bin.000001	29376	Query	1	29466	use `test`; insert into t1 values( 80 )
498
master-bin.000001	29466	Query	1	29556	use `test`; insert into t1 values( 79 )
499
master-bin.000001	29556	Query	1	29646	use `test`; insert into t1 values( 78 )
500
master-bin.000001	29646	Query	1	29736	use `test`; insert into t1 values( 77 )
501
master-bin.000001	29736	Query	1	29826	use `test`; insert into t1 values( 76 )
502
master-bin.000001	29826	Query	1	29916	use `test`; insert into t1 values( 75 )
503
master-bin.000001	29916	Query	1	30006	use `test`; insert into t1 values( 74 )
504
master-bin.000001	30006	Query	1	30096	use `test`; insert into t1 values( 73 )
505
master-bin.000001	30096	Query	1	30186	use `test`; insert into t1 values( 72 )
506
master-bin.000001	30186	Query	1	30276	use `test`; insert into t1 values( 71 )
507
master-bin.000001	30276	Query	1	30366	use `test`; insert into t1 values( 70 )
508
master-bin.000001	30366	Query	1	30456	use `test`; insert into t1 values( 69 )
509
master-bin.000001	30456	Query	1	30546	use `test`; insert into t1 values( 68 )
510
master-bin.000001	30546	Query	1	30636	use `test`; insert into t1 values( 67 )
511
master-bin.000001	30636	Query	1	30726	use `test`; insert into t1 values( 66 )
512
master-bin.000001	30726	Query	1	30816	use `test`; insert into t1 values( 65 )
513
master-bin.000001	30816	Query	1	30906	use `test`; insert into t1 values( 64 )
514
master-bin.000001	30906	Query	1	30996	use `test`; insert into t1 values( 63 )
515
master-bin.000001	30996	Query	1	31086	use `test`; insert into t1 values( 62 )
516
master-bin.000001	31086	Query	1	31176	use `test`; insert into t1 values( 61 )
517
master-bin.000001	31176	Query	1	31266	use `test`; insert into t1 values( 60 )
518
master-bin.000001	31266	Query	1	31356	use `test`; insert into t1 values( 59 )
519
master-bin.000001	31356	Query	1	31446	use `test`; insert into t1 values( 58 )
520
master-bin.000001	31446	Query	1	31536	use `test`; insert into t1 values( 57 )
521
master-bin.000001	31536	Query	1	31626	use `test`; insert into t1 values( 56 )
522
master-bin.000001	31626	Query	1	31716	use `test`; insert into t1 values( 55 )
523
master-bin.000001	31716	Query	1	31806	use `test`; insert into t1 values( 54 )
524
master-bin.000001	31806	Query	1	31896	use `test`; insert into t1 values( 53 )
525
master-bin.000001	31896	Query	1	31986	use `test`; insert into t1 values( 52 )
526
master-bin.000001	31986	Query	1	32076	use `test`; insert into t1 values( 51 )
527
master-bin.000001	32076	Query	1	32166	use `test`; insert into t1 values( 50 )
528
master-bin.000001	32166	Query	1	32256	use `test`; insert into t1 values( 49 )
529
master-bin.000001	32256	Query	1	32346	use `test`; insert into t1 values( 48 )
530
master-bin.000001	32346	Query	1	32436	use `test`; insert into t1 values( 47 )
531
master-bin.000001	32436	Query	1	32526	use `test`; insert into t1 values( 46 )
532
master-bin.000001	32526	Query	1	32616	use `test`; insert into t1 values( 45 )
533
master-bin.000001	32616	Query	1	32706	use `test`; insert into t1 values( 44 )
534
master-bin.000001	32706	Query	1	32796	use `test`; insert into t1 values( 43 )
535
master-bin.000001	32796	Query	1	32886	use `test`; insert into t1 values( 42 )
536
master-bin.000001	32886	Query	1	32976	use `test`; insert into t1 values( 41 )
537
master-bin.000001	32976	Query	1	33066	use `test`; insert into t1 values( 40 )
538
master-bin.000001	33066	Query	1	33156	use `test`; insert into t1 values( 39 )
539
master-bin.000001	33156	Query	1	33246	use `test`; insert into t1 values( 38 )
540
master-bin.000001	33246	Query	1	33336	use `test`; insert into t1 values( 37 )
541
master-bin.000001	33336	Query	1	33426	use `test`; insert into t1 values( 36 )
542
master-bin.000001	33426	Query	1	33516	use `test`; insert into t1 values( 35 )
543
master-bin.000001	33516	Query	1	33606	use `test`; insert into t1 values( 34 )
544
master-bin.000001	33606	Query	1	33696	use `test`; insert into t1 values( 33 )
545
master-bin.000001	33696	Query	1	33786	use `test`; insert into t1 values( 32 )
546
master-bin.000001	33786	Query	1	33876	use `test`; insert into t1 values( 31 )
547
master-bin.000001	33876	Query	1	33966	use `test`; insert into t1 values( 30 )
548
master-bin.000001	33966	Query	1	34056	use `test`; insert into t1 values( 29 )
549
master-bin.000001	34056	Query	1	34146	use `test`; insert into t1 values( 28 )
550
master-bin.000001	34146	Query	1	34236	use `test`; insert into t1 values( 27 )
551
master-bin.000001	34236	Query	1	34326	use `test`; insert into t1 values( 26 )
552
master-bin.000001	34326	Query	1	34416	use `test`; insert into t1 values( 25 )
553
master-bin.000001	34416	Query	1	34506	use `test`; insert into t1 values( 24 )
554
master-bin.000001	34506	Query	1	34596	use `test`; insert into t1 values( 23 )
555
master-bin.000001	34596	Query	1	34686	use `test`; insert into t1 values( 22 )
556
master-bin.000001	34686	Query	1	34776	use `test`; insert into t1 values( 21 )
557
master-bin.000001	34776	Query	1	34866	use `test`; insert into t1 values( 20 )
558
master-bin.000001	34866	Query	1	34956	use `test`; insert into t1 values( 19 )
559
master-bin.000001	34956	Query	1	35046	use `test`; insert into t1 values( 18 )
560
master-bin.000001	35046	Query	1	35136	use `test`; insert into t1 values( 17 )
561
master-bin.000001	35136	Query	1	35226	use `test`; insert into t1 values( 16 )
562
master-bin.000001	35226	Query	1	35316	use `test`; insert into t1 values( 15 )
563
master-bin.000001	35316	Query	1	35406	use `test`; insert into t1 values( 14 )
564
master-bin.000001	35406	Query	1	35496	use `test`; insert into t1 values( 13 )
565
master-bin.000001	35496	Query	1	35586	use `test`; insert into t1 values( 12 )
566
master-bin.000001	35586	Query	1	35676	use `test`; insert into t1 values( 11 )
567
master-bin.000001	35676	Query	1	35766	use `test`; insert into t1 values( 10 )
568
master-bin.000001	35766	Query	1	35855	use `test`; insert into t1 values( 9 )
569
master-bin.000001	35855	Query	1	35944	use `test`; insert into t1 values( 8 )
570
master-bin.000001	35944	Query	1	36033	use `test`; insert into t1 values( 7 )
571
master-bin.000001	36033	Query	1	36122	use `test`; insert into t1 values( 6 )
572
master-bin.000001	36122	Query	1	36211	use `test`; insert into t1 values( 5 )
573
master-bin.000001	36211	Query	1	36300	use `test`; insert into t1 values( 4 )
574
master-bin.000001	36300	Query	1	36389	use `test`; insert into t1 values( 3 )
575
master-bin.000001	36389	Query	1	36478	use `test`; insert into t1 values( 2 )
576
master-bin.000001	36478	Query	1	36567	use `test`; insert into t1 values( 1 )
577
master-bin.000001	36567	Xid	1	36594	COMMIT /* XID */
578
master-bin.000001	36594	Rotate	1	36638	master-bin.000002;pos=4
579
drop table t1;
580
set global binlog_cache_size=@bcs;
581
set session autocommit = @ac;
582
drop table if exists t1;
583
reset master;
584
create table t1 (a bigint unsigned, b bigint(20) unsigned);
585
prepare stmt from "insert into t1 values (?,?)";
586
set @a= 9999999999999999;
587
set @b= 14632475938453979136;
588
execute stmt using @a, @b;
589
deallocate prepare stmt;
590
drop table t1;
591
show binlog events from 0;
592
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
593
master-bin.000001	4	Format_desc	1	107	Server version, Binlog ver: 4
594
master-bin.000001	107	Query	1	228	use `test`; create table t1 (a bigint unsigned, b bigint(20) unsigned)
595
master-bin.000001	228	Query	1	352	use `test`; insert into t1 values (9999999999999999,14632475938453979136)
596
master-bin.000001	352	Query	1	428	use `test`; drop table t1
597
End of 5.0 tests
598
reset master;
599
create table t1 (id tinyint auto_increment primary key);
600
set insert_id=128;
601
insert into t1 values(null);
602
Warnings:
603
Warning	1264	Out of range value for column 'id' at row 1
604
select * from t1;
605
id
606
127
607
drop table t1;
608
create table t1 (a int);
609
create table if not exists t2 select * from t1;
610
create temporary table tt1 (a int);
611
create table if not exists t3 like tt1;
612
USE mysql;
613
INSERT INTO user SET host='localhost', user='@#@', password=password('Just a test');
614
UPDATE user SET password=password('Another password') WHERE host='localhost' AND user='@#@';
615
DELETE FROM user WHERE host='localhost' AND user='@#@';
616
use test;
617
show binlog events from <binlog_start>;
618
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
619
master-bin.000001	#	Query	#	#	use `test`; create table t1 (id tinyint auto_increment primary key)
620
master-bin.000001	#	Intvar	#	#	INSERT_ID=127
621
master-bin.000001	#	Query	#	#	use `test`; insert into t1 values(null)
622
master-bin.000001	#	Query	#	#	use `test`; drop table t1
623
master-bin.000001	#	Query	#	#	use `test`; create table t1 (a int)
624
master-bin.000001	#	Query	#	#	use `test`; create table if not exists t2 select * from t1
625
master-bin.000001	#	Query	#	#	use `test`; create temporary table tt1 (a int)
626
master-bin.000001	#	Query	#	#	use `test`; create table if not exists t3 like tt1
627
master-bin.000001	#	Query	#	#	use `mysql`; INSERT INTO user SET host='localhost', user='@#@', password=password('Just a test')
628
master-bin.000001	#	Query	#	#	use `mysql`; UPDATE user SET password=password('Another password') WHERE host='localhost' AND user='@#@'
629
master-bin.000001	#	Query	#	#	use `mysql`; DELETE FROM user WHERE host='localhost' AND user='@#@'
630
drop table t1,t2,t3,tt1;
631
create table t1 (a int not null auto_increment, primary key (a)) engine=myisam;
632
set @@session.auto_increment_increment=1, @@session.auto_increment_offset=1;
633
insert delayed into t1 values (207);
634
insert delayed into t1 values (null);
635
insert delayed into t1 values (300);
636
show binlog events from <binlog_start>;
637
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
638
master-bin.000001	#	Query	#	#	use `test`; create table t1 (id tinyint auto_increment primary key)
639
master-bin.000001	#	Intvar	#	#	INSERT_ID=127
640
master-bin.000001	#	Query	#	#	use `test`; insert into t1 values(null)
641
master-bin.000001	#	Query	#	#	use `test`; drop table t1
642
master-bin.000001	#	Query	#	#	use `test`; create table t1 (a int)
643
master-bin.000001	#	Query	#	#	use `test`; create table if not exists t2 select * from t1
644
master-bin.000001	#	Query	#	#	use `test`; create temporary table tt1 (a int)
645
master-bin.000001	#	Query	#	#	use `test`; create table if not exists t3 like tt1
646
master-bin.000001	#	Query	#	#	use `mysql`; INSERT INTO user SET host='localhost', user='@#@', password=password('Just a test')
647
master-bin.000001	#	Query	#	#	use `mysql`; UPDATE user SET password=password('Another password') WHERE host='localhost' AND user='@#@'
648
master-bin.000001	#	Query	#	#	use `mysql`; DELETE FROM user WHERE host='localhost' AND user='@#@'
649
master-bin.000001	#	Query	#	#	use `test`; drop table t1,t2,t3,tt1
650
master-bin.000001	#	Query	#	#	use `test`; create table t1 (a int not null auto_increment, primary key (a)) engine=myisam
651
master-bin.000001	#	Query	#	#	use `test`; BEGIN
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	#	Query	#	#	use `test`; COMMIT
655
master-bin.000001	#	Query	#	#	use `test`; BEGIN
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	#	Query	#	#	use `test`; COMMIT
659
master-bin.000001	#	Query	#	#	use `test`; BEGIN
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	#	Query	#	#	use `test`; COMMIT
663
insert delayed into t1 values (null),(null),(null),(null);
664
insert delayed into t1 values (null),(null),(400),(null);
665
11 == 11
666
select * from t1;
667
a
668
207
669
208
670
300
671
301
672
302
673
303
674
304
675
305
676
306
677
400
678
401
679
drop table t1;
680
reset master;
681
drop table if exists t3;
682
create table t3 (a int(11) NOT NULL AUTO_INCREMENT, b text, PRIMARY KEY (a) ) engine=innodb;
683
show master status;
684
File	Position	Binlog_Do_DB	Binlog_Ignore_DB
685
master-bin.000001	347		
686
insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
687
insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
688
insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
689
insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
690
show master status /* must show new binlog index after rotating */;
691
File	Position	Binlog_Do_DB	Binlog_Ignore_DB
692
master-bin.000002	107		
693
drop table t3;