summaryrefslogtreecommitdiffstats
path: root/mysql-test/main/signal_demo3.result
blob: fe425f6412dfdb07ac065cef34c7f6f87018c78d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
SET @start_global_value = @@global.max_error_count;
SELECT @start_global_value;
@start_global_value
64
SET @start_session_value = @@session.max_error_count;
SELECT @start_session_value;
@start_session_value
64
drop database if exists demo;
create database demo;
use demo;
create procedure proc_1()
begin
declare exit handler for sqlexception
resignal sqlstate '45000' set message_text='Oops in proc_1';
call proc_2();
end
$$
create procedure proc_2()
begin
declare exit handler for sqlexception
resignal sqlstate '45000' set message_text='Oops in proc_2';
call proc_3();
end
$$
create procedure proc_3()
begin
declare exit handler for sqlexception
resignal sqlstate '45000' set message_text='Oops in proc_3';
call proc_4();
end
$$
create procedure proc_4()
begin
declare exit handler for sqlexception
resignal sqlstate '45000' set message_text='Oops in proc_4';
call proc_5();
end
$$
create procedure proc_5()
begin
declare exit handler for sqlexception
resignal sqlstate '45000' set message_text='Oops in proc_5';
call proc_6();
end
$$
create procedure proc_6()
begin
declare exit handler for sqlexception
resignal sqlstate '45000' set message_text='Oops in proc_6';
call proc_7();
end
$$
create procedure proc_7()
begin
declare exit handler for sqlexception
resignal sqlstate '45000' set message_text='Oops in proc_7';
call proc_8();
end
$$
create procedure proc_8()
begin
declare exit handler for sqlexception
resignal sqlstate '45000' set message_text='Oops in proc_8';
call proc_9();
end
$$
create procedure proc_9()
begin
declare exit handler for sqlexception
resignal sqlstate '45000' set message_text='Oops in proc_9';
## Do something that fails, to see how errors are reported
drop table oops_it_is_not_here;
end
$$
call proc_1();
ERROR 45000: Oops in proc_1
show warnings;
Level	Code	Message
Error	1051	Unknown table 'demo.oops_it_is_not_here'
Error	1644	Oops in proc_9
Note	4094	At line 4 in demo.proc_9
Error	1644	Oops in proc_8
Note	4094	At line 4 in demo.proc_8
Error	1644	Oops in proc_7
Note	4094	At line 4 in demo.proc_7
Error	1644	Oops in proc_6
Note	4094	At line 4 in demo.proc_6
Error	1644	Oops in proc_5
Note	4094	At line 4 in demo.proc_5
Error	1644	Oops in proc_4
Note	4094	At line 4 in demo.proc_4
Error	1644	Oops in proc_3
Note	4094	At line 4 in demo.proc_3
Error	1644	Oops in proc_2
Note	4094	At line 4 in demo.proc_2
Error	1644	Oops in proc_1
Note	4094	At line 4 in demo.proc_1
SET @@session.max_error_count = 5;
SELECT @@session.max_error_count;
@@session.max_error_count
5
call proc_1();
ERROR 45000: Oops in proc_1
show warnings;
Level	Code	Message
Note	4094	At line 4 in demo.proc_3
Error	1644	Oops in proc_2
Note	4094	At line 4 in demo.proc_2
Error	1644	Oops in proc_1
Note	4094	At line 4 in demo.proc_1
SET @@session.max_error_count = 7;
SELECT @@session.max_error_count;
@@session.max_error_count
7
call proc_1();
ERROR 45000: Oops in proc_1
show warnings;
Level	Code	Message
Note	4094	At line 4 in demo.proc_4
Error	1644	Oops in proc_3
Note	4094	At line 4 in demo.proc_3
Error	1644	Oops in proc_2
Note	4094	At line 4 in demo.proc_2
Error	1644	Oops in proc_1
Note	4094	At line 4 in demo.proc_1
SET @@session.max_error_count = 9;
SELECT @@session.max_error_count;
@@session.max_error_count
9
call proc_1();
ERROR 45000: Oops in proc_1
show warnings;
Level	Code	Message
Note	4094	At line 4 in demo.proc_5
Error	1644	Oops in proc_4
Note	4094	At line 4 in demo.proc_4
Error	1644	Oops in proc_3
Note	4094	At line 4 in demo.proc_3
Error	1644	Oops in proc_2
Note	4094	At line 4 in demo.proc_2
Error	1644	Oops in proc_1
Note	4094	At line 4 in demo.proc_1
drop database demo;
SET @@global.max_error_count = @start_global_value;
SELECT @@global.max_error_count;
@@global.max_error_count
64
SET @@session.max_error_count = @start_session_value;
SELECT @@session.max_error_count;
@@session.max_error_count
64