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 SET @@global.optimizer_search_depth = 63;
47 Warnings:
48 Warning 1292 Truncated incorrect optimizer_search_depth value: '63'
49 SELECT @@global.optimizer_search_depth;
50 @@global.optimizer_search_depth
51 62
52 '#--------------------FN_DYNVARS_116_04-------------------------#'
53 SET @@session.optimizer_search_depth = 0;
54 SELECT @@session.optimizer_search_depth;
55 @@session.optimizer_search_depth
56 0
57 SET @@session.optimizer_search_depth = 1;
58 SELECT @@session.optimizer_search_depth;
59 @@session.optimizer_search_depth
60 1
61 SET @@session.optimizer_search_depth = 62;
62 SELECT @@session.optimizer_search_depth;
63 @@session.optimizer_search_depth
64 62
65 SET @@session.optimizer_search_depth = 63;
66 Warnings:
67 Warning 1292 Truncated incorrect optimizer_search_depth value: '63'
68 SELECT @@session.optimizer_search_depth;
69 @@session.optimizer_search_depth
70 62
71 '#------------------FN_DYNVARS_116_05-----------------------#'
72 SET @@global.optimizer_search_depth = 64;
73 Warnings:
74 Warning 1292 Truncated incorrect optimizer_search_depth value: '64'
75 SELECT @@global.optimizer_search_depth;
76 @@global.optimizer_search_depth
77 62
78 SET @@global.optimizer_search_depth = -1;
79 Warnings:
80 Warning 1292 Truncated incorrect optimizer_search_depth value: '-1'
81 SELECT @@global.optimizer_search_depth;
82 @@global.optimizer_search_depth
83 0
84 SET @@global.optimizer_search_depth = 65536;
85 Warnings:
86 Warning 1292 Truncated incorrect optimizer_search_depth value: '65536'
87 SELECT @@global.optimizer_search_depth;
88 @@global.optimizer_search_depth
89 62
90 SET @@global.optimizer_search_depth = 65530.34;
91 ERROR 42000: Incorrect argument type to variable 'optimizer_search_depth'
92 SELECT @@global.optimizer_search_depth;
93 @@global.optimizer_search_depth
94 62
95 SET @@global.optimizer_search_depth = test;
96 ERROR 42000: Incorrect argument type to variable 'optimizer_search_depth'
97 SELECT @@global.optimizer_search_depth;
98 @@global.optimizer_search_depth
99 62
100 SET @@session.optimizer_search_depth = 64;
101 Warnings:
102 Warning 1292 Truncated incorrect optimizer_search_depth value: '64'
103 SELECT @@session.optimizer_search_depth;
104 @@session.optimizer_search_depth
105 62
106 SET @@session.optimizer_search_depth = -2;
107 Warnings:
108 Warning 1292 Truncated incorrect optimizer_search_depth value: '-2'
109 SELECT @@session.optimizer_search_depth;
110 @@session.optimizer_search_depth
111 0
112 SET @@session.optimizer_search_depth = 65530.34;
113 ERROR 42000: Incorrect argument type to variable 'optimizer_search_depth'
114 SET @@session.optimizer_search_depth = 65550;
115 Warnings:
116 Warning 1292 Truncated incorrect optimizer_search_depth value: '65550'
117 SELECT @@session.optimizer_search_depth;
118 @@session.optimizer_search_depth
119 62
120 SET @@session.optimizer_search_depth = test;
121 ERROR 42000: Incorrect argument type to variable 'optimizer_search_depth'
122 SELECT @@session.optimizer_search_depth;
123 @@session.optimizer_search_depth
124 62
125 '#------------------FN_DYNVARS_116_06-----------------------#'
126 SELECT @@global.optimizer_search_depth = VARIABLE_VALUE
127 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
128 WHERE VARIABLE_NAME='optimizer_search_depth';
129 @@global.optimizer_search_depth = VARIABLE_VALUE
130 1
131 '#------------------FN_DYNVARS_116_07-----------------------#'
132 SELECT @@session.optimizer_search_depth = VARIABLE_VALUE
133 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
134 WHERE VARIABLE_NAME='optimizer_search_depth';
135 @@session.optimizer_search_depth = VARIABLE_VALUE
136 1
137 '#------------------FN_DYNVARS_116_08-----------------------#'
138 SET @@global.optimizer_search_depth = TRUE;
139 SELECT @@global.optimizer_search_depth;
140 @@global.optimizer_search_depth
141 1
142 SET @@global.optimizer_search_depth = FALSE;
143 SELECT @@global.optimizer_search_depth;
144 @@global.optimizer_search_depth
145 0
146 '#---------------------FN_DYNVARS_116_09----------------------#'
147 SET @@global.optimizer_search_depth = 10;
148 SELECT @@optimizer_search_depth = @@global.optimizer_search_depth;
149 @@optimizer_search_depth = @@global.optimizer_search_depth
150 0
151 '#---------------------FN_DYNVARS_116_10----------------------#'
152 SET @@optimizer_search_depth = 10;
153 SELECT @@optimizer_search_depth = @@local.optimizer_search_depth;
154 @@optimizer_search_depth = @@local.optimizer_search_depth
155 1
156 SELECT @@local.optimizer_search_depth = @@session.optimizer_search_depth;
157 @@local.optimizer_search_depth = @@session.optimizer_search_depth
158 1
159 '#---------------------FN_DYNVARS_116_11----------------------#'
160 SET optimizer_search_depth = 1;
161 SELECT @@optimizer_search_depth;
162 @@optimizer_search_depth
163 1
164 SELECT local.optimizer_search_depth;
165 ERROR 42S02: Unknown table 'local' in SELECT
166 SELECT session.optimizer_search_depth;
167 ERROR 42S02: Unknown table 'session' in SELECT
168 SELECT optimizer_search_depth = @@session.optimizer_search_depth;
169 ERROR 42S22: Unknown column 'optimizer_search_depth' in 'SELECT'
170 SET @@global.optimizer_search_depth = @start_global_value;
171 SELECT @@global.optimizer_search_depth;
172 @@global.optimizer_search_depth
173 62
174 SET @@session.optimizer_search_depth = @start_session_value;
175 SELECT @@session.optimizer_search_depth;
176 @@session.optimizer_search_depth
177 62