2
# Bug #47412: Valgrind warnings / user can read uninitalized memory
7
CREATE FUNCTION f2 () RETURNS INTEGER
9
DECLARE CONTINUE HANDLER FOR SQLSTATE '42000' SET @aux = 1;
10
RETURN f_not_exists () ;
12
CREATE PROCEDURE p3 ( arg1 VARCHAR(32) )
14
CALL p_not_exists ( );
16
# should not return valgrind warnings
18
ERROR 42000: PROCEDURE testdb.p_not_exists does not exist
22
CREATE FUNCTION f2 () RETURNS INTEGER
24
DECLARE CONTINUE HANDLER FOR SQLSTATE '42000' SET @aux = 1;
25
RETURN f_not_exists () ;
27
CREATE PROCEDURE p3 ( arg2 INTEGER )
29
CALL p_not_exists ( );
31
# should not return valgrind warnings
33
ERROR 42000: PROCEDURE testdb.p_not_exists does not exist
37
CREATE FUNCTION f2 () RETURNS INTEGER
39
DECLARE CONTINUE HANDLER FOR SQLSTATE '42000' SET @aux = 1;
40
RETURN f_not_exists () ;
42
# should not return valgrind warnings
49
# Bug#50423: Crash on second call of a procedure dropping a trigger
51
DROP TABLE IF EXISTS t1;
52
DROP TRIGGER IF EXISTS tr1;
53
DROP PROCEDURE IF EXISTS p1;
54
CREATE TABLE t1 (f1 INTEGER);
55
CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW SET @aux = 1;
56
CREATE PROCEDURE p1 () DROP TRIGGER tr1;
59
ERROR HY000: Trigger does not exist
63
# Bug#50423: Crash on second call of a procedure dropping a trigger
65
DROP TABLE IF EXISTS t1;
66
DROP TRIGGER IF EXISTS tr1;
67
DROP PROCEDURE IF EXISTS p1;
68
CREATE TABLE t1 (f1 INTEGER);
69
CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW SET @aux = 1;
70
CREATE PROCEDURE p1 () DROP TRIGGER tr1;
73
ERROR HY000: Trigger does not exist