mirror of
https://github.com/MariaDB/server.git
synced 2025-11-04 04:46:15 +01:00
8d08971c84
- DISCARD/IMPORT TABLESPACE are the only tablespace commands left - TABLESPACE arguments for CREATE TABLE and ALTER ... ADD PARTITION are ignored. - Tablespace names are not shown anymore in .frm and not shown in information schema Other things - Removed end spaces from sql/CMakeList.txt
35 lines
1 KiB
Text
35 lines
1 KiB
Text
use test;
|
|
drop procedure if exists signal_proc;
|
|
drop function if exists signal_func;
|
|
create procedure signal_proc()
|
|
begin
|
|
DECLARE foo CONDITION FOR SQLSTATE '12345';
|
|
SIGNAL foo;
|
|
SIGNAL foo SET MESSAGE_TEXT = "This is an error message";
|
|
RESIGNAL foo;
|
|
RESIGNAL foo SET MESSAGE_TEXT = "This is an error message";
|
|
end $$
|
|
create function signal_func() returns int
|
|
begin
|
|
DECLARE foo CONDITION FOR SQLSTATE '12345';
|
|
SIGNAL foo;
|
|
SIGNAL foo SET MESSAGE_TEXT = "This is an error message";
|
|
RESIGNAL foo;
|
|
RESIGNAL foo SET MESSAGE_TEXT = "This is an error message";
|
|
return 0;
|
|
end $$
|
|
show procedure code signal_proc;
|
|
Pos Instruction
|
|
0 stmt 129 "SIGNAL foo"
|
|
1 stmt 129 "SIGNAL foo SET MESSAGE_TEXT = "This i..."
|
|
2 stmt 130 "RESIGNAL foo"
|
|
3 stmt 130 "RESIGNAL foo SET MESSAGE_TEXT = "This..."
|
|
drop procedure signal_proc;
|
|
show function code signal_func;
|
|
Pos Instruction
|
|
0 stmt 129 "SIGNAL foo"
|
|
1 stmt 129 "SIGNAL foo SET MESSAGE_TEXT = "This i..."
|
|
2 stmt 130 "RESIGNAL foo"
|
|
3 stmt 130 "RESIGNAL foo SET MESSAGE_TEXT = "This..."
|
|
4 freturn int 0
|
|
drop function signal_func;
|