Debian Codegraph @

mysql-test/suite/funcs_1/r/innodb_storedproc_10.result

raw
1
2 --source suite/funcs_1/storedproc/load_sp_tb.inc
3 --------------------------------------------------------------------------------
4 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
5
6 --source suite/funcs_1/storedproc/cleanup_sp_tb.inc
7 --------------------------------------------------------------------------------
8 DROP DATABASE IF EXISTS db_storedproc;
9 DROP DATABASE IF EXISTS db_storedproc_1;
10 CREATE DATABASE db_storedproc charset utf8mb4;
11 CREATE DATABASE db_storedproc_1 charset utf8mb4;
12 USE db_storedproc;
13 create table t1(f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
14 engine = <engine_to_be_tested>;
15 load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' into table t1;
16 create table t2(f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
17 engine = <engine_to_be_tested>;
18 load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' into table t2;
19 create table t3(f1 char(20),f2 char(20),f3 integer) engine = <engine_to_be_tested>;
20 load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/t3.txt' into table t3;
21 create table t4(f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
22 engine = <engine_to_be_tested>;
23 load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' into table t4;
24 USE db_storedproc_1;
25 create table t6(f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
26 engine = <engine_to_be_tested>;
27 load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' into table t6;
28 USE db_storedproc;
29 create table t7 (f1 char(20), f2 char(25), f3 date, f4 int)
30 engine = <engine_to_be_tested>;
31 load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/t7.txt' into table t7;
32 Warnings:
33 Warning 1265 Data truncated for column 'f3' at row 1
34 Warning 1265 Data truncated for column 'f3' at row 2
35 Warning 1265 Data truncated for column 'f3' at row 3
36 Warning 1265 Data truncated for column 'f3' at row 4
37 Warning 1265 Data truncated for column 'f3' at row 5
38 Warning 1265 Data truncated for column 'f3' at row 6
39 Warning 1265 Data truncated for column 'f3' at row 7
40 Warning 1265 Data truncated for column 'f3' at row 8
41 Warning 1265 Data truncated for column 'f3' at row 9
42 Warning 1265 Data truncated for column 'f3' at row 10
43 create table t8 (f1 char(20), f2 char(25), f3 date, f4 int)
44 engine = <engine_to_be_tested>;
45 load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/t7.txt' into table t8;
46 Warnings:
47 Warning 1265 Data truncated for column 'f3' at row 1
48 Warning 1265 Data truncated for column 'f3' at row 2
49 Warning 1265 Data truncated for column 'f3' at row 3
50 Warning 1265 Data truncated for column 'f3' at row 4
51 Warning 1265 Data truncated for column 'f3' at row 5
52 Warning 1265 Data truncated for column 'f3' at row 6
53 Warning 1265 Data truncated for column 'f3' at row 7
54 Warning 1265 Data truncated for column 'f3' at row 8
55 Warning 1265 Data truncated for column 'f3' at row 9
56 Warning 1265 Data truncated for column 'f3' at row 10
57 create table t9(f1 int, f2 char(25), f3 int) engine = <engine_to_be_tested>;
58 load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/t9.txt' into table t9;
59 create table t10(f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
60 engine = <engine_to_be_tested>;
61 load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' into table t10;
62 create table t11(f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
63 engine = <engine_to_be_tested>;
64 load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' into table t11;
65 SET sql_mode = default;
66 Warnings:
67 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.
68
69 Section 3.1.10 - CALL checks:
70 --------------------------------------------------------------------------------
71 Warnings:
72 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.
73 USE db_storedproc;
74 Warnings:
75 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.
76
77 Testcase 3.1.10.2 + 3.1.10.5:
78 -----------------------------
79 Warnings:
80 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.
81 Warnings:
82 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.
83
84 2. Ensure that a procedure cannot be called if the appropriate privileges do not
85 exist.
86 5. Ensure that a function cannot be executed if the appropriate privileges do
87 not exist.
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 DROP PROCEDURE IF EXISTS sp31102;
92 DROP FUNCTION IF EXISTS fn31105;
93 create user 'user_1'@'localhost';
94 create user 'user_2'@'localhost';
95 GRANT CREATE ROUTINE ON db_storedproc.* TO 'user_1'@'localhost';
96 GRANT SELECT ON db_storedproc.* TO 'user_2'@'localhost';
97 FLUSH PRIVILEGES;
98
99 user_1@localhost db_storedproc
100 CREATE PROCEDURE sp31102 () SQL SECURITY INVOKER
101 BEGIN
102 SELECT * FROM db_storedproc.t1 WHERE f4=-5000 LIMIT 1;
103 END//
104 CREATE FUNCTION fn31105(n INT) RETURNS INT
105 BEGIN
106 DECLARE res INT;
107 SET res = n * n;
108 RETURN res;
109 END//
110
111 user_2@localhost db_storedproc
112 CALL sp31102();
113 ERROR 42000: execute command denied to user 'user_2'@'localhost' for routine 'db_storedproc.sp31102'
114 SELECT fn31105( 9 );
115 ERROR 42000: execute command denied to user 'user_2'@'localhost' for routine 'db_storedproc.fn31105'
116 connection default;
117 USE db_storedproc;
118
119 root@localhost db_storedproc
120 CALL sp31102();
121 f1 f2 f3 f4 f5 f6
122 a` a` 1000-01-01 -5000 a` -5000
123 SELECT fn31105( 9 );
124 fn31105( 9 )
125 81
126 GRANT EXECUTE ON db_storedproc.* TO 'user_2'@'localhost';
127 FLUSH PRIVILEGES;
128
129 user_2@localhost db_storedproc
130 CALL sp31102();
131 f1 f2 f3 f4 f5 f6
132 a` a` 1000-01-01 -5000 a` -5000
133 SELECT fn31105( 9 );
134 fn31105( 9 )
135 81
136 connection default;
137 USE db_storedproc;
138
139 root@localhost db_storedproc
140 REVOKE EXECUTE ON db_storedproc.* FROM 'user_2'@'localhost';
141 FLUSH PRIVILEGES;
142 CALL sp31102();
143 f1 f2 f3 f4 f5 f6
144 a` a` 1000-01-01 -5000 a` -5000
145 SELECT fn31105( 9 );
146 fn31105( 9 )
147 81
148
149 user_2@localhost db_storedproc
150 CALL sp31102();
151 ERROR 42000: execute command denied to user 'user_2'@'localhost' for routine 'db_storedproc.sp31102'
152 SELECT fn31105( 9 );
153 ERROR 42000: execute command denied to user 'user_2'@'localhost' for routine 'db_storedproc.fn31105'
154 USE db_storedproc;
155
156 root@localhost db_storedproc
157 DROP PROCEDURE sp31102;
158 DROP FUNCTION fn31105;
159 DROP USER 'user_1'@'localhost';
160 DROP USER 'user_2'@'localhost';
161 Warnings:
162 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.
163
164 Testcase 3.1.10.3:
165 ------------------
166 Warnings:
167 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.
168 Warnings:
169 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.
170
171 Ensure that a function can never be called.
172 --------------------------------------------------------------------------------
173 Warnings:
174 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.
175 DROP FUNCTION IF EXISTS fn1;
176 CREATE FUNCTION fn1(a int) returns int
177 BEGIN
178 set @b = 0.9 * a;
179 return @b;
180 END//
181 CALL fn1();
182 ERROR 42000: PROCEDURE db_storedproc.fn1 does not exist
183 DROP FUNCTION fn1;
184 Warnings:
185 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.
186
187 Testcase 3.1.10.6:
188 ------------------
189 Warnings:
190 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.
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 Ensure that a procedure can never be executed.
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 DROP PROCEDURE IF EXISTS sp1;
199 DROP FUNCTION IF EXISTS sp1;
200 CREATE PROCEDURE sp1()
201 BEGIN
202 SELECT * from t10;
203 END//
204 SELECT sp1();
205 ERROR 42000: FUNCTION db_storedproc.sp1 does not exist
206 DROP PROCEDURE sp1;
207 Warnings:
208 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.
209
210 Testcase 3.1.10.7:
211 ------------------
212 Warnings:
213 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.
214 Warnings:
215 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.
216
217 Ensure that the ROW_COUNT() SQL function always returns the correct number of
218 rows affected by the execution of a stored procedure.
219 --------------------------------------------------------------------------------
220 Warnings:
221 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.
222 DROP PROCEDURE IF EXISTS sp_ins_1;
223 DROP PROCEDURE IF EXISTS sp_ins_3;
224 DROP PROCEDURE IF EXISTS sp_upd;
225 DROP PROCEDURE IF EXISTS sp_ins_upd;
226 DROP PROCEDURE IF EXISTS sp_del;
227 DROP PROCEDURE IF EXISTS sp_with_rowcount;
228 CREATE TABLE temp(f1 CHAR(20),f2 CHAR(25),f3 DATE,f4 INT,f5 CHAR(25),f6 INT);
229 INSERT INTO temp SELECT * FROM t10;
230 CREATE PROCEDURE sp_ins_1()
231 BEGIN
232 INSERT INTO temp VALUES ('abc', 'abc', '20051003', 100, 'uvw', 1000);
233 END//
234 CREATE PROCEDURE sp_ins_3()
235 BEGIN
236 INSERT INTO temp VALUES ('abc', 'xyz', '19490523', 100, 'uvw', 1000);
237 INSERT INTO temp VALUES ('abc', 'xyz', '1989-11-09', 100, 'uvw', 1000);
238 INSERT INTO temp VALUES ('abc', 'xyz', '2005-10-24', 100, 'uvw', 1000);
239 END//
240 CREATE PROCEDURE sp_upd()
241 BEGIN
242 UPDATE temp SET temp.f1 = 'updated' WHERE temp.f1 ='abc';
243 END//
244 CREATE PROCEDURE sp_ins_upd()
245 BEGIN
246 BEGIN
247 INSERT INTO temp VALUES ('qwe', 'abc', '1989-11-09', 100, 'uvw', 1000);
248 INSERT INTO temp VALUES ('qwe', 'xyz', '1998-03-26', 100, 'uvw', 1000);
249 INSERT INTO temp VALUES ('qwe', 'abc', '2000-11-09', 100, 'uvw', 1000);
250 INSERT INTO temp VALUES ('qwe', 'abc', '2005-11-07', 100, 'uvw', 1000);
251 END;
252 SELECT COUNT( f1 ), f1 FROM temp GROUP BY f1;
253 UPDATE temp SET temp.f1 = 'updated_2' WHERE temp.f1 ='qwe' AND temp.f2 = 'abc';
254 END//
255 CREATE PROCEDURE sp_del()
256 BEGIN
257 DELETE FROM temp WHERE temp.f1 ='qwe' OR temp.f1 = 'updated_2';
258 END//
259 CREATE PROCEDURE sp_with_rowcount()
260 BEGIN
261 BEGIN
262 INSERT INTO temp VALUES ('qwe', 'abc', '1989-11-09', 100, 'uvw', 1000),
263 ('qwe', 'xyz', '1998-03-26', 100, 'uvw', 1000),
264 ('qwe', 'abc', '2000-11-09', 100, 'uvw', 1000),
265 ('qwe', 'xyz', '2005-11-07', 100, 'uvw', 1000);
266 END;
267 SELECT row_count() AS 'row_count() after insert';
268 SELECT row_count() AS 'row_count() after select row_count()';
269 SELECT f1,f2,f3 FROM temp ORDER BY f1,f2,f3;
270 UPDATE temp SET temp.f1 = 'updated_2' WHERE temp.f2 = 'abc';
271 SELECT row_count() AS 'row_count() after update';
272 SELECT f1,f2,f3 FROM temp ORDER BY f1,f2,f3;
273 DELETE FROM temp WHERE temp.f1 = 'updated_2';
274 SELECT row_count() AS 'row_count() after delete';
275 END//
276 CALL sp_ins_1();
277 SELECT row_count();
278 row_count()
279 1
280 SELECT * FROM temp;
281 f1 f2 f3 f4 f5 f6
282 a^aaaaaaaa a^aaaaaaaa 1000-01-09 -4992 a^aaaaaaaa -4992
283 a_aaaaaaaaa a_aaaaaaaaa 1000-01-10 -4991 a_aaaaaaaaa -4991
284 a` a` 1000-01-01 -5000 a` -5000
285 aaa aaa 1000-01-02 -4999 aaa -4999
286 abaa abaa 1000-01-03 -4998 abaa -4998
287 abc abc 2005-10-03 100 uvw 1000
288 acaaa acaaa 1000-01-04 -4997 acaaa -4997
289 adaaaa adaaaa 1000-01-05 -4996 adaaaa -4996
290 aeaaaaa aeaaaaa 1000-01-06 -4995 aeaaaaa -4995
291 afaaaaaa afaaaaaa 1000-01-07 -4994 afaaaaaa -4994
292 agaaaaaaa agaaaaaaa 1000-01-08 -4993 agaaaaaaa -4993
293 CALL sp_ins_3();
294 SELECT row_count();
295 row_count()
296 1
297 SELECT * FROM temp;
298 f1 f2 f3 f4 f5 f6
299 a^aaaaaaaa a^aaaaaaaa 1000-01-09 -4992 a^aaaaaaaa -4992
300 a_aaaaaaaaa a_aaaaaaaaa 1000-01-10 -4991 a_aaaaaaaaa -4991
301 a` a` 1000-01-01 -5000 a` -5000
302 aaa aaa 1000-01-02 -4999 aaa -4999
303 abaa abaa 1000-01-03 -4998 abaa -4998
304 abc abc 2005-10-03 100 uvw 1000
305 abc xyz 1949-05-23 100 uvw 1000
306 abc xyz 1989-11-09 100 uvw 1000
307 abc xyz 2005-10-24 100 uvw 1000
308 acaaa acaaa 1000-01-04 -4997 acaaa -4997
309 adaaaa adaaaa 1000-01-05 -4996 adaaaa -4996
310 aeaaaaa aeaaaaa 1000-01-06 -4995 aeaaaaa -4995
311 afaaaaaa afaaaaaa 1000-01-07 -4994 afaaaaaa -4994
312 agaaaaaaa agaaaaaaa 1000-01-08 -4993 agaaaaaaa -4993
313 CALL sp_upd();
314 SELECT row_count();
315 row_count()
316 4
317 SELECT * FROM temp;
318 f1 f2 f3 f4 f5 f6
319 a^aaaaaaaa a^aaaaaaaa 1000-01-09 -4992 a^aaaaaaaa -4992
320 a_aaaaaaaaa a_aaaaaaaaa 1000-01-10 -4991 a_aaaaaaaaa -4991
321 a` a` 1000-01-01 -5000 a` -5000
322 aaa aaa 1000-01-02 -4999 aaa -4999
323 abaa abaa 1000-01-03 -4998 abaa -4998
324 acaaa acaaa 1000-01-04 -4997 acaaa -4997
325 adaaaa adaaaa 1000-01-05 -4996 adaaaa -4996
326 aeaaaaa aeaaaaa 1000-01-06 -4995 aeaaaaa -4995
327 afaaaaaa afaaaaaa 1000-01-07 -4994 afaaaaaa -4994
328 agaaaaaaa agaaaaaaa 1000-01-08 -4993 agaaaaaaa -4993
329 updated abc 2005-10-03 100 uvw 1000
330 updated xyz 1949-05-23 100 uvw 1000
331 updated xyz 1989-11-09 100 uvw 1000
332 updated xyz 2005-10-24 100 uvw 1000
333 CALL sp_ins_upd();
334 COUNT( f1 ) f1
335 1 a`
336 1 aaa
337 1 abaa
338 1 acaaa
339 1 adaaaa
340 1 aeaaaaa
341 1 afaaaaaa
342 1 agaaaaaaa
343 1 a^aaaaaaaa
344 1 a_aaaaaaaaa
345 4 updated
346 4 qwe
347 SELECT row_count();
348 row_count()
349 3
350 SELECT * FROM temp;
351 f1 f2 f3 f4 f5 f6
352 a^aaaaaaaa a^aaaaaaaa 1000-01-09 -4992 a^aaaaaaaa -4992
353 a_aaaaaaaaa a_aaaaaaaaa 1000-01-10 -4991 a_aaaaaaaaa -4991
354 a` a` 1000-01-01 -5000 a` -5000
355 aaa aaa 1000-01-02 -4999 aaa -4999
356 abaa abaa 1000-01-03 -4998 abaa -4998
357 acaaa acaaa 1000-01-04 -4997 acaaa -4997
358 adaaaa adaaaa 1000-01-05 -4996 adaaaa -4996
359 aeaaaaa aeaaaaa 1000-01-06 -4995 aeaaaaa -4995
360 afaaaaaa afaaaaaa 1000-01-07 -4994 afaaaaaa -4994
361 agaaaaaaa agaaaaaaa 1000-01-08 -4993 agaaaaaaa -4993
362 qwe xyz 1998-03-26 100 uvw 1000
363 updated abc 2005-10-03 100 uvw 1000
364 updated xyz 1949-05-23 100 uvw 1000
365 updated xyz 1989-11-09 100 uvw 1000
366 updated xyz 2005-10-24 100 uvw 1000
367 updated_2 abc 1989-11-09 100 uvw 1000
368 updated_2 abc 2000-11-09 100 uvw 1000
369 updated_2 abc 2005-11-07 100 uvw 1000
370 CALL sp_del();
371 SELECT row_count();
372 row_count()
373 4
374 SELECT * FROM temp;
375 f1 f2 f3 f4 f5 f6
376 a^aaaaaaaa a^aaaaaaaa 1000-01-09 -4992 a^aaaaaaaa -4992
377 a_aaaaaaaaa a_aaaaaaaaa 1000-01-10 -4991 a_aaaaaaaaa -4991
378 a` a` 1000-01-01 -5000 a` -5000
379 aaa aaa 1000-01-02 -4999 aaa -4999
380 abaa abaa 1000-01-03 -4998 abaa -4998
381 acaaa acaaa 1000-01-04 -4997 acaaa -4997
382 adaaaa adaaaa 1000-01-05 -4996 adaaaa -4996
383 aeaaaaa aeaaaaa 1000-01-06 -4995 aeaaaaa -4995
384 afaaaaaa afaaaaaa 1000-01-07 -4994 afaaaaaa -4994
385 agaaaaaaa agaaaaaaa 1000-01-08 -4993 agaaaaaaa -4993
386 updated abc 2005-10-03 100 uvw 1000
387 updated xyz 1949-05-23 100 uvw 1000
388 updated xyz 1989-11-09 100 uvw 1000
389 updated xyz 2005-10-24 100 uvw 1000
390 DELETE FROM temp;
391 CALL sp_with_rowcount();
392 row_count() after insert
393 4
394 row_count() after select row_count()
395 -1
396 f1 f2 f3
397 qwe abc 1989-11-09
398 qwe abc 2000-11-09
399 qwe xyz 1998-03-26
400 qwe xyz 2005-11-07
401 row_count() after update
402 2
403 f1 f2 f3
404 qwe xyz 1998-03-26
405 qwe xyz 2005-11-07
406 updated_2 abc 1989-11-09
407 updated_2 abc 2000-11-09
408 row_count() after delete
409 2
410 SELECT row_count();
411 row_count()
412 0
413 SELECT * FROM temp;
414 f1 f2 f3 f4 f5 f6
415 qwe xyz 1998-03-26 100 uvw 1000
416 qwe xyz 2005-11-07 100 uvw 1000
417 DROP PROCEDURE sp_ins_1;
418 DROP PROCEDURE sp_ins_3;
419 DROP PROCEDURE sp_upd;
420 DROP PROCEDURE sp_ins_upd;
421 DROP PROCEDURE sp_del;
422 DROP PROCEDURE sp_with_rowcount;
423 DROP TABLE temp;
424 Warnings:
425 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.
426
427 Testcase 3.1.10.8:
428 ------------------
429 Warnings:
430 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.
431 Warnings:
432 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.
433
434 Ensure that the mysql_affected_rows() C API function always returns the correct
435 number of rows affected by the execution of a stored procedure.
436 --------------------------------------------------------------------------------
437 Warnings:
438 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.
439
440 --source suite/funcs_1/storedproc/cleanup_sp_tb.inc
441 --------------------------------------------------------------------------------
442 DROP DATABASE IF EXISTS db_storedproc;
443 DROP DATABASE IF EXISTS db_storedproc_1;
444
445 . +++ END OF SCRIPT +++
446 --------------------------------------------------------------------------------