1
SET @start_global_value = @@global.optimizer_search_depth;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.optimizer_search_depth;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_116_01-------------------------#'
10
SET @@global.optimizer_search_depth = 100;
12
Warning 1292 Truncated incorrect optimizer_search_depth value: '100'
13
Warning 1287 'optimizer-search-depth=63' is deprecated and will be removed in a future release. Please use a search depth less than 63 instead
14
SET @@global.optimizer_search_depth = DEFAULT;
15
SELECT @@global.optimizer_search_depth;
16
@@global.optimizer_search_depth
18
SET @@session.optimizer_search_depth = 200;
20
Warning 1292 Truncated incorrect optimizer_search_depth value: '200'
21
Warning 1287 'optimizer-search-depth=63' is deprecated and will be removed in a future release. Please use a search depth less than 63 instead
22
SET @@session.optimizer_search_depth = DEFAULT;
23
SELECT @@session.optimizer_search_depth;
24
@@session.optimizer_search_depth
26
'#--------------------FN_DYNVARS_116_02-------------------------#'
27
SET @@global.optimizer_search_depth = DEFAULT;
28
SELECT @@global.optimizer_search_depth = 62;
29
@@global.optimizer_search_depth = 62
31
SET @@session.optimizer_search_depth = DEFAULT;
32
SELECT @@session.optimizer_search_depth = 62;
33
@@session.optimizer_search_depth = 62
35
'#--------------------FN_DYNVARS_116_03-------------------------#'
36
SET @@global.optimizer_search_depth = 0;
37
SELECT @@global.optimizer_search_depth;
38
@@global.optimizer_search_depth
40
SET @@global.optimizer_search_depth = 1;
41
SELECT @@global.optimizer_search_depth;
42
@@global.optimizer_search_depth
44
SET @@global.optimizer_search_depth = 62;
45
SELECT @@global.optimizer_search_depth;
46
@@global.optimizer_search_depth
48
SET @@global.optimizer_search_depth = 63;
50
Warning 1287 'optimizer-search-depth=63' is deprecated and will be removed in a future release. Please use a search depth less than 63 instead
51
SELECT @@global.optimizer_search_depth;
52
@@global.optimizer_search_depth
54
'#--------------------FN_DYNVARS_116_04-------------------------#'
55
SET @@session.optimizer_search_depth = 0;
56
SELECT @@session.optimizer_search_depth;
57
@@session.optimizer_search_depth
59
SET @@session.optimizer_search_depth = 1;
60
SELECT @@session.optimizer_search_depth;
61
@@session.optimizer_search_depth
63
SET @@session.optimizer_search_depth = 62;
64
SELECT @@session.optimizer_search_depth;
65
@@session.optimizer_search_depth
67
SET @@session.optimizer_search_depth = 63;
69
Warning 1287 'optimizer-search-depth=63' is deprecated and will be removed in a future release. Please use a search depth less than 63 instead
70
SELECT @@session.optimizer_search_depth;
71
@@session.optimizer_search_depth
73
'#------------------FN_DYNVARS_116_05-----------------------#'
74
SET @@global.optimizer_search_depth = 64;
76
Warning 1292 Truncated incorrect optimizer_search_depth value: '64'
77
Warning 1287 'optimizer-search-depth=63' is deprecated and will be removed in a future release. Please use a search depth less than 63 instead
78
SELECT @@global.optimizer_search_depth;
79
@@global.optimizer_search_depth
81
SET @@global.optimizer_search_depth = -1;
83
Warning 1292 Truncated incorrect optimizer_search_depth value: '-1'
84
SELECT @@global.optimizer_search_depth;
85
@@global.optimizer_search_depth
87
SET @@global.optimizer_search_depth = 65536;
89
Warning 1292 Truncated incorrect optimizer_search_depth value: '65536'
90
Warning 1287 'optimizer-search-depth=63' is deprecated and will be removed in a future release. Please use a search depth less than 63 instead
91
SELECT @@global.optimizer_search_depth;
92
@@global.optimizer_search_depth
94
SET @@global.optimizer_search_depth = 65530.34;
95
ERROR 42000: Incorrect argument type to variable 'optimizer_search_depth'
96
SELECT @@global.optimizer_search_depth;
97
@@global.optimizer_search_depth
99
SET @@global.optimizer_search_depth = test;
100
ERROR 42000: Incorrect argument type to variable 'optimizer_search_depth'
101
SELECT @@global.optimizer_search_depth;
102
@@global.optimizer_search_depth
104
SET @@session.optimizer_search_depth = 64;
106
Warning 1292 Truncated incorrect optimizer_search_depth value: '64'
107
Warning 1287 'optimizer-search-depth=63' is deprecated and will be removed in a future release. Please use a search depth less than 63 instead
108
SELECT @@session.optimizer_search_depth;
109
@@session.optimizer_search_depth
111
SET @@session.optimizer_search_depth = -2;
113
Warning 1292 Truncated incorrect optimizer_search_depth value: '-2'
114
SELECT @@session.optimizer_search_depth;
115
@@session.optimizer_search_depth
117
SET @@session.optimizer_search_depth = 65530.34;
118
ERROR 42000: Incorrect argument type to variable 'optimizer_search_depth'
119
SET @@session.optimizer_search_depth = 65550;
121
Warning 1292 Truncated incorrect optimizer_search_depth value: '65550'
122
Warning 1287 'optimizer-search-depth=63' is deprecated and will be removed in a future release. Please use a search depth less than 63 instead
123
SELECT @@session.optimizer_search_depth;
124
@@session.optimizer_search_depth
126
SET @@session.optimizer_search_depth = test;
127
ERROR 42000: Incorrect argument type to variable 'optimizer_search_depth'
128
SELECT @@session.optimizer_search_depth;
129
@@session.optimizer_search_depth
131
'#------------------FN_DYNVARS_116_06-----------------------#'
132
SELECT @@global.optimizer_search_depth = VARIABLE_VALUE
133
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
134
WHERE VARIABLE_NAME='optimizer_search_depth';
135
@@global.optimizer_search_depth = VARIABLE_VALUE
137
'#------------------FN_DYNVARS_116_07-----------------------#'
138
SELECT @@session.optimizer_search_depth = VARIABLE_VALUE
139
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
140
WHERE VARIABLE_NAME='optimizer_search_depth';
141
@@session.optimizer_search_depth = VARIABLE_VALUE
143
'#------------------FN_DYNVARS_116_08-----------------------#'
144
SET @@global.optimizer_search_depth = TRUE;
145
SELECT @@global.optimizer_search_depth;
146
@@global.optimizer_search_depth
148
SET @@global.optimizer_search_depth = FALSE;
149
SELECT @@global.optimizer_search_depth;
150
@@global.optimizer_search_depth
152
'#---------------------FN_DYNVARS_116_09----------------------#'
153
SET @@global.optimizer_search_depth = 10;
154
SELECT @@optimizer_search_depth = @@global.optimizer_search_depth;
155
@@optimizer_search_depth = @@global.optimizer_search_depth
157
'#---------------------FN_DYNVARS_116_10----------------------#'
158
SET @@optimizer_search_depth = 10;
159
SELECT @@optimizer_search_depth = @@local.optimizer_search_depth;
160
@@optimizer_search_depth = @@local.optimizer_search_depth
162
SELECT @@local.optimizer_search_depth = @@session.optimizer_search_depth;
163
@@local.optimizer_search_depth = @@session.optimizer_search_depth
165
'#---------------------FN_DYNVARS_116_11----------------------#'
166
SET optimizer_search_depth = 1;
167
SELECT @@optimizer_search_depth;
168
@@optimizer_search_depth
170
SELECT local.optimizer_search_depth;
171
ERROR 42S02: Unknown table 'local' in field list
172
SELECT session.optimizer_search_depth;
173
ERROR 42S02: Unknown table 'session' in field list
174
SELECT optimizer_search_depth = @@session.optimizer_search_depth;
175
ERROR 42S22: Unknown column 'optimizer_search_depth' in 'field list'
176
SET @@global.optimizer_search_depth = @start_global_value;
177
SELECT @@global.optimizer_search_depth;
178
@@global.optimizer_search_depth
180
SET @@session.optimizer_search_depth = @start_session_value;
181
SELECT @@session.optimizer_search_depth;
182
@@session.optimizer_search_depth