1
# Tests for SIGNAL and RESIGNAL
3
-- source include/have_debug.inc
8
drop procedure if exists signal_proc;
9
drop function if exists signal_func;
14
create procedure signal_proc()
16
DECLARE foo CONDITION FOR SQLSTATE '12345';
19
SIGNAL foo SET MESSAGE_TEXT = "This is an error message";
21
RESIGNAL foo SET MESSAGE_TEXT = "This is an error message";
24
create function signal_func() returns int
26
DECLARE foo CONDITION FOR SQLSTATE '12345';
29
SIGNAL foo SET MESSAGE_TEXT = "This is an error message";
31
RESIGNAL foo SET MESSAGE_TEXT = "This is an error message";
37
show procedure code signal_proc;
38
drop procedure signal_proc;
40
show function code signal_func;
41
drop function signal_func;