Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.optimizer_search_depth;
2 SELECT @start_global_value;
3 @start_global_value
4 62
5 SET @start_session_value = @@session.optimizer_search_depth;
6 SELECT @start_session_value;
7 @start_session_value
8 62
9 '#--------------------FN_DYNVARS_116_01-------------------------#'
10 SET @@global.optimizer_search_depth = 100;
11 Warnings:
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
16 62
17 SET @@session.optimizer_search_depth = 200;
18 Warnings:
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
23 62
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
28 1
29 SET @@session.optimizer_search_depth = DEFAULT;
30 SELECT @@session.optimizer_search_depth = 62;
31 @@session.optimizer_search_depth = 62
32 1
33 '#--------------------FN_DYNVARS_116_03-------------------------#'
34 SET @@global.optimizer_search_depth = 0;
35 SELECT @@global.optimizer_search_depth;
36 @@global.optimizer_search_depth
37 0
38 SET @@global.optimizer_search_depth = 1;
39 SELECT @@global.optimizer_search_depth;
40 @@global.optimizer_search_depth
41 1
42 SET @@global.optimizer_search_depth = 62;
43 SELECT @@global.optimizer_search_depth;
44 @@global.optimizer_search_depth
45 62
46 '#--------------------FN_DYNVARS_116_04-------------------------#'
47 SET @@session.optimizer_search_depth = 0;
48 SELECT @@session.optimizer_search_depth;
49 @@session.optimizer_search_depth
50 0
51 SET @@session.optimizer_search_depth = 1;
52 SELECT @@session.optimizer_search_depth;
53 @@session.optimizer_search_depth
54 1
55 SET @@session.optimizer_search_depth = 62;
56 SELECT @@session.optimizer_search_depth;
57 @@session.optimizer_search_depth
58 62
59 '#------------------FN_DYNVARS_116_05-----------------------#'
60 SET @@global.optimizer_search_depth = 63;
61 Warnings:
62 Warning 1292 Truncated incorrect optimizer_search_depth value: '63'
63 SELECT @@global.optimizer_search_depth;
64 @@global.optimizer_search_depth
65 62
66 SET @@global.optimizer_search_depth = -1;
67 Warnings:
68 Warning 1292 Truncated incorrect optimizer_search_depth value: '-1'
69 SELECT @@global.optimizer_search_depth;
70 @@global.optimizer_search_depth
71 0
72 SET @@global.optimizer_search_depth = 65536;
73 Warnings:
74 Warning 1292 Truncated incorrect optimizer_search_depth value: '65536'
75 SELECT @@global.optimizer_search_depth;
76 @@global.optimizer_search_depth
77 62
78 SET @@global.optimizer_search_depth = -1024;
79 Warnings:
80 Warning 1292 Truncated incorrect optimizer_search_depth value: '-1024'
81 SELECT @@global.optimizer_search_depth;
82 @@global.optimizer_search_depth
83 0
84 SET @@global.optimizer_search_depth = 65530.34;
85 ERROR 42000: Incorrect argument type to variable 'optimizer_search_depth'
86 SELECT @@global.optimizer_search_depth;
87 @@global.optimizer_search_depth
88 0
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
93 0
94 SET @@global.optimizer_search_depth = ' ';
95 ERROR 42000: Incorrect argument type to variable 'optimizer_search_depth'
96 SELECT @@global.optimizer_search_depth;
97 @@global.optimizer_search_depth
98 0
99 SET @@session.optimizer_search_depth = 64;
100 Warnings:
101 Warning 1292 Truncated incorrect optimizer_search_depth value: '64'
102 SELECT @@session.optimizer_search_depth;
103 @@session.optimizer_search_depth
104 62
105 SET @@session.optimizer_search_depth = -2;
106 Warnings:
107 Warning 1292 Truncated incorrect optimizer_search_depth value: '-2'
108 SELECT @@session.optimizer_search_depth;
109 @@session.optimizer_search_depth
110 0
111 SET @@session.optimizer_search_depth = 65530.34;
112 ERROR 42000: Incorrect argument type to variable 'optimizer_search_depth'
113 SET @@session.optimizer_search_depth = 65550;
114 Warnings:
115 Warning 1292 Truncated incorrect optimizer_search_depth value: '65550'
116 SELECT @@session.optimizer_search_depth;
117 @@session.optimizer_search_depth
118 62
119 SET @@session.optimizer_search_depth = -1024;
120 Warnings:
121 Warning 1292 Truncated incorrect optimizer_search_depth value: '-1024'
122 SELECT @@session.optimizer_search_depth;
123 @@session.optimizer_search_depth
124 0
125 SET @@session.optimizer_search_depth = test;
126 ERROR 42000: Incorrect argument type to variable 'optimizer_search_depth'
127 SELECT @@session.optimizer_search_depth;
128 @@session.optimizer_search_depth
129 0
130 SET @@session.optimizer_search_depth = ' ';
131 ERROR 42000: Incorrect argument type to variable 'optimizer_search_depth'
132 SELECT @@session.optimizer_search_depth;
133 @@session.optimizer_search_depth
134 0
135 '#------------------FN_DYNVARS_116_06-----------------------#'
136 SELECT @@global.optimizer_search_depth = VARIABLE_VALUE
137 FROM performance_schema.global_variables
138 WHERE VARIABLE_NAME='optimizer_search_depth';
139 @@global.optimizer_search_depth = VARIABLE_VALUE
140 1
141 '#------------------FN_DYNVARS_116_07-----------------------#'
142 SELECT @@session.optimizer_search_depth = VARIABLE_VALUE
143 FROM performance_schema.session_variables
144 WHERE VARIABLE_NAME='optimizer_search_depth';
145 @@session.optimizer_search_depth = VARIABLE_VALUE
146 1
147 '#------------------FN_DYNVARS_116_08-----------------------#'
148 SET @@global.optimizer_search_depth = TRUE;
149 SELECT @@global.optimizer_search_depth;
150 @@global.optimizer_search_depth
151 1
152 SET @@global.optimizer_search_depth = FALSE;
153 SELECT @@global.optimizer_search_depth;
154 @@global.optimizer_search_depth
155 0
156 '#---------------------FN_DYNVARS_116_09----------------------#'
157 SET @@global.optimizer_search_depth = 10;
158 SELECT @@optimizer_search_depth = @@global.optimizer_search_depth;
159 @@optimizer_search_depth = @@global.optimizer_search_depth
160 0
161 '#---------------------FN_DYNVARS_116_10----------------------#'
162 SET @@optimizer_search_depth = 10;
163 SELECT @@optimizer_search_depth = @@local.optimizer_search_depth;
164 @@optimizer_search_depth = @@local.optimizer_search_depth
165 1
166 SELECT @@local.optimizer_search_depth = @@session.optimizer_search_depth;
167 @@local.optimizer_search_depth = @@session.optimizer_search_depth
168 1
169 '#---------------------FN_DYNVARS_116_11----------------------#'
170 SET optimizer_search_depth = 1;
171 SELECT @@optimizer_search_depth;
172 @@optimizer_search_depth
173 1
174 SELECT local.optimizer_search_depth;
175 ERROR 42S02: Unknown table 'local' in field list
176 SELECT session.optimizer_search_depth;
177 ERROR 42S02: Unknown table 'session' in field list
178 SELECT optimizer_search_depth = @@session.optimizer_search_depth;
179 ERROR 42S22: Unknown column 'optimizer_search_depth' in 'field list'
180 SET @@global.optimizer_search_depth = @start_global_value;
181 SELECT @@global.optimizer_search_depth;
182 @@global.optimizer_search_depth
183 62
184 SET @@session.optimizer_search_depth = @start_session_value;
185 SELECT @@session.optimizer_search_depth;
186 @@session.optimizer_search_depth
187 62