Debian Codegraph @

mysql-test/suite/sys_vars/r/max_sp_recursion_depth_basic.result

raw
1 SET @start_global_value = @@global.max_sp_recursion_depth;
2 SELECT @start_global_value;
3 @start_global_value
4 0
5 SET @start_session_value = @@session.max_sp_recursion_depth;
6 SELECT @start_session_value;
7 @start_session_value
8 0
9 '#--------------------FN_DYNVARS_085_01-------------------------#'
10 SET @@global.max_sp_recursion_depth = 1000;
11 Warnings:
12 Warning 1292 Truncated incorrect max_sp_recursion_depth value: '1000'
13 SET @@global.max_sp_recursion_depth = DEFAULT;
14 SELECT @@global.max_sp_recursion_depth;
15 @@global.max_sp_recursion_depth
16 0
17 SET @@session.max_sp_recursion_depth = 1000;
18 Warnings:
19 Warning 1292 Truncated incorrect max_sp_recursion_depth value: '1000'
20 SET @@session.max_sp_recursion_depth = DEFAULT;
21 SELECT @@session.max_sp_recursion_depth;
22 @@session.max_sp_recursion_depth
23 0
24 '#--------------------FN_DYNVARS_085_02-------------------------#'
25 SET @@global.max_sp_recursion_depth = DEFAULT;
26 SELECT @@global.max_sp_recursion_depth = 0;
27 @@global.max_sp_recursion_depth = 0
28 1
29 SET @@session.max_sp_recursion_depth = DEFAULT;
30 SELECT @@session.max_sp_recursion_depth = 0;
31 @@session.max_sp_recursion_depth = 0
32 1
33 '#--------------------FN_DYNVARS_085_03-------------------------#'
34 SET @@global.max_sp_recursion_depth = 0;
35 SELECT @@global.max_sp_recursion_depth;
36 @@global.max_sp_recursion_depth
37 0
38 SET @@global.max_sp_recursion_depth = 1;
39 SELECT @@global.max_sp_recursion_depth;
40 @@global.max_sp_recursion_depth
41 1
42 SET @@global.max_sp_recursion_depth = 254;
43 SELECT @@global.max_sp_recursion_depth;
44 @@global.max_sp_recursion_depth
45 254
46 SET @@global.max_sp_recursion_depth = 255;
47 SELECT @@global.max_sp_recursion_depth;
48 @@global.max_sp_recursion_depth
49 255
50 SET @@global.max_sp_recursion_depth = 150;
51 SELECT @@global.max_sp_recursion_depth;
52 @@global.max_sp_recursion_depth
53 150
54 '#--------------------FN_DYNVARS_085_04-------------------------#'
55 SET @@session.max_sp_recursion_depth = 0;
56 SELECT @@session.max_sp_recursion_depth;
57 @@session.max_sp_recursion_depth
58 0
59 SET @@session.max_sp_recursion_depth = 1;
60 SELECT @@session.max_sp_recursion_depth;
61 @@session.max_sp_recursion_depth
62 1
63 SET @@session.max_sp_recursion_depth = 254;
64 SELECT @@session.max_sp_recursion_depth;
65 @@session.max_sp_recursion_depth
66 254
67 SET @@session.max_sp_recursion_depth = 255;
68 SELECT @@session.max_sp_recursion_depth;
69 @@session.max_sp_recursion_depth
70 255
71 SET @@session.max_sp_recursion_depth = 150;
72 SELECT @@session.max_sp_recursion_depth;
73 @@session.max_sp_recursion_depth
74 150
75 '#------------------FN_DYNVARS_085_05-----------------------#'
76 SET @@global.max_sp_recursion_depth = -1024;
77 Warnings:
78 Warning 1292 Truncated incorrect max_sp_recursion_depth value: '-1024'
79 SELECT @@global.max_sp_recursion_depth;
80 @@global.max_sp_recursion_depth
81 0
82 SET @@global.max_sp_recursion_depth = 256;
83 Warnings:
84 Warning 1292 Truncated incorrect max_sp_recursion_depth value: '256'
85 SELECT @@global.max_sp_recursion_depth;
86 @@global.max_sp_recursion_depth
87 255
88 SET @@global.max_sp_recursion_depth = -1;
89 Warnings:
90 Warning 1292 Truncated incorrect max_sp_recursion_depth value: '-1'
91 SELECT @@global.max_sp_recursion_depth;
92 @@global.max_sp_recursion_depth
93 0
94 SET @@global.max_sp_recursion_depth = 3000;
95 Warnings:
96 Warning 1292 Truncated incorrect max_sp_recursion_depth value: '3000'
97 SELECT @@global.max_sp_recursion_depth;
98 @@global.max_sp_recursion_depth
99 255
100 SET @@global.max_sp_recursion_depth = 65530.34;
101 ERROR 42000: Incorrect argument type to variable 'max_sp_recursion_depth'
102 SELECT @@global.max_sp_recursion_depth;
103 @@global.max_sp_recursion_depth
104 255
105 SET @@global.max_sp_recursion_depth = test;
106 ERROR 42000: Incorrect argument type to variable 'max_sp_recursion_depth'
107 SELECT @@global.max_sp_recursion_depth;
108 @@global.max_sp_recursion_depth
109 255
110 SET @@global.max_sp_recursion_depth = ' ';
111 ERROR 42000: Incorrect argument type to variable 'max_sp_recursion_depth'
112 SELECT @@global.max_sp_recursion_depth;
113 @@global.max_sp_recursion_depth
114 255
115 SET @@session.max_sp_recursion_depth = 256;
116 Warnings:
117 Warning 1292 Truncated incorrect max_sp_recursion_depth value: '256'
118 SELECT @@session.max_sp_recursion_depth;
119 @@session.max_sp_recursion_depth
120 255
121 SET @@session.max_sp_recursion_depth = -1;
122 Warnings:
123 Warning 1292 Truncated incorrect max_sp_recursion_depth value: '-1'
124 SELECT @@session.max_sp_recursion_depth;
125 @@session.max_sp_recursion_depth
126 0
127 SET @@session.max_sp_recursion_depth = -1024;
128 Warnings:
129 Warning 1292 Truncated incorrect max_sp_recursion_depth value: '-1024'
130 SELECT @@session.max_sp_recursion_depth;
131 @@session.max_sp_recursion_depth
132 0
133 SET @@session.max_sp_recursion_depth = 500000;
134 Warnings:
135 Warning 1292 Truncated incorrect max_sp_recursion_depth value: '500000'
136 SELECT @@session.max_sp_recursion_depth;
137 @@session.max_sp_recursion_depth
138 255
139 SET @@session.max_sp_recursion_depth = -001;
140 Warnings:
141 Warning 1292 Truncated incorrect max_sp_recursion_depth value: '-1'
142 SELECT @@session.max_sp_recursion_depth;
143 @@session.max_sp_recursion_depth
144 0
145 SET @@session.max_sp_recursion_depth = 65530.34;
146 ERROR 42000: Incorrect argument type to variable 'max_sp_recursion_depth'
147 SET @@session.max_sp_recursion_depth = 10737418241;
148 Warnings:
149 Warning 1292 Truncated incorrect max_sp_recursion_depth value: '10737418241'
150 SELECT @@session.max_sp_recursion_depth;
151 @@session.max_sp_recursion_depth
152 255
153 SET @@session.max_sp_recursion_depth = test;
154 ERROR 42000: Incorrect argument type to variable 'max_sp_recursion_depth'
155 SELECT @@session.max_sp_recursion_depth;
156 @@session.max_sp_recursion_depth
157 255
158 SET @@session.max_sp_recursion_depth = ' ';
159 ERROR 42000: Incorrect argument type to variable 'max_sp_recursion_depth'
160 SELECT @@session.max_sp_recursion_depth;
161 @@session.max_sp_recursion_depth
162 255
163 '#------------------FN_DYNVARS_085_06-----------------------#'
164 SELECT @@global.max_sp_recursion_depth = VARIABLE_VALUE
165 FROM performance_schema.global_variables
166 WHERE VARIABLE_NAME='max_sp_recursion_depth';
167 @@global.max_sp_recursion_depth = VARIABLE_VALUE
168 1
169 '#------------------FN_DYNVARS_085_07-----------------------#'
170 SELECT @@session.max_sp_recursion_depth = VARIABLE_VALUE
171 FROM performance_schema.session_variables
172 WHERE VARIABLE_NAME='max_sp_recursion_depth';
173 @@session.max_sp_recursion_depth = VARIABLE_VALUE
174 1
175 '#------------------FN_DYNVARS_085_08-----------------------#'
176 SET @@global.max_sp_recursion_depth = TRUE;
177 SELECT @@global.max_sp_recursion_depth;
178 @@global.max_sp_recursion_depth
179 1
180 SET @@global.max_sp_recursion_depth = FALSE;
181 SELECT @@global.max_sp_recursion_depth;
182 @@global.max_sp_recursion_depth
183 0
184 '#---------------------FN_DYNVARS_085_09----------------------#'
185 SET @@global.max_sp_recursion_depth = 20;
186 SELECT @@max_sp_recursion_depth = @@global.max_sp_recursion_depth;
187 @@max_sp_recursion_depth = @@global.max_sp_recursion_depth
188 0
189 '#---------------------FN_DYNVARS_085_10----------------------#'
190 SET @@max_sp_recursion_depth = 255;
191 SELECT @@max_sp_recursion_depth = @@local.max_sp_recursion_depth;
192 @@max_sp_recursion_depth = @@local.max_sp_recursion_depth
193 1
194 SELECT @@local.max_sp_recursion_depth = @@session.max_sp_recursion_depth;
195 @@local.max_sp_recursion_depth = @@session.max_sp_recursion_depth
196 1
197 '#---------------------FN_DYNVARS_085_11----------------------#'
198 SET max_sp_recursion_depth = 102;
199 SELECT @@max_sp_recursion_depth;
200 @@max_sp_recursion_depth
201 102
202 SELECT local.max_sp_recursion_depth;
203 ERROR 42S02: Unknown table 'local' in field list
204 SELECT session.max_sp_recursion_depth;
205 ERROR 42S02: Unknown table 'session' in field list
206 SELECT max_sp_recursion_depth = @@session.max_sp_recursion_depth;
207 ERROR 42S22: Unknown column 'max_sp_recursion_depth' in 'field list'
208 SET @@global.max_sp_recursion_depth = @start_global_value;
209 SELECT @@global.max_sp_recursion_depth;
210 @@global.max_sp_recursion_depth
211 0
212 SET @@session.max_sp_recursion_depth = @start_session_value;
213 SELECT @@session.max_sp_recursion_depth;
214 @@session.max_sp_recursion_depth
215 0