diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_row_sp003.result')
-rw-r--r-- | mysql-test/suite/rpl/r/rpl_row_sp003.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_row_sp003.result b/mysql-test/suite/rpl/r/rpl_row_sp003.result index 42acf21c836..8eab5520b7b 100644 --- a/mysql-test/suite/rpl/r/rpl_row_sp003.result +++ b/mysql-test/suite/rpl/r/rpl_row_sp003.result @@ -1,5 +1,6 @@ include/master-slave.inc [connection master] +connection master; DROP PROCEDURE IF EXISTS test.p1; DROP PROCEDURE IF EXISTS test.p2; DROP TABLE IF EXISTS test.t1; @@ -17,22 +18,29 @@ END| SELECT get_lock("test", 200); get_lock("test", 200) 1 +connection master1; CALL test.p1(); +connection master; CALL test.p2(); SELECT release_lock("test"); release_lock("test") 1 +connection master1; get_lock("test", 100) 1 SELECT release_lock("test"); release_lock("test") 1 +connection master; SELECT * FROM test.t1; a 5 +connection slave; +connection slave; SELECT * FROM test.t1; a 5 +connection master; DROP TABLE IF EXISTS test.t1; CREATE TABLE test.t1(a INT,PRIMARY KEY(a))ENGINE=INNODB; CALL test.p2(); @@ -45,10 +53,14 @@ release_lock("test") SELECT * FROM test.t1; a 8 +connection slave; +connection slave; SELECT * FROM test.t1; a 8 +connection master; DROP PROCEDURE IF EXISTS test.p1; DROP PROCEDURE IF EXISTS test.p2; DROP TABLE IF EXISTS test.t1; +connection slave; include/rpl_end.inc |