Debian Codegraph @

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

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