Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_sp002_innodb.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 CREATE TABLE test.t1 (a INT AUTO_INCREMENT KEY, t CHAR(6)) ENGINE=INNODB;
7 CREATE TABLE test.t2 (a INT AUTO_INCREMENT KEY, f INT, FOREIGN KEY(a) REFERENCES test.t1(a) ON DELETE CASCADE) ENGINE=INNODB;
8 create procedure test.p1(IN i CHAR(6))
9 begin
10 INSERT INTO test.t1 (t) VALUES (i);
11 INSERT INTO test.t2 VALUES (NULL,LAST_INSERT_ID());
12 end|
13 create procedure test.p2(IN i INT)
14 begin
15 DELETE FROM test.t1 where a < i;
16 end|
17 Warnings:
18 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.
19
20 < -- test 1 call p1 -- >
21 ------------------------
22 Warnings:
23 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.
24 SET FOREIGN_KEY_CHECKS=1;
25 call test.p1('texas');
26 call test.p1('Live');
27 call test.p1('next');
28 call test.p1('to');
29 call test.p1('OK');
30 call test.p1('MySQL');
31 Warnings:
32 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.
33
34 < -- test 1 select master after p1 -- >
35 ---------------------------------------
36 Warnings:
37 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.
38 SELECT * FROM test.t1;
39 a t
40 1 texas
41 2 Live
42 3 next
43 4 to
44 5 OK
45 6 MySQL
46 SELECT * FROM test.t2;
47 a f
48 1 1
49 2 2
50 3 3
51 4 4
52 5 5
53 6 6
54 Warnings:
55 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.
56
57 < -- test 1 select slave after p1 -- >
58 --------------------------------------
59 Warnings:
60 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.
61 include/sync_slave_sql_with_master.inc
62 SELECT * FROM test.t1;
63 a t
64 1 texas
65 2 Live
66 3 next
67 4 to
68 5 OK
69 6 MySQL
70 SELECT * FROM test.t2;
71 a f
72 1 1
73 2 2
74 3 3
75 4 4
76 5 5
77 6 6
78 Warnings:
79 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.
80
81 < -- test 1 call p2 & select master -- >
82 ----------------------------------------
83 Warnings:
84 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.
85 call test.p2(4);
86 SELECT * FROM test.t1;
87 a t
88 4 to
89 5 OK
90 6 MySQL
91 SELECT * FROM test.t2;
92 a f
93 4 4
94 5 5
95 6 6
96 Warnings:
97 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.
98
99 < -- test 1 select slave after p2 -- >
100 --------------------------------------
101 Warnings:
102 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.
103 include/sync_slave_sql_with_master.inc
104 SELECT * FROM test.t1;
105 a t
106 4 to
107 5 OK
108 6 MySQL
109 SELECT * FROM test.t2;
110 a f
111 4 4
112 5 5
113 6 6
114 Warnings:
115 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.
116
117 < -- End test 1 Begin test 2 -- >
118 ---------------------------------
119 Warnings:
120 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.
121 SET FOREIGN_KEY_CHECKS=0;
122 DROP PROCEDURE IF EXISTS test.p1;
123 DROP PROCEDURE IF EXISTS test.p2;
124 DROP TABLE IF EXISTS test.t1;
125 DROP TABLE IF EXISTS test.t2;
126 CREATE TABLE test.t1 (a INT, t CHAR(6), PRIMARY KEY(a)) ENGINE=INNODB;
127 CREATE TABLE test.t2 (a INT, f INT, FOREIGN KEY(a) REFERENCES test.t1(a) ON UPDATE CASCADE, PRIMARY KEY(a)) ENGINE=INNODB;
128 CREATE PROCEDURE test.p1(IN nm INT, IN ch CHAR(6))
129 BEGIN
130 INSERT INTO test.t1 (a,t) VALUES (nm, ch);
131 INSERT INTO test.t2 VALUES (nm, LAST_INSERT_ID());
132 END|
133 CREATE PROCEDURE test.p2(IN i INT)
134 BEGIN
135 UPDATE test.t1 SET a = i*10 WHERE a = i;
136 END|
137 SET FOREIGN_KEY_CHECKS=1;
138 CALL test.p1(1,'texas');
139 CALL test.p1(2,'Live');
140 CALL test.p1(3,'next');
141 CALL test.p1(4,'to');
142 CALL test.p1(5,'OK');
143 CALL test.p1(6,'MySQL');
144 Warnings:
145 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.
146
147 < -- test 2 select Master after p1 -- >
148 ---------------------------------------
149 Warnings:
150 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.
151 SELECT * FROM test.t1;
152 a t
153 1 texas
154 2 Live
155 3 next
156 4 to
157 5 OK
158 6 MySQL
159 SELECT * FROM test.t2;
160 a f
161 1 6
162 2 6
163 3 6
164 4 6
165 5 6
166 6 6
167 Warnings:
168 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.
169
170 < -- test 2 select Slave after p1 -- >
171 --------------------------------------
172 Warnings:
173 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.
174 include/sync_slave_sql_with_master.inc
175 SELECT * FROM test.t1;
176 a t
177 1 texas
178 2 Live
179 3 next
180 4 to
181 5 OK
182 6 MySQL
183 SELECT * FROM test.t2;
184 a f
185 1 6
186 2 6
187 3 6
188 4 6
189 5 6
190 6 6
191 Warnings:
192 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.
193
194 < -- test 2 call p2 & select Master -- >
195 ----------------------------------------
196 Warnings:
197 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.
198 CALL test.p2(2);
199 CALL test.p2(4);
200 CALL test.p2(6);
201 SELECT * FROM test.t1;
202 a t
203 1 texas
204 3 next
205 5 OK
206 20 Live
207 40 to
208 60 MySQL
209 SELECT * FROM test.t2;
210 a f
211 1 6
212 3 6
213 5 6
214 20 6
215 40 6
216 60 6
217 Warnings:
218 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.
219
220 < -- test 1 select Slave after p2 -- >
221 --------------------------------------
222 Warnings:
223 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.
224 include/sync_slave_sql_with_master.inc
225 SELECT * FROM test.t1;
226 a t
227 1 texas
228 3 next
229 5 OK
230 20 Live
231 40 to
232 60 MySQL
233 SELECT * FROM test.t2;
234 a f
235 1 6
236 3 6
237 5 6
238 20 6
239 40 6
240 60 6
241 Warnings:
242 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.
243
244 < -- End test 2 Begin test 3 -- >
245 ---------------------------------
246 Warnings:
247 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.
248 CREATE TABLE test.t3 (a INT AUTO_INCREMENT KEY, t CHAR(6))ENGINE=INNODB;
249 CREATE PROCEDURE test.p3(IN n INT)
250 begin
251 CASE n
252 WHEN 2 THEN
253 DELETE from test.t3;
254 ELSE
255 INSERT INTO test.t3 VALUES (NULL,'NONE');
256 END CASE;
257 end|
258 SET AUTOCOMMIT=0;
259 START TRANSACTION;
260 ROLLBACK;
261 select * from test.t3;
262 a t
263 include/sync_slave_sql_with_master.inc
264 select * from test.t3;
265 a t
266 START TRANSACTION;
267 COMMIT;
268 select * from test.t3;
269 a t
270 98 NONE
271 include/sync_slave_sql_with_master.inc
272 select * from test.t3;
273 a t
274 98 NONE
275 SET AUTOCOMMIT=1;
276 SET FOREIGN_KEY_CHECKS=0;
277 DROP PROCEDURE test.p3;
278 DROP PROCEDURE test.p1;
279 DROP PROCEDURE test.p2;
280 DROP TABLE test.t1;
281 DROP TABLE test.t2;
282 DROP TABLE test.t3;
283 include/rpl_end.inc