1
# Test file for stored procedure bugfixes
4
--echo # Bug #47412: Valgrind warnings / user can read uninitalized memory
5
--echo # using SP variables
11
CREATE FUNCTION f2 () RETURNS INTEGER
13
DECLARE CONTINUE HANDLER FOR SQLSTATE '42000' SET @aux = 1;
14
RETURN f_not_exists () ;
16
CREATE PROCEDURE p3 ( arg1 VARCHAR(32) )
18
CALL p_not_exists ( );
21
--echo # should not return valgrind warnings
22
--error ER_SP_DOES_NOT_EXIST
30
CREATE FUNCTION f2 () RETURNS INTEGER
32
DECLARE CONTINUE HANDLER FOR SQLSTATE '42000' SET @aux = 1;
33
RETURN f_not_exists () ;
35
CREATE PROCEDURE p3 ( arg2 INTEGER )
37
CALL p_not_exists ( );
40
--echo # should not return valgrind warnings
41
--error ER_SP_DOES_NOT_EXIST
49
CREATE FUNCTION f2 () RETURNS INTEGER
51
DECLARE CONTINUE HANDLER FOR SQLSTATE '42000' SET @aux = 1;
52
RETURN f_not_exists () ;
55
--echo # should not return valgrind warnings
63
--echo # Bug#50423: Crash on second call of a procedure dropping a trigger
67
DROP TABLE IF EXISTS t1;
68
DROP TRIGGER IF EXISTS tr1;
69
DROP PROCEDURE IF EXISTS p1;
72
CREATE TABLE t1 (f1 INTEGER);
73
CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW SET @aux = 1;
74
CREATE PROCEDURE p1 () DROP TRIGGER tr1;
77
--error ER_TRG_DOES_NOT_EXIST
84
--echo # Bug#50423: Crash on second call of a procedure dropping a trigger
88
DROP TABLE IF EXISTS t1;
89
DROP TRIGGER IF EXISTS tr1;
90
DROP PROCEDURE IF EXISTS p1;
93
CREATE TABLE t1 (f1 INTEGER);
94
CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW SET @aux = 1;
95
CREATE PROCEDURE p1 () DROP TRIGGER tr1;
98
--error ER_TRG_DOES_NOT_EXIST
104
--echo End of 5.1 tests