1
SET @start_global_value = @@global.max_sort_length;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.max_sort_length;
6
SELECT @start_session_value;
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
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
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
25
SET @@session.max_sort_length = DEFAULT;
26
SELECT @@session.max_sort_length = 1024;
27
@@session.max_sort_length = 1024
29
'#--------------------FN_DYNVARS_084_03-------------------------#'
30
SET @@global.max_sort_length = 4;
31
SELECT @@global.max_sort_length;
32
@@global.max_sort_length
34
SET @@global.max_sort_length = 5;
35
SELECT @@global.max_sort_length;
36
@@global.max_sort_length
38
SET @@global.max_sort_length = 8388608;
39
SELECT @@global.max_sort_length;
40
@@global.max_sort_length
42
SET @@global.max_sort_length = 8388607;
43
SELECT @@global.max_sort_length;
44
@@global.max_sort_length
46
SET @@global.max_sort_length = 65536;
47
SELECT @@global.max_sort_length;
48
@@global.max_sort_length
50
'#--------------------FN_DYNVARS_084_04-------------------------#'
51
SET @@session.max_sort_length = 4;
52
SELECT @@session.max_sort_length;
53
@@session.max_sort_length
55
SET @@session.max_sort_length = 5;
56
SELECT @@session.max_sort_length;
57
@@session.max_sort_length
59
SET @@session.max_sort_length = 8388608;
60
SELECT @@session.max_sort_length;
61
@@session.max_sort_length
63
SET @@session.max_sort_length = 8388607;
64
SELECT @@session.max_sort_length;
65
@@session.max_sort_length
67
SET @@session.max_sort_length = 65536;
68
SELECT @@session.max_sort_length;
69
@@session.max_sort_length
71
'#------------------FN_DYNVARS_084_05-----------------------#'
72
SET @@global.max_sort_length = -1024;
74
Warning 1292 Truncated incorrect max_sort_length value: '0'
75
SELECT @@global.max_sort_length;
76
@@global.max_sort_length
78
SET @@global.max_sort_length = 3;
80
Warning 1292 Truncated incorrect max_sort_length value: '3'
81
SELECT @@global.max_sort_length;
82
@@global.max_sort_length
84
SET @@global.max_sort_length = 8388609;
86
Warning 1292 Truncated incorrect max_sort_length value: '8388609'
87
SELECT @@global.max_sort_length;
88
@@global.max_sort_length
90
SET @@global.max_sort_length = 0;
92
Warning 1292 Truncated incorrect max_sort_length value: '0'
93
SELECT @@global.max_sort_length;
94
@@global.max_sort_length
96
SET @@global.max_sort_length = 65530.34.;
97
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1
98
SELECT @@global.max_sort_length;
99
@@global.max_sort_length
101
SET @@global.max_sort_length = test;
102
ERROR 42000: Incorrect argument type to variable 'max_sort_length'
103
SELECT @@global.max_sort_length;
104
@@global.max_sort_length
106
SET @@session.max_sort_length = 8388610;
108
Warning 1292 Truncated incorrect max_sort_length value: '8388610'
109
SELECT @@session.max_sort_length;
110
@@session.max_sort_length
112
SET @@session.max_sort_length = -1;
114
Warning 1292 Truncated incorrect max_sort_length value: '0'
115
SELECT @@session.max_sort_length;
116
@@session.max_sort_length
118
SET @@session.max_sort_length = 3;
120
Warning 1292 Truncated incorrect max_sort_length value: '3'
121
SELECT @@session.max_sort_length;
122
@@session.max_sort_length
124
SET @@session.max_sort_length = 0;
126
Warning 1292 Truncated incorrect max_sort_length value: '0'
127
SELECT @@session.max_sort_length;
128
@@session.max_sort_length
130
SET @@session.max_sort_length = 65530.34.;
131
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1
132
SET @@session.max_sort_length = 10737418241;
134
Warning 1292 Truncated incorrect max_sort_length value: '10737418241'
135
SELECT @@session.max_sort_length;
136
@@session.max_sort_length
138
SET @@session.max_sort_length = test;
139
ERROR 42000: Incorrect argument type to variable 'max_sort_length'
140
SELECT @@session.max_sort_length;
141
@@session.max_sort_length
143
'#------------------FN_DYNVARS_084_06-----------------------#'
144
SELECT @@global.max_sort_length = VARIABLE_VALUE
145
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
146
WHERE VARIABLE_NAME='max_sort_length';
147
@@global.max_sort_length = VARIABLE_VALUE
149
'#------------------FN_DYNVARS_084_07-----------------------#'
150
SELECT @@session.max_sort_length = VARIABLE_VALUE
151
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
152
WHERE VARIABLE_NAME='max_sort_length';
153
@@session.max_sort_length = VARIABLE_VALUE
155
'#------------------FN_DYNVARS_084_08-----------------------#'
156
SET @@global.max_sort_length = TRUE;
158
Warning 1292 Truncated incorrect max_sort_length value: '1'
159
SELECT @@global.max_sort_length;
160
@@global.max_sort_length
162
SET @@global.max_sort_length = FALSE;
164
Warning 1292 Truncated incorrect max_sort_length value: '0'
165
SELECT @@global.max_sort_length;
166
@@global.max_sort_length
168
'#---------------------FN_DYNVARS_084_09----------------------#'
169
SET @@global.max_sort_length = 2048;
170
SELECT @@max_sort_length = @@global.max_sort_length;
171
@@max_sort_length = @@global.max_sort_length
173
'#---------------------FN_DYNVARS_084_10----------------------#'
174
SET @@max_sort_length = 100000;
175
SELECT @@max_sort_length = @@local.max_sort_length;
176
@@max_sort_length = @@local.max_sort_length
178
SELECT @@local.max_sort_length = @@session.max_sort_length;
179
@@local.max_sort_length = @@session.max_sort_length
181
'#---------------------FN_DYNVARS_084_11----------------------#'
182
SET max_sort_length = 1024;
183
SELECT @@max_sort_length;
186
SELECT local.max_sort_length;
187
ERROR 42S02: Unknown table 'local' in field list
188
SELECT session.max_sort_length;
189
ERROR 42S02: Unknown table 'session' in field list
190
SELECT max_sort_length = @@session.max_sort_length;
191
ERROR 42S22: Unknown column 'max_sort_length' in 'field list'
192
SET @@global.max_sort_length = @start_global_value;
193
SELECT @@global.max_sort_length;
194
@@global.max_sort_length
196
SET @@session.max_sort_length = @start_session_value;
197
SELECT @@session.max_sort_length;
198
@@session.max_sort_length