Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.query_prealloc_size ;
2 Warnings:
3 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
4 SELECT @start_global_value;
5 @start_global_value
6 8192
7 SET @start_session_value = @@session.query_prealloc_size ;
8 Warnings:
9 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
10 SELECT @start_session_value;
11 @start_session_value
12 8192
13 '#--------------------FN_DYNVARS_005_01-------------------------#'
14 SET @@global.query_prealloc_size = 100;
15 Warnings:
16 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
17 Warning 1292 Truncated incorrect query_prealloc_size value: '100'
18 SET @@global.query_prealloc_size = DEFAULT;
19 Warnings:
20 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
21 SELECT @@global.query_prealloc_size ;
22 @@global.query_prealloc_size
23 8192
24 Warnings:
25 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
26 SET @@session.query_prealloc_size = 200;
27 Warnings:
28 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
29 Warning 1292 Truncated incorrect query_prealloc_size value: '200'
30 SET @@session.query_prealloc_size = DEFAULT;
31 Warnings:
32 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
33 SELECT @@session.query_prealloc_size ;
34 @@session.query_prealloc_size
35 8192
36 Warnings:
37 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
38 '#--------------------FN_DYNVARS_005_02-------------------------#'
39 SET @@global.query_prealloc_size = DEFAULT;
40 Warnings:
41 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
42 SELECT @@global.query_prealloc_size = 8192;
43 @@global.query_prealloc_size = 8192
44 1
45 Warnings:
46 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
47 SET @@session.query_prealloc_size = DEFAULT;
48 Warnings:
49 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
50 SELECT @@session.query_prealloc_size = 8192;
51 @@session.query_prealloc_size = 8192
52 1
53 Warnings:
54 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
55 '#--------------------FN_DYNVARS_005_03-------------------------#'
56 SET @@global.query_prealloc_size = 8192;
57 Warnings:
58 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
59 SELECT @@global.query_prealloc_size ;
60 @@global.query_prealloc_size
61 8192
62 Warnings:
63 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
64 SET @@global.query_prealloc_size = 655354;
65 Warnings:
66 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
67 Warning 1292 Truncated incorrect query_prealloc_size value: '655354'
68 SELECT @@global.query_prealloc_size ;
69 @@global.query_prealloc_size
70 654336
71 Warnings:
72 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
73 '#--------------------FN_DYNVARS_005_04-------------------------#'
74 SET @@session.query_prealloc_size = 8192;
75 Warnings:
76 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
77 SELECT @@session.query_prealloc_size ;
78 @@session.query_prealloc_size
79 8192
80 Warnings:
81 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
82 SET @@session.query_prealloc_size = 655345;
83 Warnings:
84 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
85 Warning 1292 Truncated incorrect query_prealloc_size value: '655345'
86 SELECT @@session.query_prealloc_size ;
87 @@session.query_prealloc_size
88 654336
89 Warnings:
90 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
91 '#------------------FN_DYNVARS_005_05-----------------------#'
92 SET @@global.query_prealloc_size = 0;
93 Warnings:
94 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
95 Warning 1292 Truncated incorrect query_prealloc_size value: '0'
96 SELECT @@global.query_prealloc_size ;
97 @@global.query_prealloc_size
98 8192
99 Warnings:
100 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
101 SET @@global.query_prealloc_size = -1024;
102 Warnings:
103 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
104 Warning 1292 Truncated incorrect query_prealloc_size value: '-1024'
105 SELECT @@global.query_prealloc_size ;
106 @@global.query_prealloc_size
107 8192
108 Warnings:
109 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
110 SET @@global.query_prealloc_size = 65530.34;
111 ERROR 42000: Incorrect argument type to variable 'query_prealloc_size'
112 SET @@global.query_prealloc_size = test;
113 ERROR 42000: Incorrect argument type to variable 'query_prealloc_size'
114 SET @@global.query_prealloc_size = "test";
115 ERROR 42000: Incorrect argument type to variable 'query_prealloc_size'
116 SET @@global.query_prealloc_size = 'test';
117 ERROR 42000: Incorrect argument type to variable 'query_prealloc_size'
118 SET @@global.query_prealloc_size = ' ';
119 ERROR 42000: Incorrect argument type to variable 'query_prealloc_size'
120 SET @@global.query_prealloc_size = ON;
121 ERROR 42000: Incorrect argument type to variable 'query_prealloc_size'
122 SET @@session.query_prealloc_size = 0;
123 Warnings:
124 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
125 Warning 1292 Truncated incorrect query_prealloc_size value: '0'
126 SELECT @@session.query_prealloc_size ;
127 @@session.query_prealloc_size
128 8192
129 Warnings:
130 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
131 SET @@session.query_prealloc_size = -2;
132 Warnings:
133 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
134 Warning 1292 Truncated incorrect query_prealloc_size value: '-2'
135 SELECT @@session.query_prealloc_size ;
136 @@session.query_prealloc_size
137 8192
138 Warnings:
139 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
140 SET @@session.query_prealloc_size = 65530.34;
141 ERROR 42000: Incorrect argument type to variable 'query_prealloc_size'
142 SET @@session.query_prealloc_size = test;
143 ERROR 42000: Incorrect argument type to variable 'query_prealloc_size'
144 SET @@session.query_prealloc_size = "test";
145 ERROR 42000: Incorrect argument type to variable 'query_prealloc_size'
146 SET @@session.query_prealloc_size = " ";
147 ERROR 42000: Incorrect argument type to variable 'query_prealloc_size'
148 '#------------------FN_DYNVARS_005_06-----------------------#'
149 SELECT @@global.query_prealloc_size = VARIABLE_VALUE
150 FROM performance_schema.global_variables
151 WHERE VARIABLE_NAME='query_prealloc_size';
152 @@global.query_prealloc_size = VARIABLE_VALUE
153 1
154 '#------------------FN_DYNVARS_005_07-----------------------#'
155 SELECT @@session.query_prealloc_size = VARIABLE_VALUE
156 FROM performance_schema.session_variables
157 WHERE VARIABLE_NAME='query_prealloc_size';
158 @@session.query_prealloc_size = VARIABLE_VALUE
159 1
160 '#------------------FN_DYNVARS_005_08-----------------------#'
161 SET @@global.query_prealloc_size = TRUE;
162 Warnings:
163 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
164 Warning 1292 Truncated incorrect query_prealloc_size value: '1'
165 SELECT @@global.query_prealloc_size ;
166 @@global.query_prealloc_size
167 8192
168 Warnings:
169 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
170 SET @@global.query_prealloc_size = FALSE;
171 Warnings:
172 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
173 Warning 1292 Truncated incorrect query_prealloc_size value: '0'
174 SELECT @@global.query_prealloc_size ;
175 @@global.query_prealloc_size
176 8192
177 Warnings:
178 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
179 '#---------------------FN_DYNVARS_005_09----------------------#'
180 SET @@global.query_prealloc_size = 10;
181 Warnings:
182 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
183 Warning 1292 Truncated incorrect query_prealloc_size value: '10'
184 SELECT @@query_prealloc_size = @@global.query_prealloc_size ;
185 @@query_prealloc_size = @@global.query_prealloc_size
186 1
187 Warnings:
188 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
189 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
190 '#---------------------FN_DYNVARS_001_10----------------------#'
191 SET @@query_prealloc_size = 100;
192 Warnings:
193 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
194 Warning 1292 Truncated incorrect query_prealloc_size value: '100'
195 SELECT @@query_prealloc_size = @@local.query_prealloc_size ;
196 @@query_prealloc_size = @@local.query_prealloc_size
197 1
198 Warnings:
199 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
200 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
201 SELECT @@local.query_prealloc_size = @@session.query_prealloc_size ;
202 @@local.query_prealloc_size = @@session.query_prealloc_size
203 1
204 Warnings:
205 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
206 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
207 '#---------------------FN_DYNVARS_001_11----------------------#'
208 SET query_prealloc_size = 1;
209 Warnings:
210 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
211 Warning 1292 Truncated incorrect query_prealloc_size value: '1'
212 SELECT @@query_prealloc_size ;
213 @@query_prealloc_size
214 8192
215 Warnings:
216 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
217 SELECT local.query_prealloc_size ;
218 ERROR 42S02: Unknown table 'local' in field list
219 SELECT session.query_prealloc_size ;
220 ERROR 42S02: Unknown table 'session' in field list
221 SELECT query_prealloc_size = @@session.query_prealloc_size ;
222 ERROR 42S22: Unknown column 'query_prealloc_size' in 'field list'
223 SET @@global.query_prealloc_size = @start_global_value;
224 Warnings:
225 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
226 SELECT @@global.query_prealloc_size ;
227 @@global.query_prealloc_size
228 8192
229 Warnings:
230 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
231 SET @@session.query_prealloc_size = @start_session_value;
232 Warnings:
233 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.
234 SELECT @@session.query_prealloc_size ;
235 @@session.query_prealloc_size
236 8192
237 Warnings:
238 Warning 1287 '@@query_prealloc_size' is deprecated and will be removed in a future release.