1
SET @start_global_value = @@global.max_sp_recursion_depth;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.max_sp_recursion_depth;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_085_01-------------------------#'
10
SET @@global.max_sp_recursion_depth = 1000;
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
17
SET @@session.max_sp_recursion_depth = 1000;
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
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
29
SET @@session.max_sp_recursion_depth = DEFAULT;
30
SELECT @@session.max_sp_recursion_depth = 0;
31
@@session.max_sp_recursion_depth = 0
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
38
SET @@global.max_sp_recursion_depth = 1;
39
SELECT @@global.max_sp_recursion_depth;
40
@@global.max_sp_recursion_depth
42
SET @@global.max_sp_recursion_depth = 254;
43
SELECT @@global.max_sp_recursion_depth;
44
@@global.max_sp_recursion_depth
46
SET @@global.max_sp_recursion_depth = 255;
47
SELECT @@global.max_sp_recursion_depth;
48
@@global.max_sp_recursion_depth
50
SET @@global.max_sp_recursion_depth = 150;
51
SELECT @@global.max_sp_recursion_depth;
52
@@global.max_sp_recursion_depth
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
59
SET @@session.max_sp_recursion_depth = 1;
60
SELECT @@session.max_sp_recursion_depth;
61
@@session.max_sp_recursion_depth
63
SET @@session.max_sp_recursion_depth = 254;
64
SELECT @@session.max_sp_recursion_depth;
65
@@session.max_sp_recursion_depth
67
SET @@session.max_sp_recursion_depth = 255;
68
SELECT @@session.max_sp_recursion_depth;
69
@@session.max_sp_recursion_depth
71
SET @@session.max_sp_recursion_depth = 150;
72
SELECT @@session.max_sp_recursion_depth;
73
@@session.max_sp_recursion_depth
75
'#------------------FN_DYNVARS_085_05-----------------------#'
76
SET @@global.max_sp_recursion_depth = -1024;
77
SELECT @@global.max_sp_recursion_depth;
78
@@global.max_sp_recursion_depth
80
SET @@global.max_sp_recursion_depth = 256;
82
Warning 1292 Truncated incorrect max_sp_recursion_depth value: '256'
83
SELECT @@global.max_sp_recursion_depth;
84
@@global.max_sp_recursion_depth
86
SET @@global.max_sp_recursion_depth = -1;
87
SELECT @@global.max_sp_recursion_depth;
88
@@global.max_sp_recursion_depth
90
SET @@global.max_sp_recursion_depth = 3000;
92
Warning 1292 Truncated incorrect max_sp_recursion_depth value: '3000'
93
SELECT @@global.max_sp_recursion_depth;
94
@@global.max_sp_recursion_depth
96
SET @@global.max_sp_recursion_depth = 65530.34.;
97
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1
98
SELECT @@global.max_sp_recursion_depth;
99
@@global.max_sp_recursion_depth
101
SET @@global.max_sp_recursion_depth = test;
102
ERROR 42000: Incorrect argument type to variable 'max_sp_recursion_depth'
103
SELECT @@global.max_sp_recursion_depth;
104
@@global.max_sp_recursion_depth
106
SET @@session.max_sp_recursion_depth = 256;
108
Warning 1292 Truncated incorrect max_sp_recursion_depth value: '256'
109
SELECT @@session.max_sp_recursion_depth;
110
@@session.max_sp_recursion_depth
112
SET @@session.max_sp_recursion_depth = -1;
113
SELECT @@session.max_sp_recursion_depth;
114
@@session.max_sp_recursion_depth
116
SET @@session.max_sp_recursion_depth = 500000;
118
Warning 1292 Truncated incorrect max_sp_recursion_depth value: '500000'
119
SELECT @@session.max_sp_recursion_depth;
120
@@session.max_sp_recursion_depth
122
SET @@session.max_sp_recursion_depth = -001;
123
SELECT @@session.max_sp_recursion_depth;
124
@@session.max_sp_recursion_depth
126
SET @@session.max_sp_recursion_depth = 65530.34.;
127
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1
128
SET @@session.max_sp_recursion_depth = 10737418241;
130
Warning 1292 Truncated incorrect max_sp_recursion_depth value: '10737418241'
131
SELECT @@session.max_sp_recursion_depth;
132
@@session.max_sp_recursion_depth
134
SET @@session.max_sp_recursion_depth = test;
135
ERROR 42000: Incorrect argument type to variable 'max_sp_recursion_depth'
136
SELECT @@session.max_sp_recursion_depth;
137
@@session.max_sp_recursion_depth
139
'#------------------FN_DYNVARS_085_06-----------------------#'
140
SELECT @@global.max_sp_recursion_depth = VARIABLE_VALUE
141
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
142
WHERE VARIABLE_NAME='max_sp_recursion_depth';
143
@@global.max_sp_recursion_depth = VARIABLE_VALUE
145
'#------------------FN_DYNVARS_085_07-----------------------#'
146
SELECT @@session.max_sp_recursion_depth = VARIABLE_VALUE
147
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
148
WHERE VARIABLE_NAME='max_sp_recursion_depth';
149
@@session.max_sp_recursion_depth = VARIABLE_VALUE
151
'#------------------FN_DYNVARS_085_08-----------------------#'
152
SET @@global.max_sp_recursion_depth = TRUE;
153
SELECT @@global.max_sp_recursion_depth;
154
@@global.max_sp_recursion_depth
156
SET @@global.max_sp_recursion_depth = FALSE;
157
SELECT @@global.max_sp_recursion_depth;
158
@@global.max_sp_recursion_depth
160
'#---------------------FN_DYNVARS_085_09----------------------#'
161
SET @@global.max_sp_recursion_depth = 20;
162
SELECT @@max_sp_recursion_depth = @@global.max_sp_recursion_depth;
163
@@max_sp_recursion_depth = @@global.max_sp_recursion_depth
165
'#---------------------FN_DYNVARS_085_10----------------------#'
166
SET @@max_sp_recursion_depth = 255;
167
SELECT @@max_sp_recursion_depth = @@local.max_sp_recursion_depth;
168
@@max_sp_recursion_depth = @@local.max_sp_recursion_depth
170
SELECT @@local.max_sp_recursion_depth = @@session.max_sp_recursion_depth;
171
@@local.max_sp_recursion_depth = @@session.max_sp_recursion_depth
173
'#---------------------FN_DYNVARS_085_11----------------------#'
174
SET max_sp_recursion_depth = 102;
175
SELECT @@max_sp_recursion_depth;
176
@@max_sp_recursion_depth
178
SELECT local.max_sp_recursion_depth;
179
ERROR 42S02: Unknown table 'local' in field list
180
SELECT session.max_sp_recursion_depth;
181
ERROR 42S02: Unknown table 'session' in field list
182
SELECT max_sp_recursion_depth = @@session.max_sp_recursion_depth;
183
ERROR 42S22: Unknown column 'max_sp_recursion_depth' in 'field list'
184
SET @@global.max_sp_recursion_depth = @start_global_value;
185
SELECT @@global.max_sp_recursion_depth;
186
@@global.max_sp_recursion_depth
188
SET @@session.max_sp_recursion_depth = @start_session_value;
189
SELECT @@session.max_sp_recursion_depth;
190
@@session.max_sp_recursion_depth