Debian Codegraph @

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

raw
1 SET @start_value= @@global.max_sort_length;
2 ** creating tables **
3 CREATE TABLE t (id INT AUTO_INCREMENT PRIMARY KEY, c TEXT) CHARSET=latin1;
4 CREATE TABLE t1 (id INT AUTO_INCREMENT PRIMARY KEY, c BLOB) CHARSET=latin1;
5 CREATE TABLE t2 (id INT AUTO_INCREMENT PRIMARY KEY, c TEXT) CHARSET=latin1;
6 '#--------------------FN_DYNVARS_098_01-------------------------#'
7 connect test_con1,localhost,root,,;
8 ** Setting value to 70 and inserting data **
9 SET @@global.max_sort_length = 70;
10 SELECT @@global.max_sort_length;
11 @@global.max_sort_length
12 70
13 INSERT INTO t set c = repeat('x',69);
14 INSERT INTO t set c = concat(repeat('x',68),'r','x');
15 INSERT INTO t set c = concat(repeat('x',68),'s','y');
16 INSERT INTO t set c = concat(repeat('x',68),'g','w');
17 SELECT c from t ORDER BY c, id;
18 c
19 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
20 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
21 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
22 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
23 ** Results should be sorted **
24 SET @@session.max_sort_length = 69;
25 SELECT @@session.max_sort_length;
26 @@session.max_sort_length
27 69
28 INSERT INTO t set c = repeat('x',69);
29 INSERT INTO t set c = concat(repeat('x',68),'r','x');
30 INSERT INTO t set c = concat(repeat('x',68),'s','y');
31 INSERT INTO t set c = concat(repeat('x',68),'g','w');
32 SELECT c from t ORDER BY c, id;
33 c
34 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
35 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
36 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
37 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
38 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
39 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
40 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
41 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
42 Warnings:
43 Warning 4202 6 values were longer than max_sort_length. Sorting used only the first 69 bytes
44 ** Results should be sorted **
45 '#--------------------FN_DYNVARS_098_02-------------------------#'
46 connect test_con2,localhost,root,,;
47 SET @@global.max_sort_length = 70;
48 SELECT @@global.max_sort_length;
49 @@global.max_sort_length
50 70
51 INSERT INTO t set c = repeat('x',69);
52 INSERT INTO t set c = concat(repeat('x',68),'r','x');
53 INSERT INTO t set c = concat(repeat('x',68),'s','y');
54 INSERT INTO t set c = concat(repeat('x',68),'g','w');
55 SELECT c from t ORDER BY c, id;
56 c
57 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
58 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
59 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
60 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
61 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
62 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
63 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
64 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
65 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
66 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
67 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
68 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
69 ** Results should be sorted **
70 SET @@session.max_sort_length = 64;
71 SELECT @@session.max_sort_length;
72 @@session.max_sort_length
73 64
74 INSERT INTO t set c = repeat('x',69);
75 INSERT INTO t set c = concat(repeat('x',68),'r','x');
76 INSERT INTO t set c = concat(repeat('x',68),'s','y');
77 INSERT INTO t set c = concat(repeat('x',68),'g','w');
78 SELECT c from t ORDER BY c, id;
79 c
80 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
81 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
82 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
83 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
84 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
85 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
86 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
87 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
88 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
89 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
90 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
91 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
92 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
93 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
94 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
95 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
96 Warnings:
97 Warning 4202 16 values were longer than max_sort_length. Sorting used only the first 64 bytes
98 ** Results should not be sorted **
99 '#--------------------FN_DYNVARS_098_03-------------------------#'
100 SET max_sort_length=64;
101 INSERT INTO t set c = repeat('x',69);
102 INSERT INTO t set c = concat(repeat('x',68),'r','x');
103 INSERT INTO t set c = concat(repeat('x',68),'s','y');
104 INSERT INTO t set c = concat(repeat('x',68),'g','w');
105 SELECT c from t ORDER BY c, id;
106 c
107 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
108 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
109 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
110 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
111 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
112 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
113 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
114 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
115 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
116 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
117 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
118 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
119 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
120 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
121 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
122 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
123 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
124 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
125 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
126 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
127 Warnings:
128 Warning 4202 20 values were longer than max_sort_length. Sorting used only the first 64 bytes
129 ** Results should not be sorted **
130 RESET QUERY CACHE;
131 '#--------------------FN_DYNVARS_098_04-------------------------#'
132 SET max_sort_length=69;
133 SELECT c from t ORDER BY c, id;
134 c
135 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
136 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
137 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
138 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
139 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
140 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
141 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
142 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
143 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
144 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
145 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
146 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
147 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
148 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
149 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
150 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
151 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
152 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
153 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
154 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
155 Warnings:
156 Warning 4202 15 values were longer than max_sort_length. Sorting used only the first 69 bytes
157 ** Results should be sorted **
158 '#--------------------FN_DYNVARS_098_05-------------------------#'
159 SET max_sort_length=70;
160 SELECT c from t ORDER BY c, id;
161 c
162 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
163 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
164 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
165 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
166 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
167 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
168 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
169 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
170 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
171 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
172 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
173 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
174 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
175 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
176 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
177 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
178 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
179 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
180 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
181 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
182 ** Results should be sorted **
183 '#--------------------FN_DYNVARS_098_06-------------------------#'
184 SET max_sort_length=default;
185 SELECT @@max_sort_length;
186 @@max_sort_length
187 70
188 SELECT c from t ORDER BY c, id;
189 c
190 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
191 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
192 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
193 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
194 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
195 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
196 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
197 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
198 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
199 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
200 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
201 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
202 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
203 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
204 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
205 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
206 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
207 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
208 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
209 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
210 ** Results should be sorted **
211 '#--------------------FN_DYNVARS_098_07-------------------------#'
212 Testing type BLOB
213 SET @@max_sort_length = 70;
214 SELECT @@max_sort_length;
215 @@max_sort_length
216 70
217 INSERT INTO t1 set c = repeat('x',69);
218 INSERT INTO t1 set c = concat(repeat('x',68),'r','x');
219 INSERT INTO t1 set c = concat(repeat('x',68),'s','y');
220 INSERT INTO t1 set c = concat(repeat('x',68),'g','w');
221 SELECT c from t1 ORDER BY c, id DESC;
222 c
223 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
224 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
225 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
226 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
227 Warnings:
228 Warning 4202 4 values were longer than max_sort_length. Sorting used only the first 70 bytes
229 ** Results should be sorted **
230 SET @@session.max_sort_length = 64;
231 SELECT @@session.max_sort_length;
232 @@session.max_sort_length
233 64
234 INSERT INTO t1 set c = repeat('x',69);
235 INSERT INTO t1 set c = concat(repeat('x',68),'r','x');
236 INSERT INTO t1 set c = concat(repeat('x',68),'s','y');
237 INSERT INTO t1 set c = concat(repeat('x',68),'g','w');
238 SELECT c from t1 ORDER BY c, id;
239 c
240 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
241 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
242 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
243 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
244 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
245 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
246 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
247 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
248 Warnings:
249 Warning 4202 8 values were longer than max_sort_length. Sorting used only the first 64 bytes
250 ** Results should not be sorted **
251 '#--------------------FN_DYNVARS_098_08-------------------------#'
252 Testing type CHAR
253 SET @@global.max_sort_length = 70;
254 SELECT @@global.max_sort_length;
255 @@global.max_sort_length
256 70
257 INSERT INTO t2 set c = repeat('x',69);
258 INSERT INTO t2 set c = concat(repeat('x',68),'r','x');
259 INSERT INTO t2 set c = concat(repeat('x',68),'s','y');
260 INSERT INTO t2 set c = concat(repeat('x',68),'g','w');
261 SELECT c from t2 ORDER BY c, id;
262 c
263 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
264 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
265 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
266 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
267 Warnings:
268 Warning 4202 4 values were longer than max_sort_length. Sorting used only the first 64 bytes
269 ** Results should not be sorted **
270 SET @@session.max_sort_length = 64;
271 SELECT @@session.max_sort_length;
272 @@session.max_sort_length
273 64
274 INSERT INTO t2 set c = repeat('x',69);
275 INSERT INTO t2 set c = concat(repeat('x',68),'r','x');
276 INSERT INTO t2 set c = concat(repeat('x',68),'s','y');
277 INSERT INTO t2 set c = concat(repeat('x',68),'g','w');
278 SELECT c from t2 ORDER BY c, id;
279 c
280 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
281 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
282 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
283 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
284 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
285 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxrx
286 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxsy
287 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxgw
288 Warnings:
289 Warning 4202 8 values were longer than max_sort_length. Sorting used only the first 64 bytes
290 ** Results should not be sorted **
291 DROP TABLE t, t1, t2;
292 #
293 # MDEV-27277 Add a warning when max_sort_length is reached
294 #
295 set max_sort_length = 70;
296 # Table having a fixed-length string field
297 create table t1(a char(100));
298 insert into t1 values
299 ('ShortStr1'), ('ShortStr2'),
300 (concat(repeat('Str', 25), 'zzz')), (concat(repeat('Str', 25), 'yyy')),
301 (concat(repeat('Str', 25), 'xxx'));
302 # Strings are not sorted properly due to max_sort_length limitation
303 select a from t1 order by a;
304 a
305 ShortStr1
306 ShortStr2
307 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrzzz
308 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStryyy
309 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrxxx
310 Warnings:
311 Warning 4202 3 values were longer than max_sort_length. Sorting used only the first 70 bytes
312 # Make sure there are warnings when a string function is used:
313 select a from t1 order by coalesce(a);
314 a
315 ShortStr1
316 ShortStr2
317 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrzzz
318 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStryyy
319 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrxxx
320 Warnings:
321 Warning 4202 3 values were longer than max_sort_length. Sorting used only the first 70 bytes
322 select a from t1 order by concat(a, '1');
323 a
324 ShortStr1
325 ShortStr2
326 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrzzz
327 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStryyy
328 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrxxx
329 Warnings:
330 Warning 4202 3 values were longer than max_sort_length. Sorting used only the first 70 bytes
331 select a from t1 order by binary(a);
332 a
333 ShortStr1
334 ShortStr2
335 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrzzz
336 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStryyy
337 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrStrxxx
338 Warnings:
339 Warning 4202 3 values were longer than max_sort_length. Sorting used only the first 70 bytes
340 # Table having a variable-length string field and UTF16 encoding (2 bytes per char):
341 create table t2(a varchar(100)) character set 'utf16';
342 insert into t2 values
343 (concat(repeat('Str', 15), 'zzz')), (concat(repeat('Str', 15), 'yyy')),
344 (concat(repeat('Str', 15), 'xxx')),
345 ('shortString89'),
346 ('shortString51');
347 set max_sort_length = 64;
348 select * from t2 order by a;
349 a
350 shortString51
351 shortString89
352 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStrzzz
353 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStryyy
354 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStrxxx
355 Warnings:
356 Warning 4202 3 values were longer than max_sort_length. Sorting used only the first 64 bytes
357 # Table having text blobs
358 create table t3(a text, b mediumtext, c longtext) character set 'utf16';
359 insert into t3 values
360 (concat(repeat('Text', 20), '999'), concat(repeat('Medium', 15), '99'), concat(repeat('Long', 20), '99')),
361 (concat(repeat('Text', 20), '888'), concat(repeat('Medium', 15), '88'), concat(repeat('Long', 20), '88')),
362 (concat(repeat('Text', 20), '777'), concat(repeat('Medium', 15), '77'), concat(repeat('Long', 20), '77')),
363 ('shortString89', 'short123', 'short456'),
364 ('shortString51', 'short777', 'short897');
365 select * from t3 order by a;
366 a b c
367 shortString51 short777 short897
368 shortString89 short123 short456
369 TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextText999 MediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMedium99 LongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLong99
370 TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextText888 MediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMedium88 LongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLong88
371 TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextText777 MediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMedium77 LongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLong77
372 Warnings:
373 Warning 4202 3 values were longer than max_sort_length. Sorting used only the first 64 bytes
374 select * from t3 order by b desc;
375 a b c
376 shortString51 short777 short897
377 shortString89 short123 short456
378 TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextText999 MediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMedium99 LongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLong99
379 TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextText888 MediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMedium88 LongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLong88
380 TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextText777 MediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMedium77 LongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLong77
381 Warnings:
382 Warning 4202 3 values were longer than max_sort_length. Sorting used only the first 64 bytes
383 select * from t3 order by coalesce(b) desc;
384 a b c
385 shortString51 short777 short897
386 shortString89 short123 short456
387 TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextText999 MediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMedium99 LongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLong99
388 TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextText888 MediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMedium88 LongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLong88
389 TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextText777 MediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMedium77 LongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLong77
390 Warnings:
391 Warning 4202 3 values were longer than max_sort_length. Sorting used only the first 64 bytes
392 select * from t3 order by c;
393 a b c
394 TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextText999 MediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMedium99 LongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLong99
395 TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextText888 MediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMedium88 LongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLong88
396 TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextText777 MediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMedium77 LongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLong77
397 shortString89 short123 short456
398 shortString51 short777 short897
399 Warnings:
400 Warning 4202 3 values were longer than max_sort_length. Sorting used only the first 64 bytes
401 select * from t3 order by c, a desc;
402 a b c
403 TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextText999 MediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMedium99 LongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLong99
404 TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextText888 MediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMedium88 LongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLong88
405 TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextText777 MediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMedium77 LongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLong77
406 shortString89 short123 short456
407 shortString51 short777 short897
408 Warnings:
409 Warning 4202 6 values were longer than max_sort_length. Sorting used only the first 64 bytes
410 # Packing of sort keys will be applied here:
411 select * from t3 order by a, c, b;
412 a b c
413 shortString51 short777 short897
414 shortString89 short123 short456
415 TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextText999 MediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMedium99 LongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLong99
416 TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextText888 MediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMedium88 LongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLong88
417 TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextText777 MediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMedium77 LongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLong77
418 Warnings:
419 Warning 4202 9 values were longer than max_sort_length. Sorting used only the first 64 bytes
420 select * from t3 order by a;
421 a b c
422 shortString51 short777 short897
423 shortString89 short123 short456
424 TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextText999 MediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMedium99 LongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLong99
425 TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextText888 MediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMedium88 LongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLong88
426 TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextText777 MediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMediumMedium77 LongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLongLong77
427 Warnings:
428 Warning 4202 3 values were longer than max_sort_length. Sorting used only the first 64 bytes
429 # Test a prepared statement re-execution (expecting warnings at both executions)
430 prepare stmt from "select * from t2 order by a";
431 execute stmt;
432 a
433 shortString51
434 shortString89
435 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStrzzz
436 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStryyy
437 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStrxxx
438 Warnings:
439 Warning 4202 3 values were longer than max_sort_length. Sorting used only the first 64 bytes
440 execute stmt;
441 a
442 shortString51
443 shortString89
444 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStrzzz
445 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStryyy
446 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStrxxx
447 Warnings:
448 Warning 4202 3 values were longer than max_sort_length. Sorting used only the first 64 bytes
449 # Test a stored procedure
450 create procedure p1() select * from t2 order by a;
451 call p1();
452 a
453 shortString51
454 shortString89
455 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStrzzz
456 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStryyy
457 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStrxxx
458 Warnings:
459 Warning 4202 3 values were longer than max_sort_length. Sorting used only the first 64 bytes
460 call p1();
461 a
462 shortString51
463 shortString89
464 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStrzzz
465 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStryyy
466 StrStrStrStrStrStrStrStrStrStrStrStrStrStrStrxxx
467 Warnings:
468 Warning 4202 3 values were longer than max_sort_length. Sorting used only the first 64 bytes
469 drop procedure p1;
470 # Test a stored function
471 create function f1 () returns char(100) return (select a from t1 order by a limit 1);
472 select f1() as f1_res from t1 order by f1_res;
473 f1_res
474 ShortStr1
475 ShortStr1
476 ShortStr1
477 ShortStr1
478 ShortStr1
479 Warnings:
480 Warning 4202 15 values were longer than max_sort_length. Sorting used only the first 64 bytes
481 # Test a view
482 create view v1 as select f1() as f1_res from t1 order by f1_res;
483 select * from v1;
484 f1_res
485 ShortStr1
486 ShortStr1
487 ShortStr1
488 ShortStr1
489 ShortStr1
490 Warnings:
491 Warning 4202 30 values were longer than max_sort_length. Sorting used only the first 64 bytes
492 drop function f1;
493 drop view v1;
494 drop table t1, t2, t3;
495 set max_sort_length = default;
496 #
497 # MDEV-35275 Unexpected WARN_SORTING_ON_TRUNCATED_LENGTH or assertion
498 # failure in diagnostics area
499 #
500 create table t1 (a int, b varchar(1024));
501 insert into t1 values (1,repeat('x',513)), (2,repeat('y',650));
502 insert into t1 select * from t1 order by b limit 1;
503 Warnings:
504 Warning 4202 2 values were longer than max_sort_length. Sorting used only the first 70 bytes
505 update t1 set a = 3 order by b limit 1;
506 Warnings:
507 Warning 4202 3 values were longer than max_sort_length. Sorting used only the first 70 bytes
508 delete from t1 where a < 3 order by b;
509 Warnings:
510 Warning 4202 2 values were longer than max_sort_length. Sorting used only the first 70 bytes
511 # Make sure warnings from previous statements do not overflow to next ones
512 select a from t1;
513 a
514 3
515 drop table t1;
516 #
517 # MDEV-35307 Unexpected WARN_SORTING_ON_TRUNCATED_LENGTH or assertion
518 # failure in diagnostics area #2
519 #
520 create table t1 (a varchar(1024)) engine=innodb;
521 insert into t1 values (repeat('a',1000)),(repeat('b',1000));
522 insert into t1 (a) select a from t1 order by a;
523 Warnings:
524 Warning 4202 2 values were longer than max_sort_length. Sorting used only the first 70 bytes
525 drop table t1;
526 connection default;
527 disconnect test_con1;
528 disconnect test_con2;
529 SET @@global.max_sort_length= @start_value;