create table t1 (a int, b int) engine=innodb; begin; insert into t1 values (1,2); commit; show binlog events; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 4 Format_desc 1 106 Server ver: #, Binlog ver: # master-bin.000001 106 Query 1 213 use `test`; create table t1 (a int, b int) engine=innodb master-bin.000001 213 Query 1 281 use `test`; BEGIN master-bin.000001 281 Query 1 371 use `test`; insert into t1 values (1,2) master-bin.000001 371 Xid 1 398 COMMIT /* XID */ drop table t1; 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 # Query # # use `test`; insert t1 values (5) master-bin.000001 # Xid # # COMMIT /* XID */ master-bin.000001 # Query # # use `test`; BEGIN master-bin.000001 # Query # # use `test`; insert t2 values (5) 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 106; 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 # Query 1 # use `test`; insert into t1 values(100 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(99 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(98 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(97 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(96 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(95 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(94 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(93 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(92 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(91 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(90 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(89 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(88 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(87 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(86 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(85 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(84 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(83 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(82 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(81 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(80 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(79 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(78 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(77 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(76 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(75 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(74 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(73 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(72 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(71 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(70 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(69 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(68 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(67 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(66 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(65 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(64 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(63 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(62 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(61 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(60 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(59 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(58 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(57 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(56 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(55 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(54 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(53 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(52 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(51 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(50 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(49 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(48 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(47 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(46 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(45 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(44 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(43 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(42 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(41 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(40 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(39 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(38 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(37 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(36 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(35 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(34 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(33 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(32 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(31 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(30 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(29 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(28 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(27 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(26 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(25 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(24 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(23 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(22 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(21 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(20 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(19 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(18 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(17 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(16 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(15 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(14 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(13 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(12 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(11 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(10 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(9 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(8 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(7 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(6 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(5 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(4 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(3 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(2 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(1 + 4) 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 106; 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 106 Server version, Binlog ver: 4 master-bin.000001 106 Query 1 205 use `test`; create table t1(n int) engine=innodb master-bin.000001 205 Query 1 273 use `test`; BEGIN master-bin.000001 273 Query 1 361 use `test`; insert into t1 values (1) master-bin.000001 361 Query 1 449 use `test`; insert into t1 values (2) master-bin.000001 449 Query 1 537 use `test`; insert into t1 values (3) master-bin.000001 537 Xid 1 564 COMMIT /* XID */ master-bin.000001 564 Query 1 640 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 106 Server version, Binlog ver: 4 master-bin.000001 106 Query 1 206 use `test`; create table t1 (a int) engine=innodb master-bin.000001 206 Query 1 274 use `test`; BEGIN master-bin.000001 274 Query 1 365 use `test`; insert into t1 values( 400 ) master-bin.000001 365 Query 1 456 use `test`; insert into t1 values( 399 ) master-bin.000001 456 Query 1 547 use `test`; insert into t1 values( 398 ) master-bin.000001 547 Query 1 638 use `test`; insert into t1 values( 397 ) master-bin.000001 638 Query 1 729 use `test`; insert into t1 values( 396 ) master-bin.000001 729 Query 1 820 use `test`; insert into t1 values( 395 ) master-bin.000001 820 Query 1 911 use `test`; insert into t1 values( 394 ) master-bin.000001 911 Query 1 1002 use `test`; insert into t1 values( 393 ) master-bin.000001 1002 Query 1 1093 use `test`; insert into t1 values( 392 ) master-bin.000001 1093 Query 1 1184 use `test`; insert into t1 values( 391 ) master-bin.000001 1184 Query 1 1275 use `test`; insert into t1 values( 390 ) master-bin.000001 1275 Query 1 1366 use `test`; insert into t1 values( 389 ) master-bin.000001 1366 Query 1 1457 use `test`; insert into t1 values( 388 ) master-bin.000001 1457 Query 1 1548 use `test`; insert into t1 values( 387 ) master-bin.000001 1548 Query 1 1639 use `test`; insert into t1 values( 386 ) master-bin.000001 1639 Query 1 1730 use `test`; insert into t1 values( 385 ) master-bin.000001 1730 Query 1 1821 use `test`; insert into t1 values( 384 ) master-bin.000001 1821 Query 1 1912 use `test`; insert into t1 values( 383 ) master-bin.000001 1912 Query 1 2003 use `test`; insert into t1 values( 382 ) master-bin.000001 2003 Query 1 2094 use `test`; insert into t1 values( 381 ) master-bin.000001 2094 Query 1 2185 use `test`; insert into t1 values( 380 ) master-bin.000001 2185 Query 1 2276 use `test`; insert into t1 values( 379 ) master-bin.000001 2276 Query 1 2367 use `test`; insert into t1 values( 378 ) master-bin.000001 2367 Query 1 2458 use `test`; insert into t1 values( 377 ) master-bin.000001 2458 Query 1 2549 use `test`; insert into t1 values( 376 ) master-bin.000001 2549 Query 1 2640 use `test`; insert into t1 values( 375 ) master-bin.000001 2640 Query 1 2731 use `test`; insert into t1 values( 374 ) master-bin.000001 2731 Query 1 2822 use `test`; insert into t1 values( 373 ) master-bin.000001 2822 Query 1 2913 use `test`; insert into t1 values( 372 ) master-bin.000001 2913 Query 1 3004 use `test`; insert into t1 values( 371 ) master-bin.000001 3004 Query 1 3095 use `test`; insert into t1 values( 370 ) master-bin.000001 3095 Query 1 3186 use `test`; insert into t1 values( 369 ) master-bin.000001 3186 Query 1 3277 use `test`; insert into t1 values( 368 ) master-bin.000001 3277 Query 1 3368 use `test`; insert into t1 values( 367 ) master-bin.000001 3368 Query 1 3459 use `test`; insert into t1 values( 366 ) master-bin.000001 3459 Query 1 3550 use `test`; insert into t1 values( 365 ) master-bin.000001 3550 Query 1 3641 use `test`; insert into t1 values( 364 ) master-bin.000001 3641 Query 1 3732 use `test`; insert into t1 values( 363 ) master-bin.000001 3732 Query 1 3823 use `test`; insert into t1 values( 362 ) master-bin.000001 3823 Query 1 3914 use `test`; insert into t1 values( 361 ) master-bin.000001 3914 Query 1 4005 use `test`; insert into t1 values( 360 ) master-bin.000001 4005 Query 1 4096 use `test`; insert into t1 values( 359 ) master-bin.000001 4096 Query 1 4187 use `test`; insert into t1 values( 358 ) master-bin.000001 4187 Query 1 4278 use `test`; insert into t1 values( 357 ) master-bin.000001 4278 Query 1 4369 use `test`; insert into t1 values( 356 ) master-bin.000001 4369 Query 1 4460 use `test`; insert into t1 values( 355 ) master-bin.000001 4460 Query 1 4551 use `test`; insert into t1 values( 354 ) master-bin.000001 4551 Query 1 4642 use `test`; insert into t1 values( 353 ) master-bin.000001 4642 Query 1 4733 use `test`; insert into t1 values( 352 ) master-bin.000001 4733 Query 1 4824 use `test`; insert into t1 values( 351 ) master-bin.000001 4824 Query 1 4915 use `test`; insert into t1 values( 350 ) master-bin.000001 4915 Query 1 5006 use `test`; insert into t1 values( 349 ) master-bin.000001 5006 Query 1 5097 use `test`; insert into t1 values( 348 ) master-bin.000001 5097 Query 1 5188 use `test`; insert into t1 values( 347 ) master-bin.000001 5188 Query 1 5279 use `test`; insert into t1 values( 346 ) master-bin.000001 5279 Query 1 5370 use `test`; insert into t1 values( 345 ) master-bin.000001 5370 Query 1 5461 use `test`; insert into t1 values( 344 ) master-bin.000001 5461 Query 1 5552 use `test`; insert into t1 values( 343 ) master-bin.000001 5552 Query 1 5643 use `test`; insert into t1 values( 342 ) master-bin.000001 5643 Query 1 5734 use `test`; insert into t1 values( 341 ) master-bin.000001 5734 Query 1 5825 use `test`; insert into t1 values( 340 ) master-bin.000001 5825 Query 1 5916 use `test`; insert into t1 values( 339 ) master-bin.000001 5916 Query 1 6007 use `test`; insert into t1 values( 338 ) master-bin.000001 6007 Query 1 6098 use `test`; insert into t1 values( 337 ) master-bin.000001 6098 Query 1 6189 use `test`; insert into t1 values( 336 ) master-bin.000001 6189 Query 1 6280 use `test`; insert into t1 values( 335 ) master-bin.000001 6280 Query 1 6371 use `test`; insert into t1 values( 334 ) master-bin.000001 6371 Query 1 6462 use `test`; insert into t1 values( 333 ) master-bin.000001 6462 Query 1 6553 use `test`; insert into t1 values( 332 ) master-bin.000001 6553 Query 1 6644 use `test`; insert into t1 values( 331 ) master-bin.000001 6644 Query 1 6735 use `test`; insert into t1 values( 330 ) master-bin.000001 6735 Query 1 6826 use `test`; insert into t1 values( 329 ) master-bin.000001 6826 Query 1 6917 use `test`; insert into t1 values( 328 ) master-bin.000001 6917 Query 1 7008 use `test`; insert into t1 values( 327 ) master-bin.000001 7008 Query 1 7099 use `test`; insert into t1 values( 326 ) master-bin.000001 7099 Query 1 7190 use `test`; insert into t1 values( 325 ) master-bin.000001 7190 Query 1 7281 use `test`; insert into t1 values( 324 ) master-bin.000001 7281 Query 1 7372 use `test`; insert into t1 values( 323 ) master-bin.000001 7372 Query 1 7463 use `test`; insert into t1 values( 322 ) master-bin.000001 7463 Query 1 7554 use `test`; insert into t1 values( 321 ) master-bin.000001 7554 Query 1 7645 use `test`; insert into t1 values( 320 ) master-bin.000001 7645 Query 1 7736 use `test`; insert into t1 values( 319 ) master-bin.000001 7736 Query 1 7827 use `test`; insert into t1 values( 318 ) master-bin.000001 7827 Query 1 7918 use `test`; insert into t1 values( 317 ) master-bin.000001 7918 Query 1 8009 use `test`; insert into t1 values( 316 ) master-bin.000001 8009 Query 1 8100 use `test`; insert into t1 values( 315 ) master-bin.000001 8100 Query 1 8191 use `test`; insert into t1 values( 314 ) master-bin.000001 8191 Query 1 8282 use `test`; insert into t1 values( 313 ) master-bin.000001 8282 Query 1 8373 use `test`; insert into t1 values( 312 ) master-bin.000001 8373 Query 1 8464 use `test`; insert into t1 values( 311 ) master-bin.000001 8464 Query 1 8555 use `test`; insert into t1 values( 310 ) master-bin.000001 8555 Query 1 8646 use `test`; insert into t1 values( 309 ) master-bin.000001 8646 Query 1 8737 use `test`; insert into t1 values( 308 ) master-bin.000001 8737 Query 1 8828 use `test`; insert into t1 values( 307 ) master-bin.000001 8828 Query 1 8919 use `test`; insert into t1 values( 306 ) master-bin.000001 8919 Query 1 9010 use `test`; insert into t1 values( 305 ) master-bin.000001 9010 Query 1 9101 use `test`; insert into t1 values( 304 ) master-bin.000001 9101 Query 1 9192 use `test`; insert into t1 values( 303 ) master-bin.000001 9192 Query 1 9283 use `test`; insert into t1 values( 302 ) master-bin.000001 9283 Query 1 9374 use `test`; insert into t1 values( 301 ) master-bin.000001 9374 Query 1 9465 use `test`; insert into t1 values( 300 ) master-bin.000001 9465 Query 1 9556 use `test`; insert into t1 values( 299 ) master-bin.000001 9556 Query 1 9647 use `test`; insert into t1 values( 298 ) master-bin.000001 9647 Query 1 9738 use `test`; insert into t1 values( 297 ) master-bin.000001 9738 Query 1 9829 use `test`; insert into t1 values( 296 ) master-bin.000001 9829 Query 1 9920 use `test`; insert into t1 values( 295 ) master-bin.000001 9920 Query 1 10011 use `test`; insert into t1 values( 294 ) master-bin.000001 10011 Query 1 10102 use `test`; insert into t1 values( 293 ) master-bin.000001 10102 Query 1 10193 use `test`; insert into t1 values( 292 ) master-bin.000001 10193 Query 1 10284 use `test`; insert into t1 values( 291 ) master-bin.000001 10284 Query 1 10375 use `test`; insert into t1 values( 290 ) master-bin.000001 10375 Query 1 10466 use `test`; insert into t1 values( 289 ) master-bin.000001 10466 Query 1 10557 use `test`; insert into t1 values( 288 ) master-bin.000001 10557 Query 1 10648 use `test`; insert into t1 values( 287 ) master-bin.000001 10648 Query 1 10739 use `test`; insert into t1 values( 286 ) master-bin.000001 10739 Query 1 10830 use `test`; insert into t1 values( 285 ) master-bin.000001 10830 Query 1 10921 use `test`; insert into t1 values( 284 ) master-bin.000001 10921 Query 1 11012 use `test`; insert into t1 values( 283 ) master-bin.000001 11012 Query 1 11103 use `test`; insert into t1 values( 282 ) master-bin.000001 11103 Query 1 11194 use `test`; insert into t1 values( 281 ) master-bin.000001 11194 Query 1 11285 use `test`; insert into t1 values( 280 ) master-bin.000001 11285 Query 1 11376 use `test`; insert into t1 values( 279 ) master-bin.000001 11376 Query 1 11467 use `test`; insert into t1 values( 278 ) master-bin.000001 11467 Query 1 11558 use `test`; insert into t1 values( 277 ) master-bin.000001 11558 Query 1 11649 use `test`; insert into t1 values( 276 ) master-bin.000001 11649 Query 1 11740 use `test`; insert into t1 values( 275 ) master-bin.000001 11740 Query 1 11831 use `test`; insert into t1 values( 274 ) master-bin.000001 11831 Query 1 11922 use `test`; insert into t1 values( 273 ) master-bin.000001 11922 Query 1 12013 use `test`; insert into t1 values( 272 ) master-bin.000001 12013 Query 1 12104 use `test`; insert into t1 values( 271 ) master-bin.000001 12104 Query 1 12195 use `test`; insert into t1 values( 270 ) master-bin.000001 12195 Query 1 12286 use `test`; insert into t1 values( 269 ) master-bin.000001 12286 Query 1 12377 use `test`; insert into t1 values( 268 ) master-bin.000001 12377 Query 1 12468 use `test`; insert into t1 values( 267 ) master-bin.000001 12468 Query 1 12559 use `test`; insert into t1 values( 266 ) master-bin.000001 12559 Query 1 12650 use `test`; insert into t1 values( 265 ) master-bin.000001 12650 Query 1 12741 use `test`; insert into t1 values( 264 ) master-bin.000001 12741 Query 1 12832 use `test`; insert into t1 values( 263 ) master-bin.000001 12832 Query 1 12923 use `test`; insert into t1 values( 262 ) master-bin.000001 12923 Query 1 13014 use `test`; insert into t1 values( 261 ) master-bin.000001 13014 Query 1 13105 use `test`; insert into t1 values( 260 ) master-bin.000001 13105 Query 1 13196 use `test`; insert into t1 values( 259 ) master-bin.000001 13196 Query 1 13287 use `test`; insert into t1 values( 258 ) master-bin.000001 13287 Query 1 13378 use `test`; insert into t1 values( 257 ) master-bin.000001 13378 Query 1 13469 use `test`; insert into t1 values( 256 ) master-bin.000001 13469 Query 1 13560 use `test`; insert into t1 values( 255 ) master-bin.000001 13560 Query 1 13651 use `test`; insert into t1 values( 254 ) master-bin.000001 13651 Query 1 13742 use `test`; insert into t1 values( 253 ) master-bin.000001 13742 Query 1 13833 use `test`; insert into t1 values( 252 ) master-bin.000001 13833 Query 1 13924 use `test`; insert into t1 values( 251 ) master-bin.000001 13924 Query 1 14015 use `test`; insert into t1 values( 250 ) master-bin.000001 14015 Query 1 14106 use `test`; insert into t1 values( 249 ) master-bin.000001 14106 Query 1 14197 use `test`; insert into t1 values( 248 ) master-bin.000001 14197 Query 1 14288 use `test`; insert into t1 values( 247 ) master-bin.000001 14288 Query 1 14379 use `test`; insert into t1 values( 246 ) master-bin.000001 14379 Query 1 14470 use `test`; insert into t1 values( 245 ) master-bin.000001 14470 Query 1 14561 use `test`; insert into t1 values( 244 ) master-bin.000001 14561 Query 1 14652 use `test`; insert into t1 values( 243 ) master-bin.000001 14652 Query 1 14743 use `test`; insert into t1 values( 242 ) master-bin.000001 14743 Query 1 14834 use `test`; insert into t1 values( 241 ) master-bin.000001 14834 Query 1 14925 use `test`; insert into t1 values( 240 ) master-bin.000001 14925 Query 1 15016 use `test`; insert into t1 values( 239 ) master-bin.000001 15016 Query 1 15107 use `test`; insert into t1 values( 238 ) master-bin.000001 15107 Query 1 15198 use `test`; insert into t1 values( 237 ) master-bin.000001 15198 Query 1 15289 use `test`; insert into t1 values( 236 ) master-bin.000001 15289 Query 1 15380 use `test`; insert into t1 values( 235 ) master-bin.000001 15380 Query 1 15471 use `test`; insert into t1 values( 234 ) master-bin.000001 15471 Query 1 15562 use `test`; insert into t1 values( 233 ) master-bin.000001 15562 Query 1 15653 use `test`; insert into t1 values( 232 ) master-bin.000001 15653 Query 1 15744 use `test`; insert into t1 values( 231 ) master-bin.000001 15744 Query 1 15835 use `test`; insert into t1 values( 230 ) master-bin.000001 15835 Query 1 15926 use `test`; insert into t1 values( 229 ) master-bin.000001 15926 Query 1 16017 use `test`; insert into t1 values( 228 ) master-bin.000001 16017 Query 1 16108 use `test`; insert into t1 values( 227 ) master-bin.000001 16108 Query 1 16199 use `test`; insert into t1 values( 226 ) master-bin.000001 16199 Query 1 16290 use `test`; insert into t1 values( 225 ) master-bin.000001 16290 Query 1 16381 use `test`; insert into t1 values( 224 ) master-bin.000001 16381 Query 1 16472 use `test`; insert into t1 values( 223 ) master-bin.000001 16472 Query 1 16563 use `test`; insert into t1 values( 222 ) master-bin.000001 16563 Query 1 16654 use `test`; insert into t1 values( 221 ) master-bin.000001 16654 Query 1 16745 use `test`; insert into t1 values( 220 ) master-bin.000001 16745 Query 1 16836 use `test`; insert into t1 values( 219 ) master-bin.000001 16836 Query 1 16927 use `test`; insert into t1 values( 218 ) master-bin.000001 16927 Query 1 17018 use `test`; insert into t1 values( 217 ) master-bin.000001 17018 Query 1 17109 use `test`; insert into t1 values( 216 ) master-bin.000001 17109 Query 1 17200 use `test`; insert into t1 values( 215 ) master-bin.000001 17200 Query 1 17291 use `test`; insert into t1 values( 214 ) master-bin.000001 17291 Query 1 17382 use `test`; insert into t1 values( 213 ) master-bin.000001 17382 Query 1 17473 use `test`; insert into t1 values( 212 ) master-bin.000001 17473 Query 1 17564 use `test`; insert into t1 values( 211 ) master-bin.000001 17564 Query 1 17655 use `test`; insert into t1 values( 210 ) master-bin.000001 17655 Query 1 17746 use `test`; insert into t1 values( 209 ) master-bin.000001 17746 Query 1 17837 use `test`; insert into t1 values( 208 ) master-bin.000001 17837 Query 1 17928 use `test`; insert into t1 values( 207 ) master-bin.000001 17928 Query 1 18019 use `test`; insert into t1 values( 206 ) master-bin.000001 18019 Query 1 18110 use `test`; insert into t1 values( 205 ) master-bin.000001 18110 Query 1 18201 use `test`; insert into t1 values( 204 ) master-bin.000001 18201 Query 1 18292 use `test`; insert into t1 values( 203 ) master-bin.000001 18292 Query 1 18383 use `test`; insert into t1 values( 202 ) master-bin.000001 18383 Query 1 18474 use `test`; insert into t1 values( 201 ) master-bin.000001 18474 Query 1 18565 use `test`; insert into t1 values( 200 ) master-bin.000001 18565 Query 1 18656 use `test`; insert into t1 values( 199 ) master-bin.000001 18656 Query 1 18747 use `test`; insert into t1 values( 198 ) master-bin.000001 18747 Query 1 18838 use `test`; insert into t1 values( 197 ) master-bin.000001 18838 Query 1 18929 use `test`; insert into t1 values( 196 ) master-bin.000001 18929 Query 1 19020 use `test`; insert into t1 values( 195 ) master-bin.000001 19020 Query 1 19111 use `test`; insert into t1 values( 194 ) master-bin.000001 19111 Query 1 19202 use `test`; insert into t1 values( 193 ) master-bin.000001 19202 Query 1 19293 use `test`; insert into t1 values( 192 ) master-bin.000001 19293 Query 1 19384 use `test`; insert into t1 values( 191 ) master-bin.000001 19384 Query 1 19475 use `test`; insert into t1 values( 190 ) master-bin.000001 19475 Query 1 19566 use `test`; insert into t1 values( 189 ) master-bin.000001 19566 Query 1 19657 use `test`; insert into t1 values( 188 ) master-bin.000001 19657 Query 1 19748 use `test`; insert into t1 values( 187 ) master-bin.000001 19748 Query 1 19839 use `test`; insert into t1 values( 186 ) master-bin.000001 19839 Query 1 19930 use `test`; insert into t1 values( 185 ) master-bin.000001 19930 Query 1 20021 use `test`; insert into t1 values( 184 ) master-bin.000001 20021 Query 1 20112 use `test`; insert into t1 values( 183 ) master-bin.000001 20112 Query 1 20203 use `test`; insert into t1 values( 182 ) master-bin.000001 20203 Query 1 20294 use `test`; insert into t1 values( 181 ) master-bin.000001 20294 Query 1 20385 use `test`; insert into t1 values( 180 ) master-bin.000001 20385 Query 1 20476 use `test`; insert into t1 values( 179 ) master-bin.000001 20476 Query 1 20567 use `test`; insert into t1 values( 178 ) master-bin.000001 20567 Query 1 20658 use `test`; insert into t1 values( 177 ) master-bin.000001 20658 Query 1 20749 use `test`; insert into t1 values( 176 ) master-bin.000001 20749 Query 1 20840 use `test`; insert into t1 values( 175 ) master-bin.000001 20840 Query 1 20931 use `test`; insert into t1 values( 174 ) master-bin.000001 20931 Query 1 21022 use `test`; insert into t1 values( 173 ) master-bin.000001 21022 Query 1 21113 use `test`; insert into t1 values( 172 ) master-bin.000001 21113 Query 1 21204 use `test`; insert into t1 values( 171 ) master-bin.000001 21204 Query 1 21295 use `test`; insert into t1 values( 170 ) master-bin.000001 21295 Query 1 21386 use `test`; insert into t1 values( 169 ) master-bin.000001 21386 Query 1 21477 use `test`; insert into t1 values( 168 ) master-bin.000001 21477 Query 1 21568 use `test`; insert into t1 values( 167 ) master-bin.000001 21568 Query 1 21659 use `test`; insert into t1 values( 166 ) master-bin.000001 21659 Query 1 21750 use `test`; insert into t1 values( 165 ) master-bin.000001 21750 Query 1 21841 use `test`; insert into t1 values( 164 ) master-bin.000001 21841 Query 1 21932 use `test`; insert into t1 values( 163 ) master-bin.000001 21932 Query 1 22023 use `test`; insert into t1 values( 162 ) master-bin.000001 22023 Query 1 22114 use `test`; insert into t1 values( 161 ) master-bin.000001 22114 Query 1 22205 use `test`; insert into t1 values( 160 ) master-bin.000001 22205 Query 1 22296 use `test`; insert into t1 values( 159 ) master-bin.000001 22296 Query 1 22387 use `test`; insert into t1 values( 158 ) master-bin.000001 22387 Query 1 22478 use `test`; insert into t1 values( 157 ) master-bin.000001 22478 Query 1 22569 use `test`; insert into t1 values( 156 ) master-bin.000001 22569 Query 1 22660 use `test`; insert into t1 values( 155 ) master-bin.000001 22660 Query 1 22751 use `test`; insert into t1 values( 154 ) master-bin.000001 22751 Query 1 22842 use `test`; insert into t1 values( 153 ) master-bin.000001 22842 Query 1 22933 use `test`; insert into t1 values( 152 ) master-bin.000001 22933 Query 1 23024 use `test`; insert into t1 values( 151 ) master-bin.000001 23024 Query 1 23115 use `test`; insert into t1 values( 150 ) master-bin.000001 23115 Query 1 23206 use `test`; insert into t1 values( 149 ) master-bin.000001 23206 Query 1 23297 use `test`; insert into t1 values( 148 ) master-bin.000001 23297 Query 1 23388 use `test`; insert into t1 values( 147 ) master-bin.000001 23388 Query 1 23479 use `test`; insert into t1 values( 146 ) master-bin.000001 23479 Query 1 23570 use `test`; insert into t1 values( 145 ) master-bin.000001 23570 Query 1 23661 use `test`; insert into t1 values( 144 ) master-bin.000001 23661 Query 1 23752 use `test`; insert into t1 values( 143 ) master-bin.000001 23752 Query 1 23843 use `test`; insert into t1 values( 142 ) master-bin.000001 23843 Query 1 23934 use `test`; insert into t1 values( 141 ) master-bin.000001 23934 Query 1 24025 use `test`; insert into t1 values( 140 ) master-bin.000001 24025 Query 1 24116 use `test`; insert into t1 values( 139 ) master-bin.000001 24116 Query 1 24207 use `test`; insert into t1 values( 138 ) master-bin.000001 24207 Query 1 24298 use `test`; insert into t1 values( 137 ) master-bin.000001 24298 Query 1 24389 use `test`; insert into t1 values( 136 ) master-bin.000001 24389 Query 1 24480 use `test`; insert into t1 values( 135 ) master-bin.000001 24480 Query 1 24571 use `test`; insert into t1 values( 134 ) master-bin.000001 24571 Query 1 24662 use `test`; insert into t1 values( 133 ) master-bin.000001 24662 Query 1 24753 use `test`; insert into t1 values( 132 ) master-bin.000001 24753 Query 1 24844 use `test`; insert into t1 values( 131 ) master-bin.000001 24844 Query 1 24935 use `test`; insert into t1 values( 130 ) master-bin.000001 24935 Query 1 25026 use `test`; insert into t1 values( 129 ) master-bin.000001 25026 Query 1 25117 use `test`; insert into t1 values( 128 ) master-bin.000001 25117 Query 1 25208 use `test`; insert into t1 values( 127 ) master-bin.000001 25208 Query 1 25299 use `test`; insert into t1 values( 126 ) master-bin.000001 25299 Query 1 25390 use `test`; insert into t1 values( 125 ) master-bin.000001 25390 Query 1 25481 use `test`; insert into t1 values( 124 ) master-bin.000001 25481 Query 1 25572 use `test`; insert into t1 values( 123 ) master-bin.000001 25572 Query 1 25663 use `test`; insert into t1 values( 122 ) master-bin.000001 25663 Query 1 25754 use `test`; insert into t1 values( 121 ) master-bin.000001 25754 Query 1 25845 use `test`; insert into t1 values( 120 ) master-bin.000001 25845 Query 1 25936 use `test`; insert into t1 values( 119 ) master-bin.000001 25936 Query 1 26027 use `test`; insert into t1 values( 118 ) master-bin.000001 26027 Query 1 26118 use `test`; insert into t1 values( 117 ) master-bin.000001 26118 Query 1 26209 use `test`; insert into t1 values( 116 ) master-bin.000001 26209 Query 1 26300 use `test`; insert into t1 values( 115 ) master-bin.000001 26300 Query 1 26391 use `test`; insert into t1 values( 114 ) master-bin.000001 26391 Query 1 26482 use `test`; insert into t1 values( 113 ) master-bin.000001 26482 Query 1 26573 use `test`; insert into t1 values( 112 ) master-bin.000001 26573 Query 1 26664 use `test`; insert into t1 values( 111 ) master-bin.000001 26664 Query 1 26755 use `test`; insert into t1 values( 110 ) master-bin.000001 26755 Query 1 26846 use `test`; insert into t1 values( 109 ) master-bin.000001 26846 Query 1 26937 use `test`; insert into t1 values( 108 ) master-bin.000001 26937 Query 1 27028 use `test`; insert into t1 values( 107 ) master-bin.000001 27028 Query 1 27119 use `test`; insert into t1 values( 106 ) master-bin.000001 27119 Query 1 27210 use `test`; insert into t1 values( 105 ) master-bin.000001 27210 Query 1 27301 use `test`; insert into t1 values( 104 ) master-bin.000001 27301 Query 1 27392 use `test`; insert into t1 values( 103 ) master-bin.000001 27392 Query 1 27483 use `test`; insert into t1 values( 102 ) master-bin.000001 27483 Query 1 27574 use `test`; insert into t1 values( 101 ) master-bin.000001 27574 Query 1 27665 use `test`; insert into t1 values( 100 ) master-bin.000001 27665 Query 1 27755 use `test`; insert into t1 values( 99 ) master-bin.000001 27755 Query 1 27845 use `test`; insert into t1 values( 98 ) master-bin.000001 27845 Query 1 27935 use `test`; insert into t1 values( 97 ) master-bin.000001 27935 Query 1 28025 use `test`; insert into t1 values( 96 ) master-bin.000001 28025 Query 1 28115 use `test`; insert into t1 values( 95 ) master-bin.000001 28115 Query 1 28205 use `test`; insert into t1 values( 94 ) master-bin.000001 28205 Query 1 28295 use `test`; insert into t1 values( 93 ) master-bin.000001 28295 Query 1 28385 use `test`; insert into t1 values( 92 ) master-bin.000001 28385 Query 1 28475 use `test`; insert into t1 values( 91 ) master-bin.000001 28475 Query 1 28565 use `test`; insert into t1 values( 90 ) master-bin.000001 28565 Query 1 28655 use `test`; insert into t1 values( 89 ) master-bin.000001 28655 Query 1 28745 use `test`; insert into t1 values( 88 ) master-bin.000001 28745 Query 1 28835 use `test`; insert into t1 values( 87 ) master-bin.000001 28835 Query 1 28925 use `test`; insert into t1 values( 86 ) master-bin.000001 28925 Query 1 29015 use `test`; insert into t1 values( 85 ) master-bin.000001 29015 Query 1 29105 use `test`; insert into t1 values( 84 ) master-bin.000001 29105 Query 1 29195 use `test`; insert into t1 values( 83 ) master-bin.000001 29195 Query 1 29285 use `test`; insert into t1 values( 82 ) master-bin.000001 29285 Query 1 29375 use `test`; insert into t1 values( 81 ) master-bin.000001 29375 Query 1 29465 use `test`; insert into t1 values( 80 ) master-bin.000001 29465 Query 1 29555 use `test`; insert into t1 values( 79 ) master-bin.000001 29555 Query 1 29645 use `test`; insert into t1 values( 78 ) master-bin.000001 29645 Query 1 29735 use `test`; insert into t1 values( 77 ) master-bin.000001 29735 Query 1 29825 use `test`; insert into t1 values( 76 ) master-bin.000001 29825 Query 1 29915 use `test`; insert into t1 values( 75 ) master-bin.000001 29915 Query 1 30005 use `test`; insert into t1 values( 74 ) master-bin.000001 30005 Query 1 30095 use `test`; insert into t1 values( 73 ) master-bin.000001 30095 Query 1 30185 use `test`; insert into t1 values( 72 ) master-bin.000001 30185 Query 1 30275 use `test`; insert into t1 values( 71 ) master-bin.000001 30275 Query 1 30365 use `test`; insert into t1 values( 70 ) master-bin.000001 30365 Query 1 30455 use `test`; insert into t1 values( 69 ) master-bin.000001 30455 Query 1 30545 use `test`; insert into t1 values( 68 ) master-bin.000001 30545 Query 1 30635 use `test`; insert into t1 values( 67 ) master-bin.000001 30635 Query 1 30725 use `test`; insert into t1 values( 66 ) master-bin.000001 30725 Query 1 30815 use `test`; insert into t1 values( 65 ) master-bin.000001 30815 Query 1 30905 use `test`; insert into t1 values( 64 ) master-bin.000001 30905 Query 1 30995 use `test`; insert into t1 values( 63 ) master-bin.000001 30995 Query 1 31085 use `test`; insert into t1 values( 62 ) master-bin.000001 31085 Query 1 31175 use `test`; insert into t1 values( 61 ) master-bin.000001 31175 Query 1 31265 use `test`; insert into t1 values( 60 ) master-bin.000001 31265 Query 1 31355 use `test`; insert into t1 values( 59 ) master-bin.000001 31355 Query 1 31445 use `test`; insert into t1 values( 58 ) master-bin.000001 31445 Query 1 31535 use `test`; insert into t1 values( 57 ) master-bin.000001 31535 Query 1 31625 use `test`; insert into t1 values( 56 ) master-bin.000001 31625 Query 1 31715 use `test`; insert into t1 values( 55 ) master-bin.000001 31715 Query 1 31805 use `test`; insert into t1 values( 54 ) master-bin.000001 31805 Query 1 31895 use `test`; insert into t1 values( 53 ) master-bin.000001 31895 Query 1 31985 use `test`; insert into t1 values( 52 ) master-bin.000001 31985 Query 1 32075 use `test`; insert into t1 values( 51 ) master-bin.000001 32075 Query 1 32165 use `test`; insert into t1 values( 50 ) master-bin.000001 32165 Query 1 32255 use `test`; insert into t1 values( 49 ) master-bin.000001 32255 Query 1 32345 use `test`; insert into t1 values( 48 ) master-bin.000001 32345 Query 1 32435 use `test`; insert into t1 values( 47 ) master-bin.000001 32435 Query 1 32525 use `test`; insert into t1 values( 46 ) master-bin.000001 32525 Query 1 32615 use `test`; insert into t1 values( 45 ) master-bin.000001 32615 Query 1 32705 use `test`; insert into t1 values( 44 ) master-bin.000001 32705 Query 1 32795 use `test`; insert into t1 values( 43 ) master-bin.000001 32795 Query 1 32885 use `test`; insert into t1 values( 42 ) master-bin.000001 32885 Query 1 32975 use `test`; insert into t1 values( 41 ) master-bin.000001 32975 Query 1 33065 use `test`; insert into t1 values( 40 ) master-bin.000001 33065 Query 1 33155 use `test`; insert into t1 values( 39 ) master-bin.000001 33155 Query 1 33245 use `test`; insert into t1 values( 38 ) master-bin.000001 33245 Query 1 33335 use `test`; insert into t1 values( 37 ) master-bin.000001 33335 Query 1 33425 use `test`; insert into t1 values( 36 ) master-bin.000001 33425 Query 1 33515 use `test`; insert into t1 values( 35 ) master-bin.000001 33515 Query 1 33605 use `test`; insert into t1 values( 34 ) master-bin.000001 33605 Query 1 33695 use `test`; insert into t1 values( 33 ) master-bin.000001 33695 Query 1 33785 use `test`; insert into t1 values( 32 ) master-bin.000001 33785 Query 1 33875 use `test`; insert into t1 values( 31 ) master-bin.000001 33875 Query 1 33965 use `test`; insert into t1 values( 30 ) master-bin.000001 33965 Query 1 34055 use `test`; insert into t1 values( 29 ) master-bin.000001 34055 Query 1 34145 use `test`; insert into t1 values( 28 ) master-bin.000001 34145 Query 1 34235 use `test`; insert into t1 values( 27 ) master-bin.000001 34235 Query 1 34325 use `test`; insert into t1 values( 26 ) master-bin.000001 34325 Query 1 34415 use `test`; insert into t1 values( 25 ) master-bin.000001 34415 Query 1 34505 use `test`; insert into t1 values( 24 ) master-bin.000001 34505 Query 1 34595 use `test`; insert into t1 values( 23 ) master-bin.000001 34595 Query 1 34685 use `test`; insert into t1 values( 22 ) master-bin.000001 34685 Query 1 34775 use `test`; insert into t1 values( 21 ) master-bin.000001 34775 Query 1 34865 use `test`; insert into t1 values( 20 ) master-bin.000001 34865 Query 1 34955 use `test`; insert into t1 values( 19 ) master-bin.000001 34955 Query 1 35045 use `test`; insert into t1 values( 18 ) master-bin.000001 35045 Query 1 35135 use `test`; insert into t1 values( 17 ) master-bin.000001 35135 Query 1 35225 use `test`; insert into t1 values( 16 ) master-bin.000001 35225 Query 1 35315 use `test`; insert into t1 values( 15 ) master-bin.000001 35315 Query 1 35405 use `test`; insert into t1 values( 14 ) master-bin.000001 35405 Query 1 35495 use `test`; insert into t1 values( 13 ) master-bin.000001 35495 Query 1 35585 use `test`; insert into t1 values( 12 ) master-bin.000001 35585 Query 1 35675 use `test`; insert into t1 values( 11 ) master-bin.000001 35675 Query 1 35765 use `test`; insert into t1 values( 10 ) master-bin.000001 35765 Query 1 35854 use `test`; insert into t1 values( 9 ) master-bin.000001 35854 Query 1 35943 use `test`; insert into t1 values( 8 ) master-bin.000001 35943 Query 1 36032 use `test`; insert into t1 values( 7 ) master-bin.000001 36032 Query 1 36121 use `test`; insert into t1 values( 6 ) master-bin.000001 36121 Query 1 36210 use `test`; insert into t1 values( 5 ) master-bin.000001 36210 Query 1 36299 use `test`; insert into t1 values( 4 ) master-bin.000001 36299 Query 1 36388 use `test`; insert into t1 values( 3 ) master-bin.000001 36388 Query 1 36477 use `test`; insert into t1 values( 2 ) master-bin.000001 36477 Query 1 36566 use `test`; insert into t1 values( 1 ) master-bin.000001 36566 Xid 1 36593 COMMIT /* XID */ master-bin.000001 36593 Rotate 1 36637 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 106 Server version, Binlog ver: 4 master-bin.000001 106 Query 1 227 use `test`; create table t1 (a bigint unsigned, b bigint(20) unsigned) master-bin.000001 227 Query 1 351 use `test`; insert into t1 values (9999999999999999,14632475938453979136) master-bin.000001 351 Query 1 427 use `test`; drop table t1 reset master; CREATE DATABASE bug39182 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; USE bug39182; CREATE TABLE t1 (a VARCHAR(255) COLLATE utf8_unicode_ci) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; CREATE PROCEDURE p1() BEGIN DECLARE s1 VARCHAR(255); SET s1= "test"; CREATE TEMPORARY TABLE tmp1 SELECT * FROM t1 WHERE a LIKE CONCAT("%", s1, "%"); SELECT COLLATION(NAME_CONST('s1', _utf8'test')) c1, COLLATION(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) c2, COLLATION(s1) c3, COERCIBILITY(NAME_CONST('s1', _utf8'test')) d1, COERCIBILITY(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) d2, COERCIBILITY(s1) d3; DROP TEMPORARY TABLE tmp1; END// CALL p1(); c1 c2 c3 d1 d2 d3 utf8_general_ci utf8_unicode_ci utf8_unicode_ci 2 2 2 show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # CREATE DATABASE bug39182 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci master-bin.000001 # Query # # use `bug39182`; CREATE TABLE t1 (a VARCHAR(255) COLLATE utf8_unicode_ci) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci master-bin.000001 # Query # # use `bug39182`; CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`() BEGIN DECLARE s1 VARCHAR(255); SET s1= "test"; CREATE TEMPORARY TABLE tmp1 SELECT * FROM t1 WHERE a LIKE CONCAT("%", s1, "%"); SELECT COLLATION(NAME_CONST('s1', _utf8'test')) c1, COLLATION(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) c2, COLLATION(s1) c3, COERCIBILITY(NAME_CONST('s1', _utf8'test')) d1, COERCIBILITY(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) d2, COERCIBILITY(s1) d3; DROP TEMPORARY TABLE tmp1; END master-bin.000001 # Query # # use `bug39182`; CREATE TEMPORARY TABLE tmp1 SELECT * FROM t1 WHERE a LIKE CONCAT("%", NAME_CONST('s1',_utf8'test' COLLATE 'utf8_unicode_ci'), "%") master-bin.000001 # Query # # use `bug39182`; DROP TEMPORARY TABLE tmp1 DROP PROCEDURE p1; DROP TABLE t1; DROP DATABASE bug39182; USE test; 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 # Intvar # # INSERT_ID=127 master-bin.000001 # Query # # use `test`; insert into t1 values(null) 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`; create table if not exists t2 select * from t1 master-bin.000001 # Query # # use `test`; create temporary table tt1 (a int) master-bin.000001 # Query # # use `test`; create table if not exists t3 like tt1 master-bin.000001 # Query # # use `mysql`; INSERT INTO user SET host='localhost', user='@#@', password=password('Just a test') master-bin.000001 # Query # # use `mysql`; UPDATE user SET password=password('Another password') WHERE host='localhost' AND user='@#@' master-bin.000001 # Query # # use `mysql`; DELETE FROM user WHERE host='localhost' AND user='@#@' drop table t1,t2,t3,tt1; create table t1 (a int not null auto_increment, primary key (a)) engine=myisam; insert delayed into t1 values (207); insert delayed into t1 values (null); insert delayed into t1 values (300); FLUSH TABLES; 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 # Intvar # # INSERT_ID=127 master-bin.000001 # Query # # use `test`; insert into t1 values(null) 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`; create table if not exists t2 select * from t1 master-bin.000001 # Query # # use `test`; create temporary table tt1 (a int) master-bin.000001 # Query # # use `test`; create table if not exists t3 like tt1 master-bin.000001 # Query # # use `mysql`; INSERT INTO user SET host='localhost', user='@#@', password=password('Just a test') master-bin.000001 # Query # # use `mysql`; UPDATE user SET password=password('Another password') WHERE host='localhost' AND user='@#@' master-bin.000001 # Query # # use `mysql`; DELETE FROM user WHERE host='localhost' AND user='@#@' master-bin.000001 # Query # # use `test`; drop table t1,t2,t3,tt1 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 master-bin.000001 # Query # # use `test`; FLUSH TABLES insert delayed into t1 values (null),(null),(null),(null); insert delayed into t1 values (null),(null),(400),(null); 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 346 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 106 drop table t3;