Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_sp006_InnoDB.result

raw
1 include/master-slave.inc
2 [connection master]
3 DROP TABLE IF EXISTS t1;
4 DROP TABLE IF EXISTS t2;
5 DROP PROCEDURE IF EXISTS p1;
6 DROP PROCEDURE IF EXISTS p2;
7 CREATE TABLE IF NOT EXISTS t1(name CHAR(16), birth DATE,PRIMARY KEY(name))ENGINE=InnoDB;
8 CREATE TABLE IF NOT EXISTS t2(name CHAR(16), age INT ,PRIMARY KEY(name))ENGINE=InnoDB;
9 CREATE PROCEDURE p1()
10 BEGIN
11 DECLARE done INT DEFAULT 0;
12 DECLARE spa CHAR(16);
13 DECLARE spb INT;
14 DECLARE cur1 CURSOR FOR SELECT name,
15 (YEAR(CURDATE())-YEAR(birth))-(RIGHT(CURDATE(),5)<RIGHT(birth,5))
16 FROM t1;
17 DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
18 OPEN cur1;
19 SET AUTOCOMMIT=0;
20 REPEAT
21 FETCH cur1 INTO spa, spb;
22 IF NOT done THEN
23 START TRANSACTION;
24 INSERT INTO t2 VALUES (spa,spb);
25 COMMIT;
26 END IF;
27 UNTIL done END REPEAT;
28 SET AUTOCOMMIT=1;
29 CLOSE cur1;
30 END|
31 CREATE PROCEDURE p2()
32 BEGIN
33 INSERT INTO t1 VALUES ('MySQL','1993-02-04'),('ROCKS', '1990-08-27'),('Texas', '1999-03-30'),('kyle','2005-1-1');
34 END|
35 CALL p2();
36 connection slave;
37 connection master;
38 CALL p1();
39 connection slave;
40 connection master;
41 DROP TABLE t1;
42 DROP TABLE t2;
43 DROP PROCEDURE p1;
44 DROP PROCEDURE p2;
45 connection slave;
46 include/rpl_end.inc