1
SET @start_global_value = @@global.max_length_for_sort_data;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.max_length_for_sort_data;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_080_01-------------------------#'
10
SET @@global.max_length_for_sort_data = 1000;
11
SET @@global.max_length_for_sort_data = DEFAULT;
12
SELECT @@global.max_length_for_sort_data;
13
@@global.max_length_for_sort_data
15
SET @@session.max_length_for_sort_data = 1000;
16
SET @@session.max_length_for_sort_data = DEFAULT;
17
SELECT @@session.max_length_for_sort_data;
18
@@session.max_length_for_sort_data
20
'#--------------------FN_DYNVARS_080_02-------------------------#'
21
SET @@global.max_length_for_sort_data = DEFAULT;
22
SELECT @@global.max_length_for_sort_data = 1024;
23
@@global.max_length_for_sort_data = 1024
25
SET @@session.max_length_for_sort_data = DEFAULT;
26
SELECT @@session.max_length_for_sort_data = 1024;
27
@@session.max_length_for_sort_data = 1024
29
'#--------------------FN_DYNVARS_080_03-------------------------#'
30
SET @@global.max_length_for_sort_data = 4;
31
SELECT @@global.max_length_for_sort_data;
32
@@global.max_length_for_sort_data
34
SET @@global.max_length_for_sort_data = 5;
35
SELECT @@global.max_length_for_sort_data;
36
@@global.max_length_for_sort_data
38
SET @@global.max_length_for_sort_data = 8388608;
39
SELECT @@global.max_length_for_sort_data;
40
@@global.max_length_for_sort_data
42
SET @@global.max_length_for_sort_data = 8388607;
43
SELECT @@global.max_length_for_sort_data;
44
@@global.max_length_for_sort_data
46
SET @@global.max_length_for_sort_data = 65536;
47
SELECT @@global.max_length_for_sort_data;
48
@@global.max_length_for_sort_data
50
'#--------------------FN_DYNVARS_080_04-------------------------#'
51
SET @@session.max_length_for_sort_data = 4;
52
SELECT @@session.max_length_for_sort_data;
53
@@session.max_length_for_sort_data
55
SET @@session.max_length_for_sort_data = 5;
56
SELECT @@session.max_length_for_sort_data;
57
@@session.max_length_for_sort_data
59
SET @@session.max_length_for_sort_data = 8388608;
60
SELECT @@session.max_length_for_sort_data;
61
@@session.max_length_for_sort_data
63
SET @@session.max_length_for_sort_data = 8388607;
64
SELECT @@session.max_length_for_sort_data;
65
@@session.max_length_for_sort_data
67
SET @@session.max_length_for_sort_data = 65536;
68
SELECT @@session.max_length_for_sort_data;
69
@@session.max_length_for_sort_data
71
'#------------------FN_DYNVARS_080_05-----------------------#'
72
SET @@global.max_length_for_sort_data = -1024;
74
Warning 1292 Truncated incorrect max_length_for_sort_data value: '0'
75
SELECT @@global.max_length_for_sort_data;
76
@@global.max_length_for_sort_data
78
SET @@global.max_length_for_sort_data = 3;
80
Warning 1292 Truncated incorrect max_length_for_sort_data value: '3'
81
SELECT @@global.max_length_for_sort_data;
82
@@global.max_length_for_sort_data
84
SET @@global.max_length_for_sort_data = 8388609;
86
Warning 1292 Truncated incorrect max_length_for_sort_data value: '8388609'
87
SELECT @@global.max_length_for_sort_data;
88
@@global.max_length_for_sort_data
90
SET @@global.max_length_for_sort_data = 0;
92
Warning 1292 Truncated incorrect max_length_for_sort_data value: '0'
93
SELECT @@global.max_length_for_sort_data;
94
@@global.max_length_for_sort_data
96
SET @@global.max_length_for_sort_data = 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_length_for_sort_data;
99
@@global.max_length_for_sort_data
101
SET @@global.max_length_for_sort_data = test;
102
ERROR 42000: Incorrect argument type to variable 'max_length_for_sort_data'
103
SELECT @@global.max_length_for_sort_data;
104
@@global.max_length_for_sort_data
106
SET @@session.max_length_for_sort_data = 8388610;
108
Warning 1292 Truncated incorrect max_length_for_sort_data value: '8388610'
109
SELECT @@session.max_length_for_sort_data;
110
@@session.max_length_for_sort_data
112
SET @@session.max_length_for_sort_data = -1;
114
Warning 1292 Truncated incorrect max_length_for_sort_data value: '0'
115
SELECT @@session.max_length_for_sort_data;
116
@@session.max_length_for_sort_data
118
SET @@session.max_length_for_sort_data = 3;
120
Warning 1292 Truncated incorrect max_length_for_sort_data value: '3'
121
SELECT @@session.max_length_for_sort_data;
122
@@session.max_length_for_sort_data
124
SET @@session.max_length_for_sort_data = 0;
126
Warning 1292 Truncated incorrect max_length_for_sort_data value: '0'
127
SELECT @@session.max_length_for_sort_data;
128
@@session.max_length_for_sort_data
130
SET @@session.max_length_for_sort_data = 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_length_for_sort_data = 10737418241;
134
Warning 1292 Truncated incorrect max_length_for_sort_data value: '10737418241'
135
SELECT @@session.max_length_for_sort_data;
136
@@session.max_length_for_sort_data
138
SET @@session.max_length_for_sort_data = test;
139
ERROR 42000: Incorrect argument type to variable 'max_length_for_sort_data'
140
SELECT @@session.max_length_for_sort_data;
141
@@session.max_length_for_sort_data
143
'#------------------FN_DYNVARS_080_06-----------------------#'
144
SELECT @@global.max_length_for_sort_data = VARIABLE_VALUE
145
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
146
WHERE VARIABLE_NAME='max_length_for_sort_data';
147
@@global.max_length_for_sort_data = VARIABLE_VALUE
149
'#------------------FN_DYNVARS_080_07-----------------------#'
150
SELECT @@session.max_length_for_sort_data = VARIABLE_VALUE
151
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
152
WHERE VARIABLE_NAME='max_length_for_sort_data';
153
@@session.max_length_for_sort_data = VARIABLE_VALUE
155
'#------------------FN_DYNVARS_080_08-----------------------#'
156
SET @@global.max_length_for_sort_data = TRUE;
158
Warning 1292 Truncated incorrect max_length_for_sort_data value: '1'
159
SELECT @@global.max_length_for_sort_data;
160
@@global.max_length_for_sort_data
162
SET @@global.max_length_for_sort_data = FALSE;
164
Warning 1292 Truncated incorrect max_length_for_sort_data value: '0'
165
SELECT @@global.max_length_for_sort_data;
166
@@global.max_length_for_sort_data
168
'#---------------------FN_DYNVARS_080_09----------------------#'
169
SET @@global.max_length_for_sort_data = 2048;
170
SELECT @@max_length_for_sort_data = @@global.max_length_for_sort_data;
171
@@max_length_for_sort_data = @@global.max_length_for_sort_data
173
'#---------------------FN_DYNVARS_080_10----------------------#'
174
SET @@max_length_for_sort_data = 100000;
175
SELECT @@max_length_for_sort_data = @@local.max_length_for_sort_data;
176
@@max_length_for_sort_data = @@local.max_length_for_sort_data
178
SELECT @@local.max_length_for_sort_data = @@session.max_length_for_sort_data;
179
@@local.max_length_for_sort_data = @@session.max_length_for_sort_data
181
'#---------------------FN_DYNVARS_080_11----------------------#'
182
SET max_length_for_sort_data = 1024;
183
SELECT @@max_length_for_sort_data;
184
@@max_length_for_sort_data
186
SELECT local.max_length_for_sort_data;
187
ERROR 42S02: Unknown table 'local' in field list
188
SELECT session.max_length_for_sort_data;
189
ERROR 42S02: Unknown table 'session' in field list
190
SELECT max_length_for_sort_data = @@session.max_length_for_sort_data;
191
ERROR 42S22: Unknown column 'max_length_for_sort_data' in 'field list'
192
SET @@global.max_length_for_sort_data = @start_global_value;
193
SELECT @@global.max_length_for_sort_data;
194
@@global.max_length_for_sort_data
196
SET @@session.max_length_for_sort_data = @start_session_value;
197
SELECT @@session.max_length_for_sort_data;
198
@@session.max_length_for_sort_data