summaryrefslogtreecommitdiff
path: root/mysql-test/r/rpl_row_sp012.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/rpl_row_sp012.result')
-rw-r--r--mysql-test/r/rpl_row_sp012.result59
1 files changed, 0 insertions, 59 deletions
diff --git a/mysql-test/r/rpl_row_sp012.result b/mysql-test/r/rpl_row_sp012.result
deleted file mode 100644
index b9c818bad9a..00000000000
--- a/mysql-test/r/rpl_row_sp012.result
+++ /dev/null
@@ -1,59 +0,0 @@
-stop slave;
-drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
-reset master;
-reset slave;
-drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
-start slave;
-DROP PROCEDURE IF EXISTS test.p1;
-DROP PROCEDURE IF EXISTS test.p2;
-DROP PROCEDURE IF EXISTS test.p3;
-grant usage on *.* to user1@localhost;
-flush privileges;
-SELECT CURRENT_USER();
-CURRENT_USER()
-root@localhost
-SELECT USER();
-USER()
-root@localhost
-CREATE PROCEDURE test.p1 () SQL SECURITY INVOKER SELECT CURRENT_USER(), USER();
-CREATE PROCEDURE test.p2 () SQL SECURITY DEFINER CALL test.p1();
-CREATE PROCEDURE test.p3 () SQL SECURITY INVOKER CALL test.p1();
-GRANT EXECUTE ON PROCEDURE p1 TO user1@localhost;
-GRANT EXECUTE ON PROCEDURE p2 TO user1@localhost;
-GRANT EXECUTE ON PROCEDURE p3 TO user1@localhost;
-
-<******** Master user1 p3 & p2 calls *******>
-----------------------------------------------
-SELECT CURRENT_USER();
-CURRENT_USER()
-user1@localhost
-SELECT USER();
-USER()
-user1@localhost
-CALL test.p3();
-CURRENT_USER() USER()
-user1@localhost user1@localhost
-CALL test.p2();
-CURRENT_USER() USER()
-root@localhost user1@localhost
-
-<******** Slave user1 p3 & p2 calls *******>
----------------------------------------------
-SELECT CURRENT_USER();
-CURRENT_USER()
-user1@localhost
-SELECT USER();
-USER()
-user1@localhost
-CALL test.p3();
-CURRENT_USER() USER()
-user1@localhost user1@localhost
-CALL test.p2();
-CURRENT_USER() USER()
-root@localhost user1@localhost
-DROP PROCEDURE IF EXISTS test.p1;
-DROP PROCEDURE IF EXISTS test.p3;
-DROP PROCEDURE IF EXISTS test.p2;
-DROP TABLE IF EXISTS test.t1;
-DROP TABLE IF EXISTS test.t2;
-DROP USER user1@localhost;