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
SET @@global.optimizer_search_depth = DEFAULT;
14
SELECT @@global.optimizer_search_depth;
15
@@global.optimizer_search_depth
17
SET @@session.optimizer_search_depth = 200;
19
Warning 1292 Truncated incorrect optimizer_search_depth value: '200'
20
SET @@session.optimizer_search_depth = DEFAULT;
21
SELECT @@session.optimizer_search_depth;
22
@@session.optimizer_search_depth
24
'#--------------------FN_DYNVARS_116_02-------------------------#'
25
SET @@global.optimizer_search_depth = DEFAULT;
26
SELECT @@global.optimizer_search_depth = 62;
27
@@global.optimizer_search_depth = 62
29
SET @@session.optimizer_search_depth = DEFAULT;
30
SELECT @@session.optimizer_search_depth = 62;
31
@@session.optimizer_search_depth = 62
33
'#--------------------FN_DYNVARS_116_03-------------------------#'
34
SET @@global.optimizer_search_depth = 0;
35
SELECT @@global.optimizer_search_depth;
36
@@global.optimizer_search_depth
38
SET @@global.optimizer_search_depth = 1;
39
SELECT @@global.optimizer_search_depth;
40
@@global.optimizer_search_depth
42
SET @@global.optimizer_search_depth = 62;
43
SELECT @@global.optimizer_search_depth;
44
@@global.optimizer_search_depth
46
SET @@global.optimizer_search_depth = 63;
47
SELECT @@global.optimizer_search_depth;
48
@@global.optimizer_search_depth
50
'#--------------------FN_DYNVARS_116_04-------------------------#'
51
SET @@session.optimizer_search_depth = 0;
52
SELECT @@session.optimizer_search_depth;
53
@@session.optimizer_search_depth
55
SET @@session.optimizer_search_depth = 1;
56
SELECT @@session.optimizer_search_depth;
57
@@session.optimizer_search_depth
59
SET @@session.optimizer_search_depth = 62;
60
SELECT @@session.optimizer_search_depth;
61
@@session.optimizer_search_depth
63
SET @@session.optimizer_search_depth = 63;
64
SELECT @@session.optimizer_search_depth;
65
@@session.optimizer_search_depth
67
'#------------------FN_DYNVARS_116_05-----------------------#'
68
SET @@global.optimizer_search_depth = 64;
70
Warning 1292 Truncated incorrect optimizer_search_depth value: '64'
71
SELECT @@global.optimizer_search_depth;
72
@@global.optimizer_search_depth
74
SET @@global.optimizer_search_depth = -1;
75
SELECT @@global.optimizer_search_depth;
76
@@global.optimizer_search_depth
78
SET @@global.optimizer_search_depth = 65536;
80
Warning 1292 Truncated incorrect optimizer_search_depth value: '65536'
81
SELECT @@global.optimizer_search_depth;
82
@@global.optimizer_search_depth
84
SET @@global.optimizer_search_depth = 65530.34.;
85
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
86
SELECT @@global.optimizer_search_depth;
87
@@global.optimizer_search_depth
89
SET @@global.optimizer_search_depth = test;
90
ERROR 42000: Incorrect argument type to variable 'optimizer_search_depth'
91
SELECT @@global.optimizer_search_depth;
92
@@global.optimizer_search_depth
94
SET @@session.optimizer_search_depth = 64;
96
Warning 1292 Truncated incorrect optimizer_search_depth value: '64'
97
SELECT @@session.optimizer_search_depth;
98
@@session.optimizer_search_depth
100
SET @@session.optimizer_search_depth = -2;
101
SELECT @@session.optimizer_search_depth;
102
@@session.optimizer_search_depth
104
SET @@session.optimizer_search_depth = 65530.34.;
105
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
106
SET @@session.optimizer_search_depth = 65550;
108
Warning 1292 Truncated incorrect optimizer_search_depth value: '65550'
109
SELECT @@session.optimizer_search_depth;
110
@@session.optimizer_search_depth
112
'Bug # 34837: Errors are not coming on assigning invalid values to variable';
113
SET @@session.optimizer_search_depth = test;
114
ERROR 42000: Incorrect argument type to variable 'optimizer_search_depth'
115
SELECT @@session.optimizer_search_depth;
116
@@session.optimizer_search_depth
118
'#------------------FN_DYNVARS_116_06-----------------------#'
119
SELECT @@global.optimizer_search_depth = VARIABLE_VALUE
120
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
121
WHERE VARIABLE_NAME='optimizer_search_depth';
122
@@global.optimizer_search_depth = VARIABLE_VALUE
124
'#------------------FN_DYNVARS_116_07-----------------------#'
125
SELECT @@session.optimizer_search_depth = VARIABLE_VALUE
126
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
127
WHERE VARIABLE_NAME='optimizer_search_depth';
128
@@session.optimizer_search_depth = VARIABLE_VALUE
130
'#------------------FN_DYNVARS_116_08-----------------------#'
131
SET @@global.optimizer_search_depth = TRUE;
132
SELECT @@global.optimizer_search_depth;
133
@@global.optimizer_search_depth
135
SET @@global.optimizer_search_depth = FALSE;
136
SELECT @@global.optimizer_search_depth;
137
@@global.optimizer_search_depth
139
'#---------------------FN_DYNVARS_116_09----------------------#'
140
SET @@global.optimizer_search_depth = 10;
141
SELECT @@optimizer_search_depth = @@global.optimizer_search_depth;
142
@@optimizer_search_depth = @@global.optimizer_search_depth
144
'#---------------------FN_DYNVARS_116_10----------------------#'
145
SET @@optimizer_search_depth = 10;
146
SELECT @@optimizer_search_depth = @@local.optimizer_search_depth;
147
@@optimizer_search_depth = @@local.optimizer_search_depth
149
SELECT @@local.optimizer_search_depth = @@session.optimizer_search_depth;
150
@@local.optimizer_search_depth = @@session.optimizer_search_depth
152
'#---------------------FN_DYNVARS_116_11----------------------#'
153
SET optimizer_search_depth = 1;
154
SELECT @@optimizer_search_depth;
155
@@optimizer_search_depth
157
SELECT local.optimizer_search_depth;
158
ERROR 42S02: Unknown table 'local' in field list
159
SELECT session.optimizer_search_depth;
160
ERROR 42S02: Unknown table 'session' in field list
161
SELECT optimizer_search_depth = @@session.optimizer_search_depth;
162
ERROR 42S22: Unknown column 'optimizer_search_depth' in 'field list'
163
SET @@global.optimizer_search_depth = @start_global_value;
164
SELECT @@global.optimizer_search_depth;
165
@@global.optimizer_search_depth
167
SET @@session.optimizer_search_depth = @start_session_value;
168
SELECT @@session.optimizer_search_depth;
169
@@session.optimizer_search_depth