Debian Codegraph @

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

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 DROP PROCEDURE IF EXISTS test.p1;
7 DROP PROCEDURE IF EXISTS test.p2;
8 DROP TABLE IF EXISTS test.t2;
9 DROP TABLE IF EXISTS test.t1;
10 DROP TABLE IF EXISTS test.t3;
11 CREATE TABLE IF NOT EXISTS test.t1(id INT, data CHAR(16),PRIMARY KEY(id));
12 CREATE TABLE IF NOT EXISTS test.t2(id2 INT,PRIMARY KEY(id2));
13 CREATE TABLE IF NOT EXISTS test.t3(id3 INT,PRIMARY KEY(id3), c CHAR(16));
14 CREATE PROCEDURE test.p1()
15 BEGIN
16 DECLARE done INT DEFAULT 0;
17 DECLARE spa CHAR(16);
18 DECLARE spb,spc INT;
19 DECLARE cur1 CURSOR FOR SELECT id,data FROM test.t1 ORDER BY id;
20 DECLARE cur2 CURSOR FOR SELECT id2 FROM test.t2 ORDER BY id2;
21 DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
22 OPEN cur1;
23 OPEN cur2;
24 REPEAT
25 FETCH cur1 INTO spb, spa;
26 FETCH cur2 INTO spc;
27 IF NOT done THEN
28 IF spb < spc THEN
29 INSERT INTO test.t3 VALUES (spb,spa);
30 ELSE
31 INSERT INTO test.t3 VALUES (spc,spa);
32 END IF;
33 END IF;
34 UNTIL done END REPEAT;
35 CLOSE cur1;
36 CLOSE cur2;
37 END|
38 CREATE PROCEDURE test.p2()
39 BEGIN
40 INSERT INTO test.t1 VALUES (4,'MySQL'),(20,'ROCKS'),(11,'Texas'),(10,'kyle');
41 INSERT INTO test.t2 VALUES (4),(2),(1),(3);
42 UPDATE test.t1 SET id=id+4 WHERE id=4;
43 END|
44 Warnings:
45 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
46
47 < ---- Master selects-- >
48 -------------------------
49 Warnings:
50 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
51 CALL test.p2();
52 SELECT * FROM test.t1 ORDER BY id;
53 id data
54 8 MySQL
55 10 kyle
56 11 Texas
57 20 ROCKS
58 SELECT * FROM test.t2 ORDER BY id2;
59 id2
60 1
61 2
62 3
63 4
64 Warnings:
65 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
66
67 < ---- Slave selects-- >
68 ------------------------
69 Warnings:
70 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
71 include/sync_slave_sql_with_master.inc
72 SELECT * FROM test.t1 ORDER BY id;
73 id data
74 8 MySQL
75 10 kyle
76 11 Texas
77 20 ROCKS
78 SELECT * FROM test.t2 ORDER BY id2;
79 id2
80 1
81 2
82 3
83 4
84 Warnings:
85 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
86
87 < ---- Master selects-- >
88 -------------------------
89 Warnings:
90 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
91 CALL test.p1();
92 SELECT * FROM test.t3 ORDER BY id3;
93 id3 c
94 1 MySQL
95 2 kyle
96 3 Texas
97 4 ROCKS
98 Warnings:
99 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
100
101 < ---- Slave selects-- >
102 ------------------------
103 Warnings:
104 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
105 include/sync_slave_sql_with_master.inc
106 SELECT * FROM test.t3 ORDER BY id3;
107 id3 c
108 1 MySQL
109 2 kyle
110 3 Texas
111 4 ROCKS
112 ALTER PROCEDURE test.p1 MODIFIES SQL DATA;
113 DROP PROCEDURE IF EXISTS test.p1;
114 DROP PROCEDURE IF EXISTS test.p2;
115 DROP TABLE IF EXISTS test.t1;
116 DROP TABLE IF EXISTS test.t2;
117 DROP TABLE IF EXISTS test.t3;
118 include/sync_slave_sql_with_master.inc
119 include/rpl_end.inc