58
58
DROP SCHEMA testdb;
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
105
--echo # Bug#54375: Error in stored procedure leaves connection
106
--echo # in different default schema
110
SET @@SQL_MODE = 'STRICT_ALL_TABLES';
111
DROP DATABASE IF EXISTS db1;
114
DROP TABLE IF EXISTS t1;
115
CREATE TABLE t1 (c1 int NOT NULL PRIMARY KEY);
116
INSERT INTO t1 VALUES (1);
124
INSERT INTO t1 SET c1 = some_value;
125
RETURN(LAST_INSERT_ID());
128
DROP DATABASE IF EXISTS db2;
137
DROP FUNCTION db1.f1;
61
141
--echo End of 5.1 tests