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 @@session.max_sp_recursion_depth = 256;
111 Warnings:
112 Warning 1292 Truncated incorrect max_sp_recursion_depth value: '256'
113 SELECT @@session.max_sp_recursion_depth;
114 @@session.max_sp_recursion_depth
115 255
116 SET @@session.max_sp_recursion_depth = -1;
117 Warnings:
118 Warning 1292 Truncated incorrect max_sp_recursion_depth value: '-1'
119 SELECT @@session.max_sp_recursion_depth;
120 @@session.max_sp_recursion_depth
121 0
122 SET @@session.max_sp_recursion_depth = 500000;
123 Warnings:
124 Warning 1292 Truncated incorrect max_sp_recursion_depth value: '500000'
125 SELECT @@session.max_sp_recursion_depth;
126 @@session.max_sp_recursion_depth
127 255
128 SET @@session.max_sp_recursion_depth = -001;
129 Warnings:
130 Warning 1292 Truncated incorrect max_sp_recursion_depth value: '-1'
131 SELECT @@session.max_sp_recursion_depth;
132 @@session.max_sp_recursion_depth
133 0
134 SET @@session.max_sp_recursion_depth = 65530.34;
135 ERROR 42000: Incorrect argument type to variable 'max_sp_recursion_depth'
136 SET @@session.max_sp_recursion_depth = 10737418241;
137 Warnings:
138 Warning 1292 Truncated incorrect max_sp_recursion_depth value: '10737418241'
139 SELECT @@session.max_sp_recursion_depth;
140 @@session.max_sp_recursion_depth
141 255
142 SET @@session.max_sp_recursion_depth = test;
143 ERROR 42000: Incorrect argument type to variable 'max_sp_recursion_depth'
144 SELECT @@session.max_sp_recursion_depth;
145 @@session.max_sp_recursion_depth
146 255
147 '#------------------FN_DYNVARS_085_06-----------------------#'
148 SELECT @@global.max_sp_recursion_depth = VARIABLE_VALUE
149 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
150 WHERE VARIABLE_NAME='max_sp_recursion_depth';
151 @@global.max_sp_recursion_depth = VARIABLE_VALUE
152 1
153 '#------------------FN_DYNVARS_085_07-----------------------#'
154 SELECT @@session.max_sp_recursion_depth = VARIABLE_VALUE
155 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
156 WHERE VARIABLE_NAME='max_sp_recursion_depth';
157 @@session.max_sp_recursion_depth = VARIABLE_VALUE
158 1
159 '#------------------FN_DYNVARS_085_08-----------------------#'
160 SET @@global.max_sp_recursion_depth = TRUE;
161 SELECT @@global.max_sp_recursion_depth;
162 @@global.max_sp_recursion_depth
163 1
164 SET @@global.max_sp_recursion_depth = FALSE;
165 SELECT @@global.max_sp_recursion_depth;
166 @@global.max_sp_recursion_depth
167 0
168 '#---------------------FN_DYNVARS_085_09----------------------#'
169 SET @@global.max_sp_recursion_depth = 20;
170 SELECT @@max_sp_recursion_depth = @@global.max_sp_recursion_depth;
171 @@max_sp_recursion_depth = @@global.max_sp_recursion_depth
172 0
173 '#---------------------FN_DYNVARS_085_10----------------------#'
174 SET @@max_sp_recursion_depth = 255;
175 SELECT @@max_sp_recursion_depth = @@local.max_sp_recursion_depth;
176 @@max_sp_recursion_depth = @@local.max_sp_recursion_depth
177 1
178 SELECT @@local.max_sp_recursion_depth = @@session.max_sp_recursion_depth;
179 @@local.max_sp_recursion_depth = @@session.max_sp_recursion_depth
180 1
181 '#---------------------FN_DYNVARS_085_11----------------------#'
182 SET max_sp_recursion_depth = 102;
183 SELECT @@max_sp_recursion_depth;
184 @@max_sp_recursion_depth
185 102
186 SELECT local.max_sp_recursion_depth;
187 ERROR 42S02: Unknown table 'local' in SELECT
188 SELECT session.max_sp_recursion_depth;
189 ERROR 42S02: Unknown table 'session' in SELECT
190 SELECT max_sp_recursion_depth = @@session.max_sp_recursion_depth;
191 ERROR 42S22: Unknown column 'max_sp_recursion_depth' in 'SELECT'
192 SET @@global.max_sp_recursion_depth = @start_global_value;
193 SELECT @@global.max_sp_recursion_depth;
194 @@global.max_sp_recursion_depth
195 0
196 SET @@session.max_sp_recursion_depth = @start_session_value;
197 SELECT @@session.max_sp_recursion_depth;
198 @@session.max_sp_recursion_depth
199 0