Debian Codegraph @

mysql-test/suite/engines/funcs/r/rpl_row_sp012.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 DROP PROCEDURE IF EXISTS test.p1;
5 DROP PROCEDURE IF EXISTS test.p2;
6 DROP PROCEDURE IF EXISTS test.p3;
7 create user user1@localhost;
8 grant usage on *.* to user1@localhost;
9 flush privileges;
10 SELECT CURRENT_USER();
11 CURRENT_USER()
12 root@localhost
13 SELECT USER();
14 USER()
15 root@localhost
16 CREATE PROCEDURE test.p1 () SQL SECURITY INVOKER SELECT CURRENT_USER(), USER();
17 CREATE PROCEDURE test.p2 () SQL SECURITY DEFINER CALL test.p1();
18 CREATE PROCEDURE test.p3 () SQL SECURITY INVOKER CALL test.p1();
19 GRANT EXECUTE ON PROCEDURE p1 TO user1@localhost;
20 GRANT EXECUTE ON PROCEDURE p2 TO user1@localhost;
21 GRANT EXECUTE ON PROCEDURE p3 TO user1@localhost;
22 set sql_mode=default;
23 connection slave;
24 connect muser1,localhost,user1,,;
25 connection muser1;
26 SELECT CURRENT_USER();
27 CURRENT_USER()
28 user1@localhost
29 SELECT USER();
30 USER()
31 user1@localhost
32 CALL test.p3();
33 CURRENT_USER() USER()
34 user1@localhost user1@localhost
35 CALL test.p2();
36 CURRENT_USER() USER()
37 root@localhost user1@localhost
38 connect suser1,127.0.0.1,user1,,test,$SLAVE_MYPORT,;
39 connection master;
40 connection suser1;
41 SELECT CURRENT_USER();
42 CURRENT_USER()
43 user1@localhost
44 SELECT USER();
45 USER()
46 user1@localhost
47 CALL test.p3();
48 CURRENT_USER() USER()
49 user1@localhost user1@localhost
50 CALL test.p2();
51 CURRENT_USER() USER()
52 root@localhost user1@localhost
53 connection master;
54 DROP PROCEDURE IF EXISTS test.p1;
55 DROP PROCEDURE IF EXISTS test.p3;
56 DROP PROCEDURE IF EXISTS test.p2;
57 DROP TABLE IF EXISTS test.t1;
58 DROP TABLE IF EXISTS test.t2;
59 DROP USER user1@localhost;
60 connection slave;
61 include/rpl_end.inc