1 files changed, 91 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_row_sp001.result b/mysql-test/suite/rpl/r/rpl_row_sp001.result
new file mode 100644
index 00000000..d37425c4
--- /dev/null
+++ b/mysql-test/suite/rpl/r/rpl_row_sp001.result
@@ -0,0 +1,91 @@
+include/master-slave.inc
+[connection master]
+
+<Begin test section 1 (non deterministic SP)>
+---------------------------------------------
+create table test.t1 (n MEDIUMINT NOT NULL AUTO_INCREMENT, f FLOAT, d DATETIME, PRIMARY KEY(n));
+create procedure test.p1()
+begin
+INSERT INTO test.t1 (f,d) VALUES (RAND(),NOW());
+end//
+
+<End test section 1 (non deterministic SP)>
+-------------------------------------------
+CREATE TABLE test.t2 (a INT NOT NULL AUTO_INCREMENT, t CHAR(4), PRIMARY KEY(a));
+CREATE PROCEDURE test.p2(n int)
+begin
+CASE n
+WHEN 1 THEN
+UPDATE test.t2 set t ='Tex';
+WHEN 2 THEN
+UPDATE test.t2 set t ='SQL';
+ELSE
+UPDATE test.t2 set t ='NONE';
+END CASE;
+end//
+INSERT INTO test.t2 VALUES(NULL,'NEW'),(NULL,'NEW'),(NULL,'NEW'),(NULL,'NEW');
+SELECT * FROM t2 ORDER BY a;
+a	t
+1	NEW
+2	NEW
+3	NEW
+4	NEW
+connection slave;
+SELECT * FROM t2 ORDER BY a;
+a	t
+1	NEW
+2	NEW
+3	NEW
+4	NEW
+connection master;
+call test.p2(1);
+SELECT * FROM t2 ORDER BY a;
+a	t
+1	Tex
+2	Tex
+3	Tex
+4	Tex
+connection slave;
+SELECT * FROM t2 ORDER BY a;
+a	t
+1	Tex
+2	Tex
+3	Tex
+4	Tex
+connection master;
+call test.p2(2);
+SELECT * FROM t2 ORDER BY a;
+a	t
+1	SQL
+2	SQL
+3	SQL
+4	SQL
+connection slave;
+SELECT * FROM t2 ORDER BY a;
+a	t
+1	SQL
+2	SQL
+3	SQL
+4	SQL
+connection master;
+call test.p2(3);
+SELECT * FROM t2 ORDER BY a;
+a	t
+1	NONE
+2	NONE
+3	NONE
+4	NONE
+connection slave;
+SELECT * FROM t2 ORDER BY a;
+a	t
+1	NONE
+2	NONE
+3	NONE
+4	NONE
+connection master;
+DROP PROCEDURE test.p1;
+DROP PROCEDURE test.p2;
+DROP TABLE test.t1;
+DROP TABLE test.t2;
+connection slave;
+include/rpl_end.inc