411
411
set @a:= mysqltest2.f1();
412
show binlog events in 'master-bin.000001' from 106;
412
show binlog events from <binlog_start>;
413
413
Log_name Pos Event_type Server_id End_log_pos Info
414
master-bin.000001 # Query 1 # drop database if exists mysqltest1
415
master-bin.000001 # Query 1 # create database mysqltest1
416
master-bin.000001 # Query 1 # use `mysqltest1`; create table t1 (a varchar(100))
417
master-bin.000001 # Query 1 # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `foo`()
414
master-bin.000001 # Query # # drop database if exists mysqltest1
415
master-bin.000001 # Query # # create database mysqltest1
416
master-bin.000001 # Query # # use `mysqltest1`; create table t1 (a varchar(100))
417
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `foo`()
421
421
insert into t1 values (b);
422
422
insert into t1 values (unix_timestamp());
424
master-bin.000001 # Query 1 # use `mysqltest1`; insert into t1 values ( NAME_CONST('b',8))
425
master-bin.000001 # Query 1 # use `mysqltest1`; insert into t1 values (unix_timestamp())
426
master-bin.000001 # Query 1 # use `mysqltest1`; delete from t1
427
master-bin.000001 # Query 1 # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `foo2`()
424
master-bin.000001 # Query # # use `mysqltest1`; insert into t1 values ( NAME_CONST('b',8))
425
master-bin.000001 # Query # # use `mysqltest1`; insert into t1 values (unix_timestamp())
426
master-bin.000001 # Query # # use `mysqltest1`; delete from t1
427
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `foo2`()
428
428
select * from mysqltest1.t1
429
master-bin.000001 # Query 1 # use `mysqltest1`; alter procedure foo2 contains sql
430
master-bin.000001 # Query 1 # use `mysqltest1`; drop table t1
431
master-bin.000001 # Query 1 # use `mysqltest1`; create table t1 (a int)
432
master-bin.000001 # Query 1 # use `mysqltest1`; create table t2 like t1
433
master-bin.000001 # Query 1 # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `foo3`()
429
master-bin.000001 # Query # # use `mysqltest1`; alter procedure foo2 contains sql
430
master-bin.000001 # Query # # use `mysqltest1`; drop table t1
431
master-bin.000001 # Query # # use `mysqltest1`; create table t1 (a int)
432
master-bin.000001 # Query # # use `mysqltest1`; create table t2 like t1
433
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `foo3`()
435
435
insert into t1 values (15)
436
master-bin.000001 # Query 1 # use `mysqltest1`; grant CREATE ROUTINE, EXECUTE on mysqltest1.* to "zedjzlcsjhd"@127.0.0.1
437
master-bin.000001 # Query 1 # use `mysqltest1`; grant SELECT on mysqltest1.t1 to "zedjzlcsjhd"@127.0.0.1
438
master-bin.000001 # Query 1 # use `mysqltest1`; grant SELECT, INSERT on mysqltest1.t2 to "zedjzlcsjhd"@127.0.0.1
439
master-bin.000001 # Query 1 # use `mysqltest1`; CREATE DEFINER=`zedjzlcsjhd`@`127.0.0.1` PROCEDURE `foo4`()
436
master-bin.000001 # Query # # use `mysqltest1`; grant CREATE ROUTINE, EXECUTE on mysqltest1.* to "zedjzlcsjhd"@127.0.0.1
437
master-bin.000001 # Query # # use `mysqltest1`; grant SELECT on mysqltest1.t1 to "zedjzlcsjhd"@127.0.0.1
438
master-bin.000001 # Query # # use `mysqltest1`; grant SELECT, INSERT on mysqltest1.t2 to "zedjzlcsjhd"@127.0.0.1
439
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`zedjzlcsjhd`@`127.0.0.1` PROCEDURE `foo4`()
442
442
insert into t2 values(3);
443
443
insert into t1 values (5);
445
master-bin.000001 # Query 1 # use `mysqltest1`; insert into t2 values(3)
446
master-bin.000001 # Query 1 # use `mysqltest1`; insert into t1 values (15)
447
master-bin.000001 # Query 1 # use `mysqltest1`; insert into t2 values(3)
448
master-bin.000001 # Query 1 # use `mysqltest1`; alter procedure foo4 sql security invoker
449
master-bin.000001 # Query 1 # use `mysqltest1`; insert into t2 values(3)
450
master-bin.000001 # Query 1 # use `mysqltest1`; insert into t1 values (5)
451
master-bin.000001 # Query 1 # use `mysqltest1`; delete from t2
452
master-bin.000001 # Query 1 # use `mysqltest1`; alter table t2 add unique (a)
453
master-bin.000001 # Query 1 # use `mysqltest1`; drop procedure foo4
454
master-bin.000001 # Query 1 # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `foo4`()
445
master-bin.000001 # Query # # use `mysqltest1`; insert into t2 values(3)
446
master-bin.000001 # Query # # use `mysqltest1`; insert into t1 values (15)
447
master-bin.000001 # Query # # use `mysqltest1`; insert into t2 values(3)
448
master-bin.000001 # Query # # use `mysqltest1`; alter procedure foo4 sql security invoker
449
master-bin.000001 # Query # # use `mysqltest1`; insert into t2 values(3)
450
master-bin.000001 # Query # # use `mysqltest1`; insert into t1 values (5)
451
master-bin.000001 # Query # # use `mysqltest1`; delete from t2
452
master-bin.000001 # Query # # use `mysqltest1`; alter table t2 add unique (a)
453
master-bin.000001 # Query # # use `mysqltest1`; drop procedure foo4
454
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `foo4`()
457
457
insert into t2 values(20),(20);
459
master-bin.000001 # Query 1 # use `mysqltest1`; insert into t2 values(20),(20)
460
master-bin.000001 # Query 1 # use `mysqltest1`; drop procedure foo4
461
master-bin.000001 # Query 1 # use `mysqltest1`; drop procedure foo
462
master-bin.000001 # Query 1 # use `mysqltest1`; drop procedure foo2
463
master-bin.000001 # Query 1 # use `mysqltest1`; drop procedure foo3
464
master-bin.000001 # Query 1 # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`(x int) RETURNS int(11)
459
master-bin.000001 # Query # # use `mysqltest1`; insert into t2 values(20),(20)
460
master-bin.000001 # Query # # use `mysqltest1`; drop procedure foo4
461
master-bin.000001 # Query # # use `mysqltest1`; drop procedure foo
462
master-bin.000001 # Query # # use `mysqltest1`; drop procedure foo2
463
master-bin.000001 # Query # # use `mysqltest1`; drop procedure foo3
464
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`(x int) RETURNS int(11)
467
467
insert into t1 values (x);
470
master-bin.000001 # Query 1 # use `mysqltest1`; delete t1,t2 from t1,t2
471
master-bin.000001 # Query 1 # use `mysqltest1`; SELECT `mysqltest1`.`fn1`(20)
472
master-bin.000001 # Query 1 # use `mysqltest1`; insert into t2 values(fn1(21))
473
master-bin.000001 # Query 1 # use `mysqltest1`; drop function fn1
474
master-bin.000001 # Query 1 # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`() RETURNS int(11)
477
return unix_timestamp();
479
master-bin.000001 # Query 1 # use `mysqltest1`; delete from t1
480
master-bin.000001 # Query 1 # use `mysqltest1`; insert into t1 values(fn1())
481
master-bin.000001 # Query 1 # use `mysqltest1`; CREATE DEFINER=`zedjzlcsjhd`@`127.0.0.1` FUNCTION `fn2`() RETURNS int(11)
484
return unix_timestamp();
486
master-bin.000001 # Query 1 # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` FUNCTION `fn3`() RETURNS int(11)
470
master-bin.000001 # Query # # use `mysqltest1`; delete t1,t2 from t1,t2
471
master-bin.000001 # Query # # use `mysqltest1`; SELECT `mysqltest1`.`fn1`(20)
472
master-bin.000001 # Query # # use `mysqltest1`; insert into t2 values(fn1(21))
473
master-bin.000001 # Query # # use `mysqltest1`; drop function fn1
474
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`() RETURNS int(11)
477
return unix_timestamp();
479
master-bin.000001 # Query # # use `mysqltest1`; delete from t1
480
master-bin.000001 # Query # # use `mysqltest1`; insert into t1 values(fn1())
481
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`zedjzlcsjhd`@`127.0.0.1` FUNCTION `fn2`() RETURNS int(11)
484
return unix_timestamp();
486
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` FUNCTION `fn3`() RETURNS int(11)
491
master-bin.000001 # Query 1 # use `mysqltest1`; delete from t2
492
master-bin.000001 # Query 1 # use `mysqltest1`; alter table t2 add unique (a)
493
master-bin.000001 # Query 1 # use `mysqltest1`; drop function fn1
494
master-bin.000001 # Query 1 # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`(x int) RETURNS int(11)
491
master-bin.000001 # Query # # use `mysqltest1`; delete from t2
492
master-bin.000001 # Query # # use `mysqltest1`; alter table t2 add unique (a)
493
master-bin.000001 # Query # # use `mysqltest1`; drop function fn1
494
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`(x int) RETURNS int(11)
496
496
insert into t2 values(x),(x);
499
master-bin.000001 # Query 1 # use `mysqltest1`; SELECT `mysqltest1`.`fn1`(100)
500
master-bin.000001 # Query 1 # use `mysqltest1`; SELECT `mysqltest1`.`fn1`(20)
501
master-bin.000001 # Query 1 # use `mysqltest1`; delete from t1
502
master-bin.000001 # Query 1 # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` trigger trg before insert on t1 for each row set new.a= 10
503
master-bin.000001 # Query 1 # use `mysqltest1`; insert into t1 values (1)
504
master-bin.000001 # Query 1 # use `mysqltest1`; delete from t1
505
master-bin.000001 # Query 1 # use `mysqltest1`; drop trigger trg
506
master-bin.000001 # Query 1 # use `mysqltest1`; insert into t1 values (1)
507
master-bin.000001 # Query 1 # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `foo`()
499
master-bin.000001 # Query # # use `mysqltest1`; SELECT `mysqltest1`.`fn1`(100)
500
master-bin.000001 # Query # # use `mysqltest1`; SELECT `mysqltest1`.`fn1`(20)
501
master-bin.000001 # Query # # use `mysqltest1`; delete from t1
502
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` trigger trg before insert on t1 for each row set new.a= 10
503
master-bin.000001 # Query # # use `mysqltest1`; insert into t1 values (1)
504
master-bin.000001 # Query # # use `mysqltest1`; delete from t1
505
master-bin.000001 # Query # # use `mysqltest1`; drop trigger trg
506
master-bin.000001 # Query # # use `mysqltest1`; insert into t1 values (1)
507
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `foo`()
510
master-bin.000001 # Query 1 # use `mysqltest1`; drop procedure foo
511
master-bin.000001 # Query 1 # use `mysqltest1`; drop function fn1
512
master-bin.000001 # Query 1 # drop database mysqltest1
513
master-bin.000001 # Query 1 # drop user "zedjzlcsjhd"@127.0.0.1
514
master-bin.000001 # Query 1 # use `test`; drop function if exists f1
515
master-bin.000001 # Query 1 # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
510
master-bin.000001 # Query # # use `mysqltest1`; drop procedure foo
511
master-bin.000001 # Query # # use `mysqltest1`; drop function fn1
512
master-bin.000001 # Query # # drop database mysqltest1
513
master-bin.000001 # Query # # drop user "zedjzlcsjhd"@127.0.0.1
514
master-bin.000001 # Query # # use `test`; drop function if exists f1
515
master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
518
518
declare var integer;
525
master-bin.000001 # Query 1 # use `test`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select 1 as a
526
master-bin.000001 # Query 1 # use `test`; create table t1 (a int)
527
master-bin.000001 # Query 1 # use `test`; insert into t1 (a) values (f1())
528
master-bin.000001 # Query 1 # use `test`; drop view v1
529
master-bin.000001 # Query 1 # use `test`; drop function f1
530
master-bin.000001 # Query 1 # use `test`; DROP PROCEDURE IF EXISTS p1
531
master-bin.000001 # Query 1 # use `test`; DROP TABLE IF EXISTS t1
532
master-bin.000001 # Query 1 # use `test`; CREATE TABLE t1(col VARCHAR(10))
533
master-bin.000001 # Query 1 # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`(arg VARCHAR(10))
525
master-bin.000001 # Query # # use `test`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select 1 as a
526
master-bin.000001 # Query # # use `test`; create table t1 (a int)
527
master-bin.000001 # Query # # use `test`; insert into t1 (a) values (f1())
528
master-bin.000001 # Query # # use `test`; drop view v1
529
master-bin.000001 # Query # # use `test`; drop function f1
530
master-bin.000001 # Query # # use `test`; DROP PROCEDURE IF EXISTS p1
531
master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS t1
532
master-bin.000001 # Query # # use `test`; CREATE TABLE t1(col VARCHAR(10))
533
master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`(arg VARCHAR(10))
534
534
INSERT INTO t1 VALUES(arg)
535
master-bin.000001 # Query 1 # use `test`; INSERT INTO t1 VALUES( NAME_CONST('arg',_latin1'test' COLLATE 'latin1_swedish_ci'))
536
master-bin.000001 # Query 1 # use `test`; DROP PROCEDURE p1
537
master-bin.000001 # Query 1 # use `test`; DROP PROCEDURE IF EXISTS p1
538
master-bin.000001 # Query 1 # use `test`; DROP FUNCTION IF EXISTS f1
539
master-bin.000001 # Query 1 # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
535
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES( NAME_CONST('arg',_latin1'test' COLLATE 'latin1_swedish_ci'))
536
master-bin.000001 # Query # # use `test`; DROP PROCEDURE p1
537
master-bin.000001 # Query # # use `test`; DROP PROCEDURE IF EXISTS p1
538
master-bin.000001 # Query # # use `test`; DROP FUNCTION IF EXISTS f1
539
master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
541
master-bin.000001 # Query 1 # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
541
master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
543
master-bin.000001 # Query 1 # use `test`; DROP PROCEDURE p1
544
master-bin.000001 # Query 1 # use `test`; DROP FUNCTION f1
545
master-bin.000001 # Query 1 # use `test`; drop table t1
546
master-bin.000001 # Query 1 # drop database if exists mysqltest
547
master-bin.000001 # Query 1 # drop database if exists mysqltest2
548
master-bin.000001 # Query 1 # create database mysqltest
549
master-bin.000001 # Query 1 # create database mysqltest2
550
master-bin.000001 # Query 1 # use `mysqltest2`; create table t ( t integer )
551
master-bin.000001 # Query 1 # use `mysqltest2`; CREATE DEFINER=`root`@`localhost` PROCEDURE `mysqltest`.`test`()
543
master-bin.000001 # Query # # use `test`; DROP PROCEDURE p1
544
master-bin.000001 # Query # # use `test`; DROP FUNCTION f1
545
master-bin.000001 # Query # # use `test`; drop table t1
546
master-bin.000001 # Query # # drop database if exists mysqltest
547
master-bin.000001 # Query # # drop database if exists mysqltest2
548
master-bin.000001 # Query # # create database mysqltest
549
master-bin.000001 # Query # # create database mysqltest2
550
master-bin.000001 # Query # # use `mysqltest2`; create table t ( t integer )
551
master-bin.000001 # Query # # use `mysqltest2`; CREATE DEFINER=`root`@`localhost` PROCEDURE `mysqltest`.`test`()
553
master-bin.000001 # Query 1 # use `mysqltest2`; insert into t values ( 1 )
554
master-bin.000001 # Query 1 # use `mysqltest2`; CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
553
master-bin.000001 # Query # # use `mysqltest2`; insert into t values ( 1 )
554
master-bin.000001 # Query # # use `mysqltest2`; CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
556
556
insert into t values (1);
559
master-bin.000001 # Query 1 # use `mysqltest`; SELECT `mysqltest2`.`f1`()
559
master-bin.000001 # Query # # use `mysqltest`; SELECT `mysqltest2`.`f1`()
560
560
set @@global.log_bin_trust_routine_creators= @old_log_bin_trust_routine_creators;
562
562
Warning 1287 '@@log_bin_trust_routine_creators' is deprecated and will be removed in a future release. Please use '@@log_bin_trust_function_creators' instead