~drizzle-trunk/drizzle/development

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
1209
1210
1211
1212
1213
1214
1215
1216
1217
1218
1219
1220
1221
drop table if exists t1, t2;
reset master;
create table t1 (a int) engine=innodb;
create table t2 (a int) engine=innodb;
begin;
insert t1 values (5);
commit;
begin;
insert t2 values (5);
commit;
show binlog events from <binlog_start>;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	use `test`; create table t1 (a int) engine=innodb
master-bin.000001	#	Query	#	#	use `test`; create table t2 (a int) engine=innodb
master-bin.000001	#	Query	#	#	use `test`; BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Xid	#	#	COMMIT /* XID */
master-bin.000001	#	Query	#	#	use `test`; BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (test.t2)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Xid	#	#	COMMIT /* XID */
drop table t1,t2;
reset master;
create table t1 (n int) engine=innodb;
begin;
commit;
drop table t1;
show binlog events in 'master-bin.000001' from 107;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	1	#	use `test`; create table t1 (n int) engine=innodb
master-bin.000001	#	Query	1	#	use `test`; BEGIN
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Table_map	1	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	1	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Xid	1	#	COMMIT /* xid= */
master-bin.000001	#	Rotate	1	#	master-bin.000002;pos=4
show binlog events in 'master-bin.000002' from 107;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000002	#	Query	1	#	use `test`; drop table t1
set @ac = @@autocommit;
set autocommit= 0;
reset master;
create table t1(n int) engine=innodb;
begin;
insert into t1 values (1);
insert into t1 values (2);
insert into t1 values (3);
commit;
drop table t1;
show binlog events from 0;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	4	Format_desc	1	107	Server version, Binlog ver: 4
master-bin.000001	107	Query	1	206	use `test`; create table t1(n int) engine=innodb
master-bin.000001	206	Query	1	274	use `test`; BEGIN
master-bin.000001	274	Table_map	1	315	table_id: # (test.t1)
master-bin.000001	315	Write_rows	1	349	table_id: # flags: STMT_END_F
master-bin.000001	349	Table_map	1	390	table_id: # (test.t1)
master-bin.000001	390	Write_rows	1	424	table_id: # flags: STMT_END_F
master-bin.000001	424	Table_map	1	465	table_id: # (test.t1)
master-bin.000001	465	Write_rows	1	499	table_id: # flags: STMT_END_F
master-bin.000001	499	Xid	1	526	COMMIT /* XID */
master-bin.000001	526	Query	1	602	use `test`; drop table t1
set @bcs = @@binlog_cache_size;
set global binlog_cache_size=4096;
reset master;
create table t1 (a int) engine=innodb;
show binlog events from 0;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	4	Format_desc	1	107	Server version, Binlog ver: 4
master-bin.000001	107	Query	1	207	use `test`; create table t1 (a int) engine=innodb
master-bin.000001	207	Query	1	275	use `test`; BEGIN
master-bin.000001	275	Table_map	1	316	table_id: # (test.t1)
master-bin.000001	316	Write_rows	1	350	table_id: # flags: STMT_END_F
master-bin.000001	350	Table_map	1	391	table_id: # (test.t1)
master-bin.000001	391	Write_rows	1	425	table_id: # flags: STMT_END_F
master-bin.000001	425	Table_map	1	466	table_id: # (test.t1)
master-bin.000001	466	Write_rows	1	500	table_id: # flags: STMT_END_F
master-bin.000001	500	Table_map	1	541	table_id: # (test.t1)
master-bin.000001	541	Write_rows	1	575	table_id: # flags: STMT_END_F
master-bin.000001	575	Table_map	1	616	table_id: # (test.t1)
master-bin.000001	616	Write_rows	1	650	table_id: # flags: STMT_END_F
master-bin.000001	650	Table_map	1	691	table_id: # (test.t1)
master-bin.000001	691	Write_rows	1	725	table_id: # flags: STMT_END_F
master-bin.000001	725	Table_map	1	766	table_id: # (test.t1)
master-bin.000001	766	Write_rows	1	800	table_id: # flags: STMT_END_F
master-bin.000001	800	Table_map	1	841	table_id: # (test.t1)
master-bin.000001	841	Write_rows	1	875	table_id: # flags: STMT_END_F
master-bin.000001	875	Table_map	1	916	table_id: # (test.t1)
master-bin.000001	916	Write_rows	1	950	table_id: # flags: STMT_END_F
master-bin.000001	950	Table_map	1	991	table_id: # (test.t1)
master-bin.000001	991	Write_rows	1	1025	table_id: # flags: STMT_END_F
master-bin.000001	1025	Table_map	1	1066	table_id: # (test.t1)
master-bin.000001	1066	Write_rows	1	1100	table_id: # flags: STMT_END_F
master-bin.000001	1100	Table_map	1	1141	table_id: # (test.t1)
master-bin.000001	1141	Write_rows	1	1175	table_id: # flags: STMT_END_F
master-bin.000001	1175	Table_map	1	1216	table_id: # (test.t1)
master-bin.000001	1216	Write_rows	1	1250	table_id: # flags: STMT_END_F
master-bin.000001	1250	Table_map	1	1291	table_id: # (test.t1)
master-bin.000001	1291	Write_rows	1	1325	table_id: # flags: STMT_END_F
master-bin.000001	1325	Table_map	1	1366	table_id: # (test.t1)
master-bin.000001	1366	Write_rows	1	1400	table_id: # flags: STMT_END_F
master-bin.000001	1400	Table_map	1	1441	table_id: # (test.t1)
master-bin.000001	1441	Write_rows	1	1475	table_id: # flags: STMT_END_F
master-bin.000001	1475	Table_map	1	1516	table_id: # (test.t1)
master-bin.000001	1516	Write_rows	1	1550	table_id: # flags: STMT_END_F
master-bin.000001	1550	Table_map	1	1591	table_id: # (test.t1)
master-bin.000001	1591	Write_rows	1	1625	table_id: # flags: STMT_END_F
master-bin.000001	1625	Table_map	1	1666	table_id: # (test.t1)
master-bin.000001	1666	Write_rows	1	1700	table_id: # flags: STMT_END_F
master-bin.000001	1700	Table_map	1	1741	table_id: # (test.t1)
master-bin.000001	1741	Write_rows	1	1775	table_id: # flags: STMT_END_F
master-bin.000001	1775	Table_map	1	1816	table_id: # (test.t1)
master-bin.000001	1816	Write_rows	1	1850	table_id: # flags: STMT_END_F
master-bin.000001	1850	Table_map	1	1891	table_id: # (test.t1)
master-bin.000001	1891	Write_rows	1	1925	table_id: # flags: STMT_END_F
master-bin.000001	1925	Table_map	1	1966	table_id: # (test.t1)
master-bin.000001	1966	Write_rows	1	2000	table_id: # flags: STMT_END_F
master-bin.000001	2000	Table_map	1	2041	table_id: # (test.t1)
master-bin.000001	2041	Write_rows	1	2075	table_id: # flags: STMT_END_F
master-bin.000001	2075	Table_map	1	2116	table_id: # (test.t1)
master-bin.000001	2116	Write_rows	1	2150	table_id: # flags: STMT_END_F
master-bin.000001	2150	Table_map	1	2191	table_id: # (test.t1)
master-bin.000001	2191	Write_rows	1	2225	table_id: # flags: STMT_END_F
master-bin.000001	2225	Table_map	1	2266	table_id: # (test.t1)
master-bin.000001	2266	Write_rows	1	2300	table_id: # flags: STMT_END_F
master-bin.000001	2300	Table_map	1	2341	table_id: # (test.t1)
master-bin.000001	2341	Write_rows	1	2375	table_id: # flags: STMT_END_F
master-bin.000001	2375	Table_map	1	2416	table_id: # (test.t1)
master-bin.000001	2416	Write_rows	1	2450	table_id: # flags: STMT_END_F
master-bin.000001	2450	Table_map	1	2491	table_id: # (test.t1)
master-bin.000001	2491	Write_rows	1	2525	table_id: # flags: STMT_END_F
master-bin.000001	2525	Table_map	1	2566	table_id: # (test.t1)
master-bin.000001	2566	Write_rows	1	2600	table_id: # flags: STMT_END_F
master-bin.000001	2600	Table_map	1	2641	table_id: # (test.t1)
master-bin.000001	2641	Write_rows	1	2675	table_id: # flags: STMT_END_F
master-bin.000001	2675	Table_map	1	2716	table_id: # (test.t1)
master-bin.000001	2716	Write_rows	1	2750	table_id: # flags: STMT_END_F
master-bin.000001	2750	Table_map	1	2791	table_id: # (test.t1)
master-bin.000001	2791	Write_rows	1	2825	table_id: # flags: STMT_END_F
master-bin.000001	2825	Table_map	1	2866	table_id: # (test.t1)
master-bin.000001	2866	Write_rows	1	2900	table_id: # flags: STMT_END_F
master-bin.000001	2900	Table_map	1	2941	table_id: # (test.t1)
master-bin.000001	2941	Write_rows	1	2975	table_id: # flags: STMT_END_F
master-bin.000001	2975	Table_map	1	3016	table_id: # (test.t1)
master-bin.000001	3016	Write_rows	1	3050	table_id: # flags: STMT_END_F
master-bin.000001	3050	Table_map	1	3091	table_id: # (test.t1)
master-bin.000001	3091	Write_rows	1	3125	table_id: # flags: STMT_END_F
master-bin.000001	3125	Table_map	1	3166	table_id: # (test.t1)
master-bin.000001	3166	Write_rows	1	3200	table_id: # flags: STMT_END_F
master-bin.000001	3200	Table_map	1	3241	table_id: # (test.t1)
master-bin.000001	3241	Write_rows	1	3275	table_id: # flags: STMT_END_F
master-bin.000001	3275	Table_map	1	3316	table_id: # (test.t1)
master-bin.000001	3316	Write_rows	1	3350	table_id: # flags: STMT_END_F
master-bin.000001	3350	Table_map	1	3391	table_id: # (test.t1)
master-bin.000001	3391	Write_rows	1	3425	table_id: # flags: STMT_END_F
master-bin.000001	3425	Table_map	1	3466	table_id: # (test.t1)
master-bin.000001	3466	Write_rows	1	3500	table_id: # flags: STMT_END_F
master-bin.000001	3500	Table_map	1	3541	table_id: # (test.t1)
master-bin.000001	3541	Write_rows	1	3575	table_id: # flags: STMT_END_F
master-bin.000001	3575	Table_map	1	3616	table_id: # (test.t1)
master-bin.000001	3616	Write_rows	1	3650	table_id: # flags: STMT_END_F
master-bin.000001	3650	Table_map	1	3691	table_id: # (test.t1)
master-bin.000001	3691	Write_rows	1	3725	table_id: # flags: STMT_END_F
master-bin.000001	3725	Table_map	1	3766	table_id: # (test.t1)
master-bin.000001	3766	Write_rows	1	3800	table_id: # flags: STMT_END_F
master-bin.000001	3800	Table_map	1	3841	table_id: # (test.t1)
master-bin.000001	3841	Write_rows	1	3875	table_id: # flags: STMT_END_F
master-bin.000001	3875	Table_map	1	3916	table_id: # (test.t1)
master-bin.000001	3916	Write_rows	1	3950	table_id: # flags: STMT_END_F
master-bin.000001	3950	Table_map	1	3991	table_id: # (test.t1)
master-bin.000001	3991	Write_rows	1	4025	table_id: # flags: STMT_END_F
master-bin.000001	4025	Table_map	1	4066	table_id: # (test.t1)
master-bin.000001	4066	Write_rows	1	4100	table_id: # flags: STMT_END_F
master-bin.000001	4100	Table_map	1	4141	table_id: # (test.t1)
master-bin.000001	4141	Write_rows	1	4175	table_id: # flags: STMT_END_F
master-bin.000001	4175	Table_map	1	4216	table_id: # (test.t1)
master-bin.000001	4216	Write_rows	1	4250	table_id: # flags: STMT_END_F
master-bin.000001	4250	Table_map	1	4291	table_id: # (test.t1)
master-bin.000001	4291	Write_rows	1	4325	table_id: # flags: STMT_END_F
master-bin.000001	4325	Table_map	1	4366	table_id: # (test.t1)
master-bin.000001	4366	Write_rows	1	4400	table_id: # flags: STMT_END_F
master-bin.000001	4400	Table_map	1	4441	table_id: # (test.t1)
master-bin.000001	4441	Write_rows	1	4475	table_id: # flags: STMT_END_F
master-bin.000001	4475	Table_map	1	4516	table_id: # (test.t1)
master-bin.000001	4516	Write_rows	1	4550	table_id: # flags: STMT_END_F
master-bin.000001	4550	Table_map	1	4591	table_id: # (test.t1)
master-bin.000001	4591	Write_rows	1	4625	table_id: # flags: STMT_END_F
master-bin.000001	4625	Table_map	1	4666	table_id: # (test.t1)
master-bin.000001	4666	Write_rows	1	4700	table_id: # flags: STMT_END_F
master-bin.000001	4700	Table_map	1	4741	table_id: # (test.t1)
master-bin.000001	4741	Write_rows	1	4775	table_id: # flags: STMT_END_F
master-bin.000001	4775	Table_map	1	4816	table_id: # (test.t1)
master-bin.000001	4816	Write_rows	1	4850	table_id: # flags: STMT_END_F
master-bin.000001	4850	Table_map	1	4891	table_id: # (test.t1)
master-bin.000001	4891	Write_rows	1	4925	table_id: # flags: STMT_END_F
master-bin.000001	4925	Table_map	1	4966	table_id: # (test.t1)
master-bin.000001	4966	Write_rows	1	5000	table_id: # flags: STMT_END_F
master-bin.000001	5000	Table_map	1	5041	table_id: # (test.t1)
master-bin.000001	5041	Write_rows	1	5075	table_id: # flags: STMT_END_F
master-bin.000001	5075	Table_map	1	5116	table_id: # (test.t1)
master-bin.000001	5116	Write_rows	1	5150	table_id: # flags: STMT_END_F
master-bin.000001	5150	Table_map	1	5191	table_id: # (test.t1)
master-bin.000001	5191	Write_rows	1	5225	table_id: # flags: STMT_END_F
master-bin.000001	5225	Table_map	1	5266	table_id: # (test.t1)
master-bin.000001	5266	Write_rows	1	5300	table_id: # flags: STMT_END_F
master-bin.000001	5300	Table_map	1	5341	table_id: # (test.t1)
master-bin.000001	5341	Write_rows	1	5375	table_id: # flags: STMT_END_F
master-bin.000001	5375	Table_map	1	5416	table_id: # (test.t1)
master-bin.000001	5416	Write_rows	1	5450	table_id: # flags: STMT_END_F
master-bin.000001	5450	Table_map	1	5491	table_id: # (test.t1)
master-bin.000001	5491	Write_rows	1	5525	table_id: # flags: STMT_END_F
master-bin.000001	5525	Table_map	1	5566	table_id: # (test.t1)
master-bin.000001	5566	Write_rows	1	5600	table_id: # flags: STMT_END_F
master-bin.000001	5600	Table_map	1	5641	table_id: # (test.t1)
master-bin.000001	5641	Write_rows	1	5675	table_id: # flags: STMT_END_F
master-bin.000001	5675	Table_map	1	5716	table_id: # (test.t1)
master-bin.000001	5716	Write_rows	1	5750	table_id: # flags: STMT_END_F
master-bin.000001	5750	Table_map	1	5791	table_id: # (test.t1)
master-bin.000001	5791	Write_rows	1	5825	table_id: # flags: STMT_END_F
master-bin.000001	5825	Table_map	1	5866	table_id: # (test.t1)
master-bin.000001	5866	Write_rows	1	5900	table_id: # flags: STMT_END_F
master-bin.000001	5900	Table_map	1	5941	table_id: # (test.t1)
master-bin.000001	5941	Write_rows	1	5975	table_id: # flags: STMT_END_F
master-bin.000001	5975	Table_map	1	6016	table_id: # (test.t1)
master-bin.000001	6016	Write_rows	1	6050	table_id: # flags: STMT_END_F
master-bin.000001	6050	Table_map	1	6091	table_id: # (test.t1)
master-bin.000001	6091	Write_rows	1	6125	table_id: # flags: STMT_END_F
master-bin.000001	6125	Table_map	1	6166	table_id: # (test.t1)
master-bin.000001	6166	Write_rows	1	6200	table_id: # flags: STMT_END_F
master-bin.000001	6200	Table_map	1	6241	table_id: # (test.t1)
master-bin.000001	6241	Write_rows	1	6275	table_id: # flags: STMT_END_F
master-bin.000001	6275	Table_map	1	6316	table_id: # (test.t1)
master-bin.000001	6316	Write_rows	1	6350	table_id: # flags: STMT_END_F
master-bin.000001	6350	Table_map	1	6391	table_id: # (test.t1)
master-bin.000001	6391	Write_rows	1	6425	table_id: # flags: STMT_END_F
master-bin.000001	6425	Table_map	1	6466	table_id: # (test.t1)
master-bin.000001	6466	Write_rows	1	6500	table_id: # flags: STMT_END_F
master-bin.000001	6500	Table_map	1	6541	table_id: # (test.t1)
master-bin.000001	6541	Write_rows	1	6575	table_id: # flags: STMT_END_F
master-bin.000001	6575	Table_map	1	6616	table_id: # (test.t1)
master-bin.000001	6616	Write_rows	1	6650	table_id: # flags: STMT_END_F
master-bin.000001	6650	Table_map	1	6691	table_id: # (test.t1)
master-bin.000001	6691	Write_rows	1	6725	table_id: # flags: STMT_END_F
master-bin.000001	6725	Table_map	1	6766	table_id: # (test.t1)
master-bin.000001	6766	Write_rows	1	6800	table_id: # flags: STMT_END_F
master-bin.000001	6800	Table_map	1	6841	table_id: # (test.t1)
master-bin.000001	6841	Write_rows	1	6875	table_id: # flags: STMT_END_F
master-bin.000001	6875	Table_map	1	6916	table_id: # (test.t1)
master-bin.000001	6916	Write_rows	1	6950	table_id: # flags: STMT_END_F
master-bin.000001	6950	Table_map	1	6991	table_id: # (test.t1)
master-bin.000001	6991	Write_rows	1	7025	table_id: # flags: STMT_END_F
master-bin.000001	7025	Table_map	1	7066	table_id: # (test.t1)
master-bin.000001	7066	Write_rows	1	7100	table_id: # flags: STMT_END_F
master-bin.000001	7100	Table_map	1	7141	table_id: # (test.t1)
master-bin.000001	7141	Write_rows	1	7175	table_id: # flags: STMT_END_F
master-bin.000001	7175	Table_map	1	7216	table_id: # (test.t1)
master-bin.000001	7216	Write_rows	1	7250	table_id: # flags: STMT_END_F
master-bin.000001	7250	Table_map	1	7291	table_id: # (test.t1)
master-bin.000001	7291	Write_rows	1	7325	table_id: # flags: STMT_END_F
master-bin.000001	7325	Table_map	1	7366	table_id: # (test.t1)
master-bin.000001	7366	Write_rows	1	7400	table_id: # flags: STMT_END_F
master-bin.000001	7400	Table_map	1	7441	table_id: # (test.t1)
master-bin.000001	7441	Write_rows	1	7475	table_id: # flags: STMT_END_F
master-bin.000001	7475	Table_map	1	7516	table_id: # (test.t1)
master-bin.000001	7516	Write_rows	1	7550	table_id: # flags: STMT_END_F
master-bin.000001	7550	Table_map	1	7591	table_id: # (test.t1)
master-bin.000001	7591	Write_rows	1	7625	table_id: # flags: STMT_END_F
master-bin.000001	7625	Table_map	1	7666	table_id: # (test.t1)
master-bin.000001	7666	Write_rows	1	7700	table_id: # flags: STMT_END_F
master-bin.000001	7700	Table_map	1	7741	table_id: # (test.t1)
master-bin.000001	7741	Write_rows	1	7775	table_id: # flags: STMT_END_F
master-bin.000001	7775	Table_map	1	7816	table_id: # (test.t1)
master-bin.000001	7816	Write_rows	1	7850	table_id: # flags: STMT_END_F
master-bin.000001	7850	Table_map	1	7891	table_id: # (test.t1)
master-bin.000001	7891	Write_rows	1	7925	table_id: # flags: STMT_END_F
master-bin.000001	7925	Table_map	1	7966	table_id: # (test.t1)
master-bin.000001	7966	Write_rows	1	8000	table_id: # flags: STMT_END_F
master-bin.000001	8000	Table_map	1	8041	table_id: # (test.t1)
master-bin.000001	8041	Write_rows	1	8075	table_id: # flags: STMT_END_F
master-bin.000001	8075	Table_map	1	8116	table_id: # (test.t1)
master-bin.000001	8116	Write_rows	1	8150	table_id: # flags: STMT_END_F
master-bin.000001	8150	Table_map	1	8191	table_id: # (test.t1)
master-bin.000001	8191	Write_rows	1	8225	table_id: # flags: STMT_END_F
master-bin.000001	8225	Table_map	1	8266	table_id: # (test.t1)
master-bin.000001	8266	Write_rows	1	8300	table_id: # flags: STMT_END_F
master-bin.000001	8300	Table_map	1	8341	table_id: # (test.t1)
master-bin.000001	8341	Write_rows	1	8375	table_id: # flags: STMT_END_F
master-bin.000001	8375	Table_map	1	8416	table_id: # (test.t1)
master-bin.000001	8416	Write_rows	1	8450	table_id: # flags: STMT_END_F
master-bin.000001	8450	Table_map	1	8491	table_id: # (test.t1)
master-bin.000001	8491	Write_rows	1	8525	table_id: # flags: STMT_END_F
master-bin.000001	8525	Table_map	1	8566	table_id: # (test.t1)
master-bin.000001	8566	Write_rows	1	8600	table_id: # flags: STMT_END_F
master-bin.000001	8600	Table_map	1	8641	table_id: # (test.t1)
master-bin.000001	8641	Write_rows	1	8675	table_id: # flags: STMT_END_F
master-bin.000001	8675	Table_map	1	8716	table_id: # (test.t1)
master-bin.000001	8716	Write_rows	1	8750	table_id: # flags: STMT_END_F
master-bin.000001	8750	Table_map	1	8791	table_id: # (test.t1)
master-bin.000001	8791	Write_rows	1	8825	table_id: # flags: STMT_END_F
master-bin.000001	8825	Table_map	1	8866	table_id: # (test.t1)
master-bin.000001	8866	Write_rows	1	8900	table_id: # flags: STMT_END_F
master-bin.000001	8900	Table_map	1	8941	table_id: # (test.t1)
master-bin.000001	8941	Write_rows	1	8975	table_id: # flags: STMT_END_F
master-bin.000001	8975	Table_map	1	9016	table_id: # (test.t1)
master-bin.000001	9016	Write_rows	1	9050	table_id: # flags: STMT_END_F
master-bin.000001	9050	Table_map	1	9091	table_id: # (test.t1)
master-bin.000001	9091	Write_rows	1	9125	table_id: # flags: STMT_END_F
master-bin.000001	9125	Table_map	1	9166	table_id: # (test.t1)
master-bin.000001	9166	Write_rows	1	9200	table_id: # flags: STMT_END_F
master-bin.000001	9200	Table_map	1	9241	table_id: # (test.t1)
master-bin.000001	9241	Write_rows	1	9275	table_id: # flags: STMT_END_F
master-bin.000001	9275	Table_map	1	9316	table_id: # (test.t1)
master-bin.000001	9316	Write_rows	1	9350	table_id: # flags: STMT_END_F
master-bin.000001	9350	Table_map	1	9391	table_id: # (test.t1)
master-bin.000001	9391	Write_rows	1	9425	table_id: # flags: STMT_END_F
master-bin.000001	9425	Table_map	1	9466	table_id: # (test.t1)
master-bin.000001	9466	Write_rows	1	9500	table_id: # flags: STMT_END_F
master-bin.000001	9500	Table_map	1	9541	table_id: # (test.t1)
master-bin.000001	9541	Write_rows	1	9575	table_id: # flags: STMT_END_F
master-bin.000001	9575	Table_map	1	9616	table_id: # (test.t1)
master-bin.000001	9616	Write_rows	1	9650	table_id: # flags: STMT_END_F
master-bin.000001	9650	Table_map	1	9691	table_id: # (test.t1)
master-bin.000001	9691	Write_rows	1	9725	table_id: # flags: STMT_END_F
master-bin.000001	9725	Table_map	1	9766	table_id: # (test.t1)
master-bin.000001	9766	Write_rows	1	9800	table_id: # flags: STMT_END_F
master-bin.000001	9800	Table_map	1	9841	table_id: # (test.t1)
master-bin.000001	9841	Write_rows	1	9875	table_id: # flags: STMT_END_F
master-bin.000001	9875	Table_map	1	9916	table_id: # (test.t1)
master-bin.000001	9916	Write_rows	1	9950	table_id: # flags: STMT_END_F
master-bin.000001	9950	Table_map	1	9991	table_id: # (test.t1)
master-bin.000001	9991	Write_rows	1	10025	table_id: # flags: STMT_END_F
master-bin.000001	10025	Table_map	1	10066	table_id: # (test.t1)
master-bin.000001	10066	Write_rows	1	10100	table_id: # flags: STMT_END_F
master-bin.000001	10100	Table_map	1	10141	table_id: # (test.t1)
master-bin.000001	10141	Write_rows	1	10175	table_id: # flags: STMT_END_F
master-bin.000001	10175	Table_map	1	10216	table_id: # (test.t1)
master-bin.000001	10216	Write_rows	1	10250	table_id: # flags: STMT_END_F
master-bin.000001	10250	Table_map	1	10291	table_id: # (test.t1)
master-bin.000001	10291	Write_rows	1	10325	table_id: # flags: STMT_END_F
master-bin.000001	10325	Table_map	1	10366	table_id: # (test.t1)
master-bin.000001	10366	Write_rows	1	10400	table_id: # flags: STMT_END_F
master-bin.000001	10400	Table_map	1	10441	table_id: # (test.t1)
master-bin.000001	10441	Write_rows	1	10475	table_id: # flags: STMT_END_F
master-bin.000001	10475	Table_map	1	10516	table_id: # (test.t1)
master-bin.000001	10516	Write_rows	1	10550	table_id: # flags: STMT_END_F
master-bin.000001	10550	Table_map	1	10591	table_id: # (test.t1)
master-bin.000001	10591	Write_rows	1	10625	table_id: # flags: STMT_END_F
master-bin.000001	10625	Table_map	1	10666	table_id: # (test.t1)
master-bin.000001	10666	Write_rows	1	10700	table_id: # flags: STMT_END_F
master-bin.000001	10700	Table_map	1	10741	table_id: # (test.t1)
master-bin.000001	10741	Write_rows	1	10775	table_id: # flags: STMT_END_F
master-bin.000001	10775	Table_map	1	10816	table_id: # (test.t1)
master-bin.000001	10816	Write_rows	1	10850	table_id: # flags: STMT_END_F
master-bin.000001	10850	Table_map	1	10891	table_id: # (test.t1)
master-bin.000001	10891	Write_rows	1	10925	table_id: # flags: STMT_END_F
master-bin.000001	10925	Table_map	1	10966	table_id: # (test.t1)
master-bin.000001	10966	Write_rows	1	11000	table_id: # flags: STMT_END_F
master-bin.000001	11000	Table_map	1	11041	table_id: # (test.t1)
master-bin.000001	11041	Write_rows	1	11075	table_id: # flags: STMT_END_F
master-bin.000001	11075	Table_map	1	11116	table_id: # (test.t1)
master-bin.000001	11116	Write_rows	1	11150	table_id: # flags: STMT_END_F
master-bin.000001	11150	Table_map	1	11191	table_id: # (test.t1)
master-bin.000001	11191	Write_rows	1	11225	table_id: # flags: STMT_END_F
master-bin.000001	11225	Table_map	1	11266	table_id: # (test.t1)
master-bin.000001	11266	Write_rows	1	11300	table_id: # flags: STMT_END_F
master-bin.000001	11300	Table_map	1	11341	table_id: # (test.t1)
master-bin.000001	11341	Write_rows	1	11375	table_id: # flags: STMT_END_F
master-bin.000001	11375	Table_map	1	11416	table_id: # (test.t1)
master-bin.000001	11416	Write_rows	1	11450	table_id: # flags: STMT_END_F
master-bin.000001	11450	Table_map	1	11491	table_id: # (test.t1)
master-bin.000001	11491	Write_rows	1	11525	table_id: # flags: STMT_END_F
master-bin.000001	11525	Table_map	1	11566	table_id: # (test.t1)
master-bin.000001	11566	Write_rows	1	11600	table_id: # flags: STMT_END_F
master-bin.000001	11600	Table_map	1	11641	table_id: # (test.t1)
master-bin.000001	11641	Write_rows	1	11675	table_id: # flags: STMT_END_F
master-bin.000001	11675	Table_map	1	11716	table_id: # (test.t1)
master-bin.000001	11716	Write_rows	1	11750	table_id: # flags: STMT_END_F
master-bin.000001	11750	Table_map	1	11791	table_id: # (test.t1)
master-bin.000001	11791	Write_rows	1	11825	table_id: # flags: STMT_END_F
master-bin.000001	11825	Table_map	1	11866	table_id: # (test.t1)
master-bin.000001	11866	Write_rows	1	11900	table_id: # flags: STMT_END_F
master-bin.000001	11900	Table_map	1	11941	table_id: # (test.t1)
master-bin.000001	11941	Write_rows	1	11975	table_id: # flags: STMT_END_F
master-bin.000001	11975	Table_map	1	12016	table_id: # (test.t1)
master-bin.000001	12016	Write_rows	1	12050	table_id: # flags: STMT_END_F
master-bin.000001	12050	Table_map	1	12091	table_id: # (test.t1)
master-bin.000001	12091	Write_rows	1	12125	table_id: # flags: STMT_END_F
master-bin.000001	12125	Table_map	1	12166	table_id: # (test.t1)
master-bin.000001	12166	Write_rows	1	12200	table_id: # flags: STMT_END_F
master-bin.000001	12200	Table_map	1	12241	table_id: # (test.t1)
master-bin.000001	12241	Write_rows	1	12275	table_id: # flags: STMT_END_F
master-bin.000001	12275	Table_map	1	12316	table_id: # (test.t1)
master-bin.000001	12316	Write_rows	1	12350	table_id: # flags: STMT_END_F
master-bin.000001	12350	Table_map	1	12391	table_id: # (test.t1)
master-bin.000001	12391	Write_rows	1	12425	table_id: # flags: STMT_END_F
master-bin.000001	12425	Table_map	1	12466	table_id: # (test.t1)
master-bin.000001	12466	Write_rows	1	12500	table_id: # flags: STMT_END_F
master-bin.000001	12500	Table_map	1	12541	table_id: # (test.t1)
master-bin.000001	12541	Write_rows	1	12575	table_id: # flags: STMT_END_F
master-bin.000001	12575	Table_map	1	12616	table_id: # (test.t1)
master-bin.000001	12616	Write_rows	1	12650	table_id: # flags: STMT_END_F
master-bin.000001	12650	Table_map	1	12691	table_id: # (test.t1)
master-bin.000001	12691	Write_rows	1	12725	table_id: # flags: STMT_END_F
master-bin.000001	12725	Table_map	1	12766	table_id: # (test.t1)
master-bin.000001	12766	Write_rows	1	12800	table_id: # flags: STMT_END_F
master-bin.000001	12800	Table_map	1	12841	table_id: # (test.t1)
master-bin.000001	12841	Write_rows	1	12875	table_id: # flags: STMT_END_F
master-bin.000001	12875	Table_map	1	12916	table_id: # (test.t1)
master-bin.000001	12916	Write_rows	1	12950	table_id: # flags: STMT_END_F
master-bin.000001	12950	Table_map	1	12991	table_id: # (test.t1)
master-bin.000001	12991	Write_rows	1	13025	table_id: # flags: STMT_END_F
master-bin.000001	13025	Table_map	1	13066	table_id: # (test.t1)
master-bin.000001	13066	Write_rows	1	13100	table_id: # flags: STMT_END_F
master-bin.000001	13100	Table_map	1	13141	table_id: # (test.t1)
master-bin.000001	13141	Write_rows	1	13175	table_id: # flags: STMT_END_F
master-bin.000001	13175	Table_map	1	13216	table_id: # (test.t1)
master-bin.000001	13216	Write_rows	1	13250	table_id: # flags: STMT_END_F
master-bin.000001	13250	Table_map	1	13291	table_id: # (test.t1)
master-bin.000001	13291	Write_rows	1	13325	table_id: # flags: STMT_END_F
master-bin.000001	13325	Table_map	1	13366	table_id: # (test.t1)
master-bin.000001	13366	Write_rows	1	13400	table_id: # flags: STMT_END_F
master-bin.000001	13400	Table_map	1	13441	table_id: # (test.t1)
master-bin.000001	13441	Write_rows	1	13475	table_id: # flags: STMT_END_F
master-bin.000001	13475	Table_map	1	13516	table_id: # (test.t1)
master-bin.000001	13516	Write_rows	1	13550	table_id: # flags: STMT_END_F
master-bin.000001	13550	Table_map	1	13591	table_id: # (test.t1)
master-bin.000001	13591	Write_rows	1	13625	table_id: # flags: STMT_END_F
master-bin.000001	13625	Table_map	1	13666	table_id: # (test.t1)
master-bin.000001	13666	Write_rows	1	13700	table_id: # flags: STMT_END_F
master-bin.000001	13700	Table_map	1	13741	table_id: # (test.t1)
master-bin.000001	13741	Write_rows	1	13775	table_id: # flags: STMT_END_F
master-bin.000001	13775	Table_map	1	13816	table_id: # (test.t1)
master-bin.000001	13816	Write_rows	1	13850	table_id: # flags: STMT_END_F
master-bin.000001	13850	Table_map	1	13891	table_id: # (test.t1)
master-bin.000001	13891	Write_rows	1	13925	table_id: # flags: STMT_END_F
master-bin.000001	13925	Table_map	1	13966	table_id: # (test.t1)
master-bin.000001	13966	Write_rows	1	14000	table_id: # flags: STMT_END_F
master-bin.000001	14000	Table_map	1	14041	table_id: # (test.t1)
master-bin.000001	14041	Write_rows	1	14075	table_id: # flags: STMT_END_F
master-bin.000001	14075	Table_map	1	14116	table_id: # (test.t1)
master-bin.000001	14116	Write_rows	1	14150	table_id: # flags: STMT_END_F
master-bin.000001	14150	Table_map	1	14191	table_id: # (test.t1)
master-bin.000001	14191	Write_rows	1	14225	table_id: # flags: STMT_END_F
master-bin.000001	14225	Table_map	1	14266	table_id: # (test.t1)
master-bin.000001	14266	Write_rows	1	14300	table_id: # flags: STMT_END_F
master-bin.000001	14300	Table_map	1	14341	table_id: # (test.t1)
master-bin.000001	14341	Write_rows	1	14375	table_id: # flags: STMT_END_F
master-bin.000001	14375	Table_map	1	14416	table_id: # (test.t1)
master-bin.000001	14416	Write_rows	1	14450	table_id: # flags: STMT_END_F
master-bin.000001	14450	Table_map	1	14491	table_id: # (test.t1)
master-bin.000001	14491	Write_rows	1	14525	table_id: # flags: STMT_END_F
master-bin.000001	14525	Table_map	1	14566	table_id: # (test.t1)
master-bin.000001	14566	Write_rows	1	14600	table_id: # flags: STMT_END_F
master-bin.000001	14600	Table_map	1	14641	table_id: # (test.t1)
master-bin.000001	14641	Write_rows	1	14675	table_id: # flags: STMT_END_F
master-bin.000001	14675	Table_map	1	14716	table_id: # (test.t1)
master-bin.000001	14716	Write_rows	1	14750	table_id: # flags: STMT_END_F
master-bin.000001	14750	Table_map	1	14791	table_id: # (test.t1)
master-bin.000001	14791	Write_rows	1	14825	table_id: # flags: STMT_END_F
master-bin.000001	14825	Table_map	1	14866	table_id: # (test.t1)
master-bin.000001	14866	Write_rows	1	14900	table_id: # flags: STMT_END_F
master-bin.000001	14900	Table_map	1	14941	table_id: # (test.t1)
master-bin.000001	14941	Write_rows	1	14975	table_id: # flags: STMT_END_F
master-bin.000001	14975	Table_map	1	15016	table_id: # (test.t1)
master-bin.000001	15016	Write_rows	1	15050	table_id: # flags: STMT_END_F
master-bin.000001	15050	Table_map	1	15091	table_id: # (test.t1)
master-bin.000001	15091	Write_rows	1	15125	table_id: # flags: STMT_END_F
master-bin.000001	15125	Table_map	1	15166	table_id: # (test.t1)
master-bin.000001	15166	Write_rows	1	15200	table_id: # flags: STMT_END_F
master-bin.000001	15200	Table_map	1	15241	table_id: # (test.t1)
master-bin.000001	15241	Write_rows	1	15275	table_id: # flags: STMT_END_F
master-bin.000001	15275	Table_map	1	15316	table_id: # (test.t1)
master-bin.000001	15316	Write_rows	1	15350	table_id: # flags: STMT_END_F
master-bin.000001	15350	Table_map	1	15391	table_id: # (test.t1)
master-bin.000001	15391	Write_rows	1	15425	table_id: # flags: STMT_END_F
master-bin.000001	15425	Table_map	1	15466	table_id: # (test.t1)
master-bin.000001	15466	Write_rows	1	15500	table_id: # flags: STMT_END_F
master-bin.000001	15500	Table_map	1	15541	table_id: # (test.t1)
master-bin.000001	15541	Write_rows	1	15575	table_id: # flags: STMT_END_F
master-bin.000001	15575	Table_map	1	15616	table_id: # (test.t1)
master-bin.000001	15616	Write_rows	1	15650	table_id: # flags: STMT_END_F
master-bin.000001	15650	Table_map	1	15691	table_id: # (test.t1)
master-bin.000001	15691	Write_rows	1	15725	table_id: # flags: STMT_END_F
master-bin.000001	15725	Table_map	1	15766	table_id: # (test.t1)
master-bin.000001	15766	Write_rows	1	15800	table_id: # flags: STMT_END_F
master-bin.000001	15800	Table_map	1	15841	table_id: # (test.t1)
master-bin.000001	15841	Write_rows	1	15875	table_id: # flags: STMT_END_F
master-bin.000001	15875	Table_map	1	15916	table_id: # (test.t1)
master-bin.000001	15916	Write_rows	1	15950	table_id: # flags: STMT_END_F
master-bin.000001	15950	Table_map	1	15991	table_id: # (test.t1)
master-bin.000001	15991	Write_rows	1	16025	table_id: # flags: STMT_END_F
master-bin.000001	16025	Table_map	1	16066	table_id: # (test.t1)
master-bin.000001	16066	Write_rows	1	16100	table_id: # flags: STMT_END_F
master-bin.000001	16100	Table_map	1	16141	table_id: # (test.t1)
master-bin.000001	16141	Write_rows	1	16175	table_id: # flags: STMT_END_F
master-bin.000001	16175	Table_map	1	16216	table_id: # (test.t1)
master-bin.000001	16216	Write_rows	1	16250	table_id: # flags: STMT_END_F
master-bin.000001	16250	Table_map	1	16291	table_id: # (test.t1)
master-bin.000001	16291	Write_rows	1	16325	table_id: # flags: STMT_END_F
master-bin.000001	16325	Table_map	1	16366	table_id: # (test.t1)
master-bin.000001	16366	Write_rows	1	16400	table_id: # flags: STMT_END_F
master-bin.000001	16400	Table_map	1	16441	table_id: # (test.t1)
master-bin.000001	16441	Write_rows	1	16475	table_id: # flags: STMT_END_F
master-bin.000001	16475	Table_map	1	16516	table_id: # (test.t1)
master-bin.000001	16516	Write_rows	1	16550	table_id: # flags: STMT_END_F
master-bin.000001	16550	Table_map	1	16591	table_id: # (test.t1)
master-bin.000001	16591	Write_rows	1	16625	table_id: # flags: STMT_END_F
master-bin.000001	16625	Table_map	1	16666	table_id: # (test.t1)
master-bin.000001	16666	Write_rows	1	16700	table_id: # flags: STMT_END_F
master-bin.000001	16700	Table_map	1	16741	table_id: # (test.t1)
master-bin.000001	16741	Write_rows	1	16775	table_id: # flags: STMT_END_F
master-bin.000001	16775	Table_map	1	16816	table_id: # (test.t1)
master-bin.000001	16816	Write_rows	1	16850	table_id: # flags: STMT_END_F
master-bin.000001	16850	Table_map	1	16891	table_id: # (test.t1)
master-bin.000001	16891	Write_rows	1	16925	table_id: # flags: STMT_END_F
master-bin.000001	16925	Table_map	1	16966	table_id: # (test.t1)
master-bin.000001	16966	Write_rows	1	17000	table_id: # flags: STMT_END_F
master-bin.000001	17000	Table_map	1	17041	table_id: # (test.t1)
master-bin.000001	17041	Write_rows	1	17075	table_id: # flags: STMT_END_F
master-bin.000001	17075	Table_map	1	17116	table_id: # (test.t1)
master-bin.000001	17116	Write_rows	1	17150	table_id: # flags: STMT_END_F
master-bin.000001	17150	Table_map	1	17191	table_id: # (test.t1)
master-bin.000001	17191	Write_rows	1	17225	table_id: # flags: STMT_END_F
master-bin.000001	17225	Table_map	1	17266	table_id: # (test.t1)
master-bin.000001	17266	Write_rows	1	17300	table_id: # flags: STMT_END_F
master-bin.000001	17300	Table_map	1	17341	table_id: # (test.t1)
master-bin.000001	17341	Write_rows	1	17375	table_id: # flags: STMT_END_F
master-bin.000001	17375	Table_map	1	17416	table_id: # (test.t1)
master-bin.000001	17416	Write_rows	1	17450	table_id: # flags: STMT_END_F
master-bin.000001	17450	Table_map	1	17491	table_id: # (test.t1)
master-bin.000001	17491	Write_rows	1	17525	table_id: # flags: STMT_END_F
master-bin.000001	17525	Table_map	1	17566	table_id: # (test.t1)
master-bin.000001	17566	Write_rows	1	17600	table_id: # flags: STMT_END_F
master-bin.000001	17600	Table_map	1	17641	table_id: # (test.t1)
master-bin.000001	17641	Write_rows	1	17675	table_id: # flags: STMT_END_F
master-bin.000001	17675	Table_map	1	17716	table_id: # (test.t1)
master-bin.000001	17716	Write_rows	1	17750	table_id: # flags: STMT_END_F
master-bin.000001	17750	Table_map	1	17791	table_id: # (test.t1)
master-bin.000001	17791	Write_rows	1	17825	table_id: # flags: STMT_END_F
master-bin.000001	17825	Table_map	1	17866	table_id: # (test.t1)
master-bin.000001	17866	Write_rows	1	17900	table_id: # flags: STMT_END_F
master-bin.000001	17900	Table_map	1	17941	table_id: # (test.t1)
master-bin.000001	17941	Write_rows	1	17975	table_id: # flags: STMT_END_F
master-bin.000001	17975	Table_map	1	18016	table_id: # (test.t1)
master-bin.000001	18016	Write_rows	1	18050	table_id: # flags: STMT_END_F
master-bin.000001	18050	Table_map	1	18091	table_id: # (test.t1)
master-bin.000001	18091	Write_rows	1	18125	table_id: # flags: STMT_END_F
master-bin.000001	18125	Table_map	1	18166	table_id: # (test.t1)
master-bin.000001	18166	Write_rows	1	18200	table_id: # flags: STMT_END_F
master-bin.000001	18200	Table_map	1	18241	table_id: # (test.t1)
master-bin.000001	18241	Write_rows	1	18275	table_id: # flags: STMT_END_F
master-bin.000001	18275	Table_map	1	18316	table_id: # (test.t1)
master-bin.000001	18316	Write_rows	1	18350	table_id: # flags: STMT_END_F
master-bin.000001	18350	Table_map	1	18391	table_id: # (test.t1)
master-bin.000001	18391	Write_rows	1	18425	table_id: # flags: STMT_END_F
master-bin.000001	18425	Table_map	1	18466	table_id: # (test.t1)
master-bin.000001	18466	Write_rows	1	18500	table_id: # flags: STMT_END_F
master-bin.000001	18500	Table_map	1	18541	table_id: # (test.t1)
master-bin.000001	18541	Write_rows	1	18575	table_id: # flags: STMT_END_F
master-bin.000001	18575	Table_map	1	18616	table_id: # (test.t1)
master-bin.000001	18616	Write_rows	1	18650	table_id: # flags: STMT_END_F
master-bin.000001	18650	Table_map	1	18691	table_id: # (test.t1)
master-bin.000001	18691	Write_rows	1	18725	table_id: # flags: STMT_END_F
master-bin.000001	18725	Table_map	1	18766	table_id: # (test.t1)
master-bin.000001	18766	Write_rows	1	18800	table_id: # flags: STMT_END_F
master-bin.000001	18800	Table_map	1	18841	table_id: # (test.t1)
master-bin.000001	18841	Write_rows	1	18875	table_id: # flags: STMT_END_F
master-bin.000001	18875	Table_map	1	18916	table_id: # (test.t1)
master-bin.000001	18916	Write_rows	1	18950	table_id: # flags: STMT_END_F
master-bin.000001	18950	Table_map	1	18991	table_id: # (test.t1)
master-bin.000001	18991	Write_rows	1	19025	table_id: # flags: STMT_END_F
master-bin.000001	19025	Table_map	1	19066	table_id: # (test.t1)
master-bin.000001	19066	Write_rows	1	19100	table_id: # flags: STMT_END_F
master-bin.000001	19100	Table_map	1	19141	table_id: # (test.t1)
master-bin.000001	19141	Write_rows	1	19175	table_id: # flags: STMT_END_F
master-bin.000001	19175	Table_map	1	19216	table_id: # (test.t1)
master-bin.000001	19216	Write_rows	1	19250	table_id: # flags: STMT_END_F
master-bin.000001	19250	Table_map	1	19291	table_id: # (test.t1)
master-bin.000001	19291	Write_rows	1	19325	table_id: # flags: STMT_END_F
master-bin.000001	19325	Table_map	1	19366	table_id: # (test.t1)
master-bin.000001	19366	Write_rows	1	19400	table_id: # flags: STMT_END_F
master-bin.000001	19400	Table_map	1	19441	table_id: # (test.t1)
master-bin.000001	19441	Write_rows	1	19475	table_id: # flags: STMT_END_F
master-bin.000001	19475	Table_map	1	19516	table_id: # (test.t1)
master-bin.000001	19516	Write_rows	1	19550	table_id: # flags: STMT_END_F
master-bin.000001	19550	Table_map	1	19591	table_id: # (test.t1)
master-bin.000001	19591	Write_rows	1	19625	table_id: # flags: STMT_END_F
master-bin.000001	19625	Table_map	1	19666	table_id: # (test.t1)
master-bin.000001	19666	Write_rows	1	19700	table_id: # flags: STMT_END_F
master-bin.000001	19700	Table_map	1	19741	table_id: # (test.t1)
master-bin.000001	19741	Write_rows	1	19775	table_id: # flags: STMT_END_F
master-bin.000001	19775	Table_map	1	19816	table_id: # (test.t1)
master-bin.000001	19816	Write_rows	1	19850	table_id: # flags: STMT_END_F
master-bin.000001	19850	Table_map	1	19891	table_id: # (test.t1)
master-bin.000001	19891	Write_rows	1	19925	table_id: # flags: STMT_END_F
master-bin.000001	19925	Table_map	1	19966	table_id: # (test.t1)
master-bin.000001	19966	Write_rows	1	20000	table_id: # flags: STMT_END_F
master-bin.000001	20000	Table_map	1	20041	table_id: # (test.t1)
master-bin.000001	20041	Write_rows	1	20075	table_id: # flags: STMT_END_F
master-bin.000001	20075	Table_map	1	20116	table_id: # (test.t1)
master-bin.000001	20116	Write_rows	1	20150	table_id: # flags: STMT_END_F
master-bin.000001	20150	Table_map	1	20191	table_id: # (test.t1)
master-bin.000001	20191	Write_rows	1	20225	table_id: # flags: STMT_END_F
master-bin.000001	20225	Table_map	1	20266	table_id: # (test.t1)
master-bin.000001	20266	Write_rows	1	20300	table_id: # flags: STMT_END_F
master-bin.000001	20300	Table_map	1	20341	table_id: # (test.t1)
master-bin.000001	20341	Write_rows	1	20375	table_id: # flags: STMT_END_F
master-bin.000001	20375	Table_map	1	20416	table_id: # (test.t1)
master-bin.000001	20416	Write_rows	1	20450	table_id: # flags: STMT_END_F
master-bin.000001	20450	Table_map	1	20491	table_id: # (test.t1)
master-bin.000001	20491	Write_rows	1	20525	table_id: # flags: STMT_END_F
master-bin.000001	20525	Table_map	1	20566	table_id: # (test.t1)
master-bin.000001	20566	Write_rows	1	20600	table_id: # flags: STMT_END_F
master-bin.000001	20600	Table_map	1	20641	table_id: # (test.t1)
master-bin.000001	20641	Write_rows	1	20675	table_id: # flags: STMT_END_F
master-bin.000001	20675	Table_map	1	20716	table_id: # (test.t1)
master-bin.000001	20716	Write_rows	1	20750	table_id: # flags: STMT_END_F
master-bin.000001	20750	Table_map	1	20791	table_id: # (test.t1)
master-bin.000001	20791	Write_rows	1	20825	table_id: # flags: STMT_END_F
master-bin.000001	20825	Table_map	1	20866	table_id: # (test.t1)
master-bin.000001	20866	Write_rows	1	20900	table_id: # flags: STMT_END_F
master-bin.000001	20900	Table_map	1	20941	table_id: # (test.t1)
master-bin.000001	20941	Write_rows	1	20975	table_id: # flags: STMT_END_F
master-bin.000001	20975	Table_map	1	21016	table_id: # (test.t1)
master-bin.000001	21016	Write_rows	1	21050	table_id: # flags: STMT_END_F
master-bin.000001	21050	Table_map	1	21091	table_id: # (test.t1)
master-bin.000001	21091	Write_rows	1	21125	table_id: # flags: STMT_END_F
master-bin.000001	21125	Table_map	1	21166	table_id: # (test.t1)
master-bin.000001	21166	Write_rows	1	21200	table_id: # flags: STMT_END_F
master-bin.000001	21200	Table_map	1	21241	table_id: # (test.t1)
master-bin.000001	21241	Write_rows	1	21275	table_id: # flags: STMT_END_F
master-bin.000001	21275	Table_map	1	21316	table_id: # (test.t1)
master-bin.000001	21316	Write_rows	1	21350	table_id: # flags: STMT_END_F
master-bin.000001	21350	Table_map	1	21391	table_id: # (test.t1)
master-bin.000001	21391	Write_rows	1	21425	table_id: # flags: STMT_END_F
master-bin.000001	21425	Table_map	1	21466	table_id: # (test.t1)
master-bin.000001	21466	Write_rows	1	21500	table_id: # flags: STMT_END_F
master-bin.000001	21500	Table_map	1	21541	table_id: # (test.t1)
master-bin.000001	21541	Write_rows	1	21575	table_id: # flags: STMT_END_F
master-bin.000001	21575	Table_map	1	21616	table_id: # (test.t1)
master-bin.000001	21616	Write_rows	1	21650	table_id: # flags: STMT_END_F
master-bin.000001	21650	Table_map	1	21691	table_id: # (test.t1)
master-bin.000001	21691	Write_rows	1	21725	table_id: # flags: STMT_END_F
master-bin.000001	21725	Table_map	1	21766	table_id: # (test.t1)
master-bin.000001	21766	Write_rows	1	21800	table_id: # flags: STMT_END_F
master-bin.000001	21800	Table_map	1	21841	table_id: # (test.t1)
master-bin.000001	21841	Write_rows	1	21875	table_id: # flags: STMT_END_F
master-bin.000001	21875	Table_map	1	21916	table_id: # (test.t1)
master-bin.000001	21916	Write_rows	1	21950	table_id: # flags: STMT_END_F
master-bin.000001	21950	Table_map	1	21991	table_id: # (test.t1)
master-bin.000001	21991	Write_rows	1	22025	table_id: # flags: STMT_END_F
master-bin.000001	22025	Table_map	1	22066	table_id: # (test.t1)
master-bin.000001	22066	Write_rows	1	22100	table_id: # flags: STMT_END_F
master-bin.000001	22100	Table_map	1	22141	table_id: # (test.t1)
master-bin.000001	22141	Write_rows	1	22175	table_id: # flags: STMT_END_F
master-bin.000001	22175	Table_map	1	22216	table_id: # (test.t1)
master-bin.000001	22216	Write_rows	1	22250	table_id: # flags: STMT_END_F
master-bin.000001	22250	Table_map	1	22291	table_id: # (test.t1)
master-bin.000001	22291	Write_rows	1	22325	table_id: # flags: STMT_END_F
master-bin.000001	22325	Table_map	1	22366	table_id: # (test.t1)
master-bin.000001	22366	Write_rows	1	22400	table_id: # flags: STMT_END_F
master-bin.000001	22400	Table_map	1	22441	table_id: # (test.t1)
master-bin.000001	22441	Write_rows	1	22475	table_id: # flags: STMT_END_F
master-bin.000001	22475	Table_map	1	22516	table_id: # (test.t1)
master-bin.000001	22516	Write_rows	1	22550	table_id: # flags: STMT_END_F
master-bin.000001	22550	Table_map	1	22591	table_id: # (test.t1)
master-bin.000001	22591	Write_rows	1	22625	table_id: # flags: STMT_END_F
master-bin.000001	22625	Table_map	1	22666	table_id: # (test.t1)
master-bin.000001	22666	Write_rows	1	22700	table_id: # flags: STMT_END_F
master-bin.000001	22700	Table_map	1	22741	table_id: # (test.t1)
master-bin.000001	22741	Write_rows	1	22775	table_id: # flags: STMT_END_F
master-bin.000001	22775	Table_map	1	22816	table_id: # (test.t1)
master-bin.000001	22816	Write_rows	1	22850	table_id: # flags: STMT_END_F
master-bin.000001	22850	Table_map	1	22891	table_id: # (test.t1)
master-bin.000001	22891	Write_rows	1	22925	table_id: # flags: STMT_END_F
master-bin.000001	22925	Table_map	1	22966	table_id: # (test.t1)
master-bin.000001	22966	Write_rows	1	23000	table_id: # flags: STMT_END_F
master-bin.000001	23000	Table_map	1	23041	table_id: # (test.t1)
master-bin.000001	23041	Write_rows	1	23075	table_id: # flags: STMT_END_F
master-bin.000001	23075	Table_map	1	23116	table_id: # (test.t1)
master-bin.000001	23116	Write_rows	1	23150	table_id: # flags: STMT_END_F
master-bin.000001	23150	Table_map	1	23191	table_id: # (test.t1)
master-bin.000001	23191	Write_rows	1	23225	table_id: # flags: STMT_END_F
master-bin.000001	23225	Table_map	1	23266	table_id: # (test.t1)
master-bin.000001	23266	Write_rows	1	23300	table_id: # flags: STMT_END_F
master-bin.000001	23300	Table_map	1	23341	table_id: # (test.t1)
master-bin.000001	23341	Write_rows	1	23375	table_id: # flags: STMT_END_F
master-bin.000001	23375	Table_map	1	23416	table_id: # (test.t1)
master-bin.000001	23416	Write_rows	1	23450	table_id: # flags: STMT_END_F
master-bin.000001	23450	Table_map	1	23491	table_id: # (test.t1)
master-bin.000001	23491	Write_rows	1	23525	table_id: # flags: STMT_END_F
master-bin.000001	23525	Table_map	1	23566	table_id: # (test.t1)
master-bin.000001	23566	Write_rows	1	23600	table_id: # flags: STMT_END_F
master-bin.000001	23600	Table_map	1	23641	table_id: # (test.t1)
master-bin.000001	23641	Write_rows	1	23675	table_id: # flags: STMT_END_F
master-bin.000001	23675	Table_map	1	23716	table_id: # (test.t1)
master-bin.000001	23716	Write_rows	1	23750	table_id: # flags: STMT_END_F
master-bin.000001	23750	Table_map	1	23791	table_id: # (test.t1)
master-bin.000001	23791	Write_rows	1	23825	table_id: # flags: STMT_END_F
master-bin.000001	23825	Table_map	1	23866	table_id: # (test.t1)
master-bin.000001	23866	Write_rows	1	23900	table_id: # flags: STMT_END_F
master-bin.000001	23900	Table_map	1	23941	table_id: # (test.t1)
master-bin.000001	23941	Write_rows	1	23975	table_id: # flags: STMT_END_F
master-bin.000001	23975	Table_map	1	24016	table_id: # (test.t1)
master-bin.000001	24016	Write_rows	1	24050	table_id: # flags: STMT_END_F
master-bin.000001	24050	Table_map	1	24091	table_id: # (test.t1)
master-bin.000001	24091	Write_rows	1	24125	table_id: # flags: STMT_END_F
master-bin.000001	24125	Table_map	1	24166	table_id: # (test.t1)
master-bin.000001	24166	Write_rows	1	24200	table_id: # flags: STMT_END_F
master-bin.000001	24200	Table_map	1	24241	table_id: # (test.t1)
master-bin.000001	24241	Write_rows	1	24275	table_id: # flags: STMT_END_F
master-bin.000001	24275	Table_map	1	24316	table_id: # (test.t1)
master-bin.000001	24316	Write_rows	1	24350	table_id: # flags: STMT_END_F
master-bin.000001	24350	Table_map	1	24391	table_id: # (test.t1)
master-bin.000001	24391	Write_rows	1	24425	table_id: # flags: STMT_END_F
master-bin.000001	24425	Table_map	1	24466	table_id: # (test.t1)
master-bin.000001	24466	Write_rows	1	24500	table_id: # flags: STMT_END_F
master-bin.000001	24500	Table_map	1	24541	table_id: # (test.t1)
master-bin.000001	24541	Write_rows	1	24575	table_id: # flags: STMT_END_F
master-bin.000001	24575	Table_map	1	24616	table_id: # (test.t1)
master-bin.000001	24616	Write_rows	1	24650	table_id: # flags: STMT_END_F
master-bin.000001	24650	Table_map	1	24691	table_id: # (test.t1)
master-bin.000001	24691	Write_rows	1	24725	table_id: # flags: STMT_END_F
master-bin.000001	24725	Table_map	1	24766	table_id: # (test.t1)
master-bin.000001	24766	Write_rows	1	24800	table_id: # flags: STMT_END_F
master-bin.000001	24800	Table_map	1	24841	table_id: # (test.t1)
master-bin.000001	24841	Write_rows	1	24875	table_id: # flags: STMT_END_F
master-bin.000001	24875	Table_map	1	24916	table_id: # (test.t1)
master-bin.000001	24916	Write_rows	1	24950	table_id: # flags: STMT_END_F
master-bin.000001	24950	Table_map	1	24991	table_id: # (test.t1)
master-bin.000001	24991	Write_rows	1	25025	table_id: # flags: STMT_END_F
master-bin.000001	25025	Table_map	1	25066	table_id: # (test.t1)
master-bin.000001	25066	Write_rows	1	25100	table_id: # flags: STMT_END_F
master-bin.000001	25100	Table_map	1	25141	table_id: # (test.t1)
master-bin.000001	25141	Write_rows	1	25175	table_id: # flags: STMT_END_F
master-bin.000001	25175	Table_map	1	25216	table_id: # (test.t1)
master-bin.000001	25216	Write_rows	1	25250	table_id: # flags: STMT_END_F
master-bin.000001	25250	Table_map	1	25291	table_id: # (test.t1)
master-bin.000001	25291	Write_rows	1	25325	table_id: # flags: STMT_END_F
master-bin.000001	25325	Table_map	1	25366	table_id: # (test.t1)
master-bin.000001	25366	Write_rows	1	25400	table_id: # flags: STMT_END_F
master-bin.000001	25400	Table_map	1	25441	table_id: # (test.t1)
master-bin.000001	25441	Write_rows	1	25475	table_id: # flags: STMT_END_F
master-bin.000001	25475	Table_map	1	25516	table_id: # (test.t1)
master-bin.000001	25516	Write_rows	1	25550	table_id: # flags: STMT_END_F
master-bin.000001	25550	Table_map	1	25591	table_id: # (test.t1)
master-bin.000001	25591	Write_rows	1	25625	table_id: # flags: STMT_END_F
master-bin.000001	25625	Table_map	1	25666	table_id: # (test.t1)
master-bin.000001	25666	Write_rows	1	25700	table_id: # flags: STMT_END_F
master-bin.000001	25700	Table_map	1	25741	table_id: # (test.t1)
master-bin.000001	25741	Write_rows	1	25775	table_id: # flags: STMT_END_F
master-bin.000001	25775	Table_map	1	25816	table_id: # (test.t1)
master-bin.000001	25816	Write_rows	1	25850	table_id: # flags: STMT_END_F
master-bin.000001	25850	Table_map	1	25891	table_id: # (test.t1)
master-bin.000001	25891	Write_rows	1	25925	table_id: # flags: STMT_END_F
master-bin.000001	25925	Table_map	1	25966	table_id: # (test.t1)
master-bin.000001	25966	Write_rows	1	26000	table_id: # flags: STMT_END_F
master-bin.000001	26000	Table_map	1	26041	table_id: # (test.t1)
master-bin.000001	26041	Write_rows	1	26075	table_id: # flags: STMT_END_F
master-bin.000001	26075	Table_map	1	26116	table_id: # (test.t1)
master-bin.000001	26116	Write_rows	1	26150	table_id: # flags: STMT_END_F
master-bin.000001	26150	Table_map	1	26191	table_id: # (test.t1)
master-bin.000001	26191	Write_rows	1	26225	table_id: # flags: STMT_END_F
master-bin.000001	26225	Table_map	1	26266	table_id: # (test.t1)
master-bin.000001	26266	Write_rows	1	26300	table_id: # flags: STMT_END_F
master-bin.000001	26300	Table_map	1	26341	table_id: # (test.t1)
master-bin.000001	26341	Write_rows	1	26375	table_id: # flags: STMT_END_F
master-bin.000001	26375	Table_map	1	26416	table_id: # (test.t1)
master-bin.000001	26416	Write_rows	1	26450	table_id: # flags: STMT_END_F
master-bin.000001	26450	Table_map	1	26491	table_id: # (test.t1)
master-bin.000001	26491	Write_rows	1	26525	table_id: # flags: STMT_END_F
master-bin.000001	26525	Table_map	1	26566	table_id: # (test.t1)
master-bin.000001	26566	Write_rows	1	26600	table_id: # flags: STMT_END_F
master-bin.000001	26600	Table_map	1	26641	table_id: # (test.t1)
master-bin.000001	26641	Write_rows	1	26675	table_id: # flags: STMT_END_F
master-bin.000001	26675	Table_map	1	26716	table_id: # (test.t1)
master-bin.000001	26716	Write_rows	1	26750	table_id: # flags: STMT_END_F
master-bin.000001	26750	Table_map	1	26791	table_id: # (test.t1)
master-bin.000001	26791	Write_rows	1	26825	table_id: # flags: STMT_END_F
master-bin.000001	26825	Table_map	1	26866	table_id: # (test.t1)
master-bin.000001	26866	Write_rows	1	26900	table_id: # flags: STMT_END_F
master-bin.000001	26900	Table_map	1	26941	table_id: # (test.t1)
master-bin.000001	26941	Write_rows	1	26975	table_id: # flags: STMT_END_F
master-bin.000001	26975	Table_map	1	27016	table_id: # (test.t1)
master-bin.000001	27016	Write_rows	1	27050	table_id: # flags: STMT_END_F
master-bin.000001	27050	Table_map	1	27091	table_id: # (test.t1)
master-bin.000001	27091	Write_rows	1	27125	table_id: # flags: STMT_END_F
master-bin.000001	27125	Table_map	1	27166	table_id: # (test.t1)
master-bin.000001	27166	Write_rows	1	27200	table_id: # flags: STMT_END_F
master-bin.000001	27200	Table_map	1	27241	table_id: # (test.t1)
master-bin.000001	27241	Write_rows	1	27275	table_id: # flags: STMT_END_F
master-bin.000001	27275	Table_map	1	27316	table_id: # (test.t1)
master-bin.000001	27316	Write_rows	1	27350	table_id: # flags: STMT_END_F
master-bin.000001	27350	Table_map	1	27391	table_id: # (test.t1)
master-bin.000001	27391	Write_rows	1	27425	table_id: # flags: STMT_END_F
master-bin.000001	27425	Table_map	1	27466	table_id: # (test.t1)
master-bin.000001	27466	Write_rows	1	27500	table_id: # flags: STMT_END_F
master-bin.000001	27500	Table_map	1	27541	table_id: # (test.t1)
master-bin.000001	27541	Write_rows	1	27575	table_id: # flags: STMT_END_F
master-bin.000001	27575	Table_map	1	27616	table_id: # (test.t1)
master-bin.000001	27616	Write_rows	1	27650	table_id: # flags: STMT_END_F
master-bin.000001	27650	Table_map	1	27691	table_id: # (test.t1)
master-bin.000001	27691	Write_rows	1	27725	table_id: # flags: STMT_END_F
master-bin.000001	27725	Table_map	1	27766	table_id: # (test.t1)
master-bin.000001	27766	Write_rows	1	27800	table_id: # flags: STMT_END_F
master-bin.000001	27800	Table_map	1	27841	table_id: # (test.t1)
master-bin.000001	27841	Write_rows	1	27875	table_id: # flags: STMT_END_F
master-bin.000001	27875	Table_map	1	27916	table_id: # (test.t1)
master-bin.000001	27916	Write_rows	1	27950	table_id: # flags: STMT_END_F
master-bin.000001	27950	Table_map	1	27991	table_id: # (test.t1)
master-bin.000001	27991	Write_rows	1	28025	table_id: # flags: STMT_END_F
master-bin.000001	28025	Table_map	1	28066	table_id: # (test.t1)
master-bin.000001	28066	Write_rows	1	28100	table_id: # flags: STMT_END_F
master-bin.000001	28100	Table_map	1	28141	table_id: # (test.t1)
master-bin.000001	28141	Write_rows	1	28175	table_id: # flags: STMT_END_F
master-bin.000001	28175	Table_map	1	28216	table_id: # (test.t1)
master-bin.000001	28216	Write_rows	1	28250	table_id: # flags: STMT_END_F
master-bin.000001	28250	Table_map	1	28291	table_id: # (test.t1)
master-bin.000001	28291	Write_rows	1	28325	table_id: # flags: STMT_END_F
master-bin.000001	28325	Table_map	1	28366	table_id: # (test.t1)
master-bin.000001	28366	Write_rows	1	28400	table_id: # flags: STMT_END_F
master-bin.000001	28400	Table_map	1	28441	table_id: # (test.t1)
master-bin.000001	28441	Write_rows	1	28475	table_id: # flags: STMT_END_F
master-bin.000001	28475	Table_map	1	28516	table_id: # (test.t1)
master-bin.000001	28516	Write_rows	1	28550	table_id: # flags: STMT_END_F
master-bin.000001	28550	Table_map	1	28591	table_id: # (test.t1)
master-bin.000001	28591	Write_rows	1	28625	table_id: # flags: STMT_END_F
master-bin.000001	28625	Table_map	1	28666	table_id: # (test.t1)
master-bin.000001	28666	Write_rows	1	28700	table_id: # flags: STMT_END_F
master-bin.000001	28700	Table_map	1	28741	table_id: # (test.t1)
master-bin.000001	28741	Write_rows	1	28775	table_id: # flags: STMT_END_F
master-bin.000001	28775	Table_map	1	28816	table_id: # (test.t1)
master-bin.000001	28816	Write_rows	1	28850	table_id: # flags: STMT_END_F
master-bin.000001	28850	Table_map	1	28891	table_id: # (test.t1)
master-bin.000001	28891	Write_rows	1	28925	table_id: # flags: STMT_END_F
master-bin.000001	28925	Table_map	1	28966	table_id: # (test.t1)
master-bin.000001	28966	Write_rows	1	29000	table_id: # flags: STMT_END_F
master-bin.000001	29000	Table_map	1	29041	table_id: # (test.t1)
master-bin.000001	29041	Write_rows	1	29075	table_id: # flags: STMT_END_F
master-bin.000001	29075	Table_map	1	29116	table_id: # (test.t1)
master-bin.000001	29116	Write_rows	1	29150	table_id: # flags: STMT_END_F
master-bin.000001	29150	Table_map	1	29191	table_id: # (test.t1)
master-bin.000001	29191	Write_rows	1	29225	table_id: # flags: STMT_END_F
master-bin.000001	29225	Table_map	1	29266	table_id: # (test.t1)
master-bin.000001	29266	Write_rows	1	29300	table_id: # flags: STMT_END_F
master-bin.000001	29300	Table_map	1	29341	table_id: # (test.t1)
master-bin.000001	29341	Write_rows	1	29375	table_id: # flags: STMT_END_F
master-bin.000001	29375	Table_map	1	29416	table_id: # (test.t1)
master-bin.000001	29416	Write_rows	1	29450	table_id: # flags: STMT_END_F
master-bin.000001	29450	Table_map	1	29491	table_id: # (test.t1)
master-bin.000001	29491	Write_rows	1	29525	table_id: # flags: STMT_END_F
master-bin.000001	29525	Table_map	1	29566	table_id: # (test.t1)
master-bin.000001	29566	Write_rows	1	29600	table_id: # flags: STMT_END_F
master-bin.000001	29600	Table_map	1	29641	table_id: # (test.t1)
master-bin.000001	29641	Write_rows	1	29675	table_id: # flags: STMT_END_F
master-bin.000001	29675	Table_map	1	29716	table_id: # (test.t1)
master-bin.000001	29716	Write_rows	1	29750	table_id: # flags: STMT_END_F
master-bin.000001	29750	Table_map	1	29791	table_id: # (test.t1)
master-bin.000001	29791	Write_rows	1	29825	table_id: # flags: STMT_END_F
master-bin.000001	29825	Table_map	1	29866	table_id: # (test.t1)
master-bin.000001	29866	Write_rows	1	29900	table_id: # flags: STMT_END_F
master-bin.000001	29900	Table_map	1	29941	table_id: # (test.t1)
master-bin.000001	29941	Write_rows	1	29975	table_id: # flags: STMT_END_F
master-bin.000001	29975	Table_map	1	30016	table_id: # (test.t1)
master-bin.000001	30016	Write_rows	1	30050	table_id: # flags: STMT_END_F
master-bin.000001	30050	Table_map	1	30091	table_id: # (test.t1)
master-bin.000001	30091	Write_rows	1	30125	table_id: # flags: STMT_END_F
master-bin.000001	30125	Table_map	1	30166	table_id: # (test.t1)
master-bin.000001	30166	Write_rows	1	30200	table_id: # flags: STMT_END_F
master-bin.000001	30200	Table_map	1	30241	table_id: # (test.t1)
master-bin.000001	30241	Write_rows	1	30275	table_id: # flags: STMT_END_F
master-bin.000001	30275	Xid	1	30302	COMMIT /* XID */
master-bin.000001	30302	Rotate	1	30346	master-bin.000002;pos=4
drop table t1;
set global binlog_cache_size=@bcs;
set session autocommit = @ac;
drop table if exists t1;
reset master;
create table t1 (a bigint unsigned, b bigint(20) unsigned);
prepare stmt from "insert into t1 values (?,?)";
set @a= 9999999999999999;
set @b= 14632475938453979136;
execute stmt using @a, @b;
deallocate prepare stmt;
drop table t1;
show binlog events from 0;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	4	Format_desc	1	107	Server version, Binlog ver: 4
master-bin.000001	107	Query	1	228	use `test`; create table t1 (a bigint unsigned, b bigint(20) unsigned)
master-bin.000001	228	Query	1	296	use `test`; BEGIN
master-bin.000001	296	Table_map	1	338	table_id: # (test.t1)
master-bin.000001	338	Write_rows	1	384	table_id: # flags: STMT_END_F
master-bin.000001	384	Query	1	453	use `test`; COMMIT
master-bin.000001	453	Query	1	529	use `test`; drop table t1
End of 5.0 tests
reset master;
create table t1 (id tinyint auto_increment primary key);
set insert_id=128;
insert into t1 values(null);
Warnings:
Warning	1264	Out of range value for column 'id' at row 1
select * from t1;
id
127
drop table t1;
create table t1 (a int);
create table if not exists t2 select * from t1;
create temporary table tt1 (a int);
create table if not exists t3 like tt1;
USE mysql;
INSERT INTO user SET host='localhost', user='@#@', password=password('Just a test');
UPDATE user SET password=password('Another password') WHERE host='localhost' AND user='@#@';
DELETE FROM user WHERE host='localhost' AND user='@#@';
use test;
show binlog events from <binlog_start>;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	use `test`; create table t1 (id tinyint auto_increment primary key)
master-bin.000001	#	Query	#	#	use `test`; BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	use `test`; COMMIT
master-bin.000001	#	Query	#	#	use `test`; drop table t1
master-bin.000001	#	Query	#	#	use `test`; create table t1 (a int)
master-bin.000001	#	Query	#	#	use `test`; BEGIN
master-bin.000001	#	Query	#	#	use `test`; CREATE TABLE IF NOT EXISTS `t2` (
  `a` int(11) DEFAULT NULL
)
master-bin.000001	#	Query	#	#	use `test`; COMMIT
master-bin.000001	#	Query	#	#	use `test`; CREATE TABLE IF NOT EXISTS `t3` (
  `a` int(11) DEFAULT NULL
)
master-bin.000001	#	Query	#	#	use `mysql`; BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (mysql.user)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	use `mysql`; COMMIT
master-bin.000001	#	Query	#	#	use `mysql`; BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (mysql.user)
master-bin.000001	#	Update_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	use `mysql`; COMMIT
master-bin.000001	#	Query	#	#	use `mysql`; BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (mysql.user)
master-bin.000001	#	Delete_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	use `mysql`; COMMIT
drop table t1,t2,t3,tt1;
create table t1 (a int not null auto_increment, primary key (a)) engine=myisam;
set @@session.auto_increment_increment=1, @@session.auto_increment_offset=1;
insert delayed into t1 values (207);
insert delayed into t1 values (null);
insert delayed into t1 values (300);
show binlog events from <binlog_start>;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	use `test`; create table t1 (id tinyint auto_increment primary key)
master-bin.000001	#	Query	#	#	use `test`; BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	use `test`; COMMIT
master-bin.000001	#	Query	#	#	use `test`; drop table t1
master-bin.000001	#	Query	#	#	use `test`; create table t1 (a int)
master-bin.000001	#	Query	#	#	use `test`; BEGIN
master-bin.000001	#	Query	#	#	use `test`; CREATE TABLE IF NOT EXISTS `t2` (
  `a` int(11) DEFAULT NULL
)
master-bin.000001	#	Query	#	#	use `test`; COMMIT
master-bin.000001	#	Query	#	#	use `test`; CREATE TABLE IF NOT EXISTS `t3` (
  `a` int(11) DEFAULT NULL
)
master-bin.000001	#	Query	#	#	use `mysql`; BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (mysql.user)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	use `mysql`; COMMIT
master-bin.000001	#	Query	#	#	use `mysql`; BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (mysql.user)
master-bin.000001	#	Update_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	use `mysql`; COMMIT
master-bin.000001	#	Query	#	#	use `mysql`; BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (mysql.user)
master-bin.000001	#	Delete_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	use `mysql`; COMMIT
master-bin.000001	#	Query	#	#	use `test`; DROP TABLE `t1`,`t2`,`t3` /* generated by server */
master-bin.000001	#	Query	#	#	use `test`; create table t1 (a int not null auto_increment, primary key (a)) engine=myisam
master-bin.000001	#	Query	#	#	use `test`; BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	use `test`; COMMIT
master-bin.000001	#	Query	#	#	use `test`; BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	use `test`; COMMIT
master-bin.000001	#	Query	#	#	use `test`; BEGIN
master-bin.000001	#	Table_map	#	#	table_id: # (test.t1)
master-bin.000001	#	Write_rows	#	#	table_id: # flags: STMT_END_F
master-bin.000001	#	Query	#	#	use `test`; COMMIT
insert delayed into t1 values (null),(null),(null),(null);
insert delayed into t1 values (null),(null),(400),(null);
11 == 11
select * from t1;
a
207
208
300
301
302
303
304
305
306
400
401
drop table t1;
reset master;
drop table if exists t3;
create table t3 (a int(11) NOT NULL AUTO_INCREMENT, b text, PRIMARY KEY (a) ) engine=innodb;
show master status;
File	Position	Binlog_Do_DB	Binlog_Ignore_DB
master-bin.000001	347		
insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
show master status /* must show new binlog index after rotating */;
File	Position	Binlog_Do_DB	Binlog_Ignore_DB
master-bin.000002	107		
drop table t3;