417
417
master-bin.000001 # Query # # use `mysqltest1`; insert into t1 values ( NAME_CONST('b',8))
418
418
master-bin.000001 # Query # # use `mysqltest1`; insert into t1 values (unix_timestamp())
419
419
master-bin.000001 # Query # # use `mysqltest1`; delete from t1
420
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` procedure foo2()
420
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `foo2`()
421
421
select * from mysqltest1.t1
422
422
master-bin.000001 # Query # # use `mysqltest1`; alter procedure foo2 contains sql
423
423
master-bin.000001 # Query # # use `mysqltest1`; drop table t1
424
424
master-bin.000001 # Query # # use `mysqltest1`; create table t1 (a int)
425
425
master-bin.000001 # Query # # use `mysqltest1`; create table t2 like t1
426
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` procedure foo3()
426
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `foo3`()
428
428
insert into t1 values (15)
429
429
master-bin.000001 # Query # # use `mysqltest1`; grant CREATE ROUTINE, EXECUTE on mysqltest1.* to "zedjzlcsjhd"@127.0.0.1
430
430
master-bin.000001 # Query # # use `mysqltest1`; grant SELECT on mysqltest1.t1 to "zedjzlcsjhd"@127.0.0.1
431
431
master-bin.000001 # Query # # use `mysqltest1`; grant SELECT, INSERT on mysqltest1.t2 to "zedjzlcsjhd"@127.0.0.1
432
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`zedjzlcsjhd`@`127.0.0.1` procedure foo4()
432
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`zedjzlcsjhd`@`127.0.0.1` PROCEDURE `foo4`()
435
435
insert into t2 values(3);
436
436
insert into t1 values (5);
465
464
master-bin.000001 # Query # # use `mysqltest1`; SELECT `mysqltest1`.`fn1`(20)
466
465
master-bin.000001 # Query # # use `mysqltest1`; insert into t2 values(fn1(21))
467
466
master-bin.000001 # Query # # use `mysqltest1`; drop function fn1
468
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` function fn1()
467
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`() RETURNS int(11)
472
470
return unix_timestamp();
474
472
master-bin.000001 # Query # # use `mysqltest1`; delete from t1
475
473
master-bin.000001 # Query # # use `mysqltest1`; insert into t1 values(fn1())
476
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`zedjzlcsjhd`@`127.0.0.1` function fn2()
474
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`zedjzlcsjhd`@`127.0.0.1` FUNCTION `fn2`() RETURNS int(11)
480
477
return unix_timestamp();
482
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` function fn3()
479
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` FUNCTION `fn3`() RETURNS int(11)
489
484
master-bin.000001 # Query # # use `mysqltest1`; delete from t2
490
485
master-bin.000001 # Query # # use `mysqltest1`; alter table t2 add unique (a)
491
486
master-bin.000001 # Query # # use `mysqltest1`; drop function fn1
492
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` function fn1(x int)
487
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`(x int) RETURNS int(11)
495
489
insert into t2 values(x),(x);
553
550
set global log_bin_trust_function_creators=0;
554
551
drop database mysqltest;
555
552
drop database mysqltest2;
554
/*!50001 create procedure `mysqltestbug36570_p1`() */
559
create procedure test.` mysqltestbug36570_p2`(/*!50001 a int*/)`label`:
563
/*!50001 create function test.mysqltestbug36570_f1() */
565
/*!50001 deterministic */
570
show procedure status like '%mysqltestbug36570%';
571
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
572
test mysqltestbug36570_p2 PROCEDURE root@localhost t t DEFINER latin1 latin1_swedish_ci latin1_swedish_ci
573
test mysqltestbug36570_p1 PROCEDURE root@localhost t t DEFINER latin1 latin1_swedish_ci latin1_swedish_ci
574
show create procedure ` mysqltestbug36570_p2`;
575
Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
576
mysqltestbug36570_p2 CREATE DEFINER=`root`@`localhost` PROCEDURE ` mysqltestbug36570_p2`( a int)
580
end latin1 latin1_swedish_ci latin1_swedish_ci
581
show procedure status like '%mysqltestbug36570%';
582
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
583
test mysqltestbug36570_p2 PROCEDURE root@localhost t t DEFINER latin1 latin1_swedish_ci latin1_swedish_ci
584
test mysqltestbug36570_p1 PROCEDURE root@localhost t t DEFINER latin1 latin1_swedish_ci latin1_swedish_ci
585
show create procedure ` mysqltestbug36570_p2`;
586
Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
587
mysqltestbug36570_p2 CREATE DEFINER=`root`@`localhost` PROCEDURE ` mysqltestbug36570_p2`( a int)
591
end latin1 latin1_swedish_ci latin1_swedish_ci
592
call ` mysqltestbug36570_p2`(42);
595
show function status like '%mysqltestbug36570%';
596
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
597
test mysqltestbug36570_f1 FUNCTION root@localhost t t DEFINER latin1 latin1_swedish_ci latin1_swedish_ci
599
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
600
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
603
SET TIMESTAMP=t/*!*/;
604
SET @@session.pseudo_thread_id=999999999/*!*/;
605
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1/*!*/;
606
SET @@session.sql_mode=0/*!*/;
607
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
608
/*!\C latin1 *//*!*/;
609
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
610
SET @@session.lc_time_names=0/*!*/;
611
SET @@session.collation_database=DEFAULT/*!*/;
612
drop database if exists mysqltest1
614
SET TIMESTAMP=t/*!*/;
615
create database mysqltest1
618
SET TIMESTAMP=t/*!*/;
619
create table t1 (a varchar(100))
621
SET TIMESTAMP=t/*!*/;
622
CREATE DEFINER=`root`@`localhost` PROCEDURE `foo`()
626
insert into t1 values (b);
627
insert into t1 values (unix_timestamp());
630
SET TIMESTAMP=t/*!*/;
631
insert into t1 values ( NAME_CONST('b',8))
633
SET TIMESTAMP=t/*!*/;
634
insert into t1 values (unix_timestamp())
636
SET TIMESTAMP=t/*!*/;
639
SET TIMESTAMP=t/*!*/;
640
CREATE DEFINER=`root`@`localhost` PROCEDURE `foo2`()
641
select * from mysqltest1.t1
643
SET TIMESTAMP=t/*!*/;
644
alter procedure foo2 contains sql
646
SET TIMESTAMP=t/*!*/;
649
SET TIMESTAMP=t/*!*/;
650
create table t1 (a int)
652
SET TIMESTAMP=t/*!*/;
653
create table t2 like t1
655
SET TIMESTAMP=t/*!*/;
656
CREATE DEFINER=`root`@`localhost` PROCEDURE `foo3`()
658
insert into t1 values (15)
660
SET TIMESTAMP=t/*!*/;
661
grant CREATE ROUTINE, EXECUTE on mysqltest1.* to "zedjzlcsjhd"@127.0.0.1
663
SET TIMESTAMP=t/*!*/;
664
grant SELECT on mysqltest1.t1 to "zedjzlcsjhd"@127.0.0.1
666
SET TIMESTAMP=t/*!*/;
667
grant SELECT, INSERT on mysqltest1.t2 to "zedjzlcsjhd"@127.0.0.1
669
SET TIMESTAMP=t/*!*/;
670
CREATE DEFINER=`zedjzlcsjhd`@`127.0.0.1` PROCEDURE `foo4`()
673
insert into t2 values(3);
674
insert into t1 values (5);
677
SET TIMESTAMP=t/*!*/;
678
insert into t2 values(3)
680
SET TIMESTAMP=t/*!*/;
681
insert into t1 values (15)
683
SET TIMESTAMP=t/*!*/;
684
insert into t2 values(3)
686
SET TIMESTAMP=t/*!*/;
687
alter procedure foo4 sql security invoker
689
SET TIMESTAMP=t/*!*/;
690
insert into t2 values(3)
692
SET TIMESTAMP=t/*!*/;
693
insert into t1 values (5)
695
SET TIMESTAMP=t/*!*/;
698
SET TIMESTAMP=t/*!*/;
699
alter table t2 add unique (a)
701
SET TIMESTAMP=t/*!*/;
704
SET TIMESTAMP=t/*!*/;
705
CREATE DEFINER=`root`@`localhost` PROCEDURE `foo4`()
708
insert into t2 values(20),(20);
711
SET TIMESTAMP=t/*!*/;
712
insert into t2 values(20),(20)
714
SET TIMESTAMP=t/*!*/;
717
SET TIMESTAMP=t/*!*/;
720
SET TIMESTAMP=t/*!*/;
723
SET TIMESTAMP=t/*!*/;
726
SET TIMESTAMP=t/*!*/;
727
CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`(x int) RETURNS int(11)
730
insert into t1 values (x);
734
SET TIMESTAMP=t/*!*/;
735
delete t1,t2 from t1,t2
737
SET TIMESTAMP=t/*!*/;
738
SELECT `mysqltest1`.`fn1`(20)
740
SET TIMESTAMP=t/*!*/;
741
insert into t2 values(fn1(21))
743
SET TIMESTAMP=t/*!*/;
746
SET TIMESTAMP=t/*!*/;
747
CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`() RETURNS int(11)
750
return unix_timestamp();
753
SET TIMESTAMP=t/*!*/;
756
SET TIMESTAMP=t/*!*/;
757
insert into t1 values(fn1())
759
SET TIMESTAMP=t/*!*/;
760
CREATE DEFINER=`zedjzlcsjhd`@`127.0.0.1` FUNCTION `fn2`() RETURNS int(11)
763
return unix_timestamp();
766
SET TIMESTAMP=t/*!*/;
767
CREATE DEFINER=`root`@`localhost` FUNCTION `fn3`() RETURNS int(11)
773
SET TIMESTAMP=t/*!*/;
776
SET TIMESTAMP=t/*!*/;
777
alter table t2 add unique (a)
779
SET TIMESTAMP=t/*!*/;
782
SET TIMESTAMP=t/*!*/;
783
CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`(x int) RETURNS int(11)
785
insert into t2 values(x),(x);
789
SET TIMESTAMP=t/*!*/;
790
SELECT `mysqltest1`.`fn1`(100)
792
SET TIMESTAMP=t/*!*/;
793
SELECT `mysqltest1`.`fn1`(20)
795
SET TIMESTAMP=t/*!*/;
798
SET TIMESTAMP=t/*!*/;
799
CREATE DEFINER=`root`@`localhost` trigger trg before insert on t1 for each row set new.a= 10
801
SET TIMESTAMP=t/*!*/;
802
insert into t1 values (1)
804
SET TIMESTAMP=t/*!*/;
807
SET TIMESTAMP=t/*!*/;
810
SET TIMESTAMP=t/*!*/;
811
insert into t1 values (1)
813
SET TIMESTAMP=t/*!*/;
814
CREATE DEFINER=`root`@`localhost` PROCEDURE `foo`()
818
SET TIMESTAMP=t/*!*/;
821
SET TIMESTAMP=t/*!*/;
824
SET TIMESTAMP=t/*!*/;
825
drop database mysqltest1
827
SET TIMESTAMP=t/*!*/;
828
drop user "zedjzlcsjhd"@127.0.0.1
831
SET TIMESTAMP=t/*!*/;
832
CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
836
declare c cursor for select a from v1;
843
SET TIMESTAMP=t/*!*/;
844
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select 1 as a
846
SET TIMESTAMP=t/*!*/;
847
create table t1 (a int)
849
SET TIMESTAMP=t/*!*/;
850
insert into t1 (a) values (f1())
852
SET TIMESTAMP=t/*!*/;
855
SET TIMESTAMP=t/*!*/;
858
SET TIMESTAMP=t/*!*/;
859
DROP TABLE IF EXISTS t1
861
SET TIMESTAMP=t/*!*/;
862
CREATE TABLE t1(col VARCHAR(10))
864
SET TIMESTAMP=t/*!*/;
865
CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`(arg VARCHAR(10))
866
INSERT INTO t1 VALUES(arg)
868
SET TIMESTAMP=t/*!*/;
869
INSERT INTO t1 VALUES( NAME_CONST('arg',_latin1'test'))
871
SET TIMESTAMP=t/*!*/;
874
SET TIMESTAMP=t/*!*/;
875
CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
878
SET TIMESTAMP=t/*!*/;
879
CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
882
SET TIMESTAMP=t/*!*/;
885
SET TIMESTAMP=t/*!*/;
888
SET TIMESTAMP=t/*!*/;
891
SET TIMESTAMP=t/*!*/;
892
drop database if exists mysqltest
894
SET TIMESTAMP=t/*!*/;
895
drop database if exists mysqltest2
897
SET TIMESTAMP=t/*!*/;
898
create database mysqltest
900
SET TIMESTAMP=t/*!*/;
901
create database mysqltest2
904
SET TIMESTAMP=t/*!*/;
905
create table t ( t integer )
907
SET TIMESTAMP=t/*!*/;
908
CREATE DEFINER=`root`@`localhost` PROCEDURE `mysqltest`.`test`()
911
SET TIMESTAMP=t/*!*/;
912
insert into t values ( 1 )
914
SET TIMESTAMP=t/*!*/;
915
CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
917
insert into t values (1);
922
SET TIMESTAMP=t/*!*/;
923
SELECT `mysqltest2`.`f1`()
925
SET TIMESTAMP=t/*!*/;
926
drop database mysqltest
928
SET TIMESTAMP=t/*!*/;
929
drop database mysqltest2
932
SET TIMESTAMP=t/*!*/;
933
CREATE DEFINER=`root`@`localhost` PROCEDURE `mysqltestbug36570_p1`()
939
SET TIMESTAMP=t/*!*/;
940
CREATE DEFINER=`root`@`localhost` PROCEDURE `test`.` mysqltestbug36570_p2`( a int)
946
SET TIMESTAMP=t/*!*/;
947
CREATE DEFINER=`root`@`localhost` FUNCTION `test`.`mysqltestbug36570_f1`() RETURNS int(11)
955
ROLLBACK /* added by mysqlbinlog */;
956
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
958
drop procedure mysqltestbug36570_p1;
959
drop procedure ` mysqltestbug36570_p2`;
960
drop function mysqltestbug36570_f1;