summaryrefslogtreecommitdiff
path: root/mysql-test/r/rpl_row_sp005.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/rpl_row_sp005.result')
-rw-r--r--mysql-test/r/rpl_row_sp005.result100
1 files changed, 0 insertions, 100 deletions
diff --git a/mysql-test/r/rpl_row_sp005.result b/mysql-test/r/rpl_row_sp005.result
deleted file mode 100644
index 01e1970e0df..00000000000
--- a/mysql-test/r/rpl_row_sp005.result
+++ /dev/null
@@ -1,100 +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 TABLE IF EXISTS test.t2;
-DROP TABLE IF EXISTS test.t1;
-DROP TABLE IF EXISTS test.t3;
-CREATE TABLE IF NOT EXISTS test.t1(id INT, data CHAR(16),PRIMARY KEY(id));
-CREATE TABLE IF NOT EXISTS test.t2(id2 INT,PRIMARY KEY(id2));
-CREATE TABLE IF NOT EXISTS test.t3(id3 INT,PRIMARY KEY(id3), c CHAR(16));
-CREATE PROCEDURE test.p1()
-BEGIN
-DECLARE done INT DEFAULT 0;
-DECLARE spa CHAR(16);
-DECLARE spb,spc INT;
-DECLARE cur1 CURSOR FOR SELECT id,data FROM test.t1 ORDER BY id;
-DECLARE cur2 CURSOR FOR SELECT id2 FROM test.t2 ORDER BY id2;
-DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
-OPEN cur1;
-OPEN cur2;
-REPEAT
-FETCH cur1 INTO spb, spa;
-FETCH cur2 INTO spc;
-IF NOT done THEN
-IF spb < spc THEN
-INSERT INTO test.t3 VALUES (spb,spa);
-ELSE
-INSERT INTO test.t3 VALUES (spc,spa);
-END IF;
-END IF;
-UNTIL done END REPEAT;
-CLOSE cur1;
-CLOSE cur2;
-END|
-CREATE PROCEDURE test.p2()
-BEGIN
-INSERT INTO test.t1 VALUES (4,'MySQL'),(20,'ROCKS'),(11,'Texas'),(10,'kyle');
-INSERT INTO test.t2 VALUES (4),(2),(1),(3);
-UPDATE test.t1 SET id=id+4 WHERE id=4;
-END|
-
-< ---- Master selects-- >
--------------------------
-CALL test.p2();
-SELECT * FROM test.t1 ORDER BY id;
-id data
-8 MySQL
-10 kyle
-11 Texas
-20 ROCKS
-SELECT * FROM test.t2 ORDER BY id2;
-id2
-1
-2
-3
-4
-
-< ---- Slave selects-- >
-------------------------
-SELECT * FROM test.t1 ORDER BY id;
-id data
-8 MySQL
-10 kyle
-11 Texas
-20 ROCKS
-SELECT * FROM test.t2 ORDER BY id2;
-id2
-1
-2
-3
-4
-
-< ---- Master selects-- >
--------------------------
-CALL test.p1();
-SELECT * FROM test.t3 ORDER BY id3;
-id3 c
-1 MySQL
-2 kyle
-3 Texas
-4 ROCKS
-
-< ---- Slave selects-- >
-------------------------
-SELECT * FROM test.t3 ORDER BY id3;
-id3 c
-1 MySQL
-2 kyle
-3 Texas
-4 ROCKS
-ALTER PROCEDURE test.p1 MODIFIES SQL DATA;
-DROP PROCEDURE IF EXISTS test.p1;
-DROP PROCEDURE IF EXISTS test.p2;
-DROP TABLE IF EXISTS test.t1;
-DROP TABLE IF EXISTS test.t2;
-DROP TABLE IF EXISTS test.t3;