1
SET @start_global_value = @@global.myisam_sort_buffer_size ;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.myisam_sort_buffer_size ;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_005_01-------------------------#'
10
SET @@global.myisam_sort_buffer_size = 100;
11
SET @@global.myisam_sort_buffer_size = DEFAULT;
12
SELECT @@global.myisam_sort_buffer_size ;
13
@@global.myisam_sort_buffer_size
15
SET @@session.myisam_sort_buffer_size = 200;
16
SET @@session.myisam_sort_buffer_size = DEFAULT;
17
SELECT @@session.myisam_sort_buffer_size ;
18
@@session.myisam_sort_buffer_size
20
'#--------------------FN_DYNVARS_005_02-------------------------#'
21
SET @@global.myisam_sort_buffer_size = DEFAULT;
22
SELECT @@global.myisam_sort_buffer_size = 8388608;
23
@@global.myisam_sort_buffer_size = 8388608
25
SET @@session.myisam_sort_buffer_size = DEFAULT;
26
SELECT @@session.myisam_sort_buffer_size = 8388608;
27
@@session.myisam_sort_buffer_size = 8388608
29
'#--------------------FN_DYNVARS_005_03-------------------------#'
30
SET @@global.myisam_sort_buffer_size = 4;
31
SELECT @@global.myisam_sort_buffer_size ;
32
@@global.myisam_sort_buffer_size
34
SET @@global.myisam_sort_buffer_size = 4294967295;
35
SELECT @@global.myisam_sort_buffer_size ;
36
@@global.myisam_sort_buffer_size
38
SET @@global.myisam_sort_buffer_size = 655354;
39
SELECT @@global.myisam_sort_buffer_size ;
40
@@global.myisam_sort_buffer_size
42
'#--------------------FN_DYNVARS_005_04-------------------------#'
43
SET @@session.myisam_sort_buffer_size = 4;
44
SELECT @@session.myisam_sort_buffer_size ;
45
@@session.myisam_sort_buffer_size
47
SET @@session.myisam_sort_buffer_size = 4294967295;
48
SELECT @@session.myisam_sort_buffer_size ;
49
@@session.myisam_sort_buffer_size
51
SET @@session.myisam_sort_buffer_size = 655345;
52
SELECT @@session.myisam_sort_buffer_size ;
53
@@session.myisam_sort_buffer_size
55
'#------------------FN_DYNVARS_005_05-----------------------#'
56
SET @@global.myisam_sort_buffer_size = 0;
58
Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '0'
59
SELECT @@global.myisam_sort_buffer_size ;
60
@@global.myisam_sort_buffer_size
62
SET @@global.myisam_sort_buffer_size = -1024;
64
Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '0'
65
SELECT @@global.myisam_sort_buffer_size ;
66
@@global.myisam_sort_buffer_size
68
SET @@global.myisam_sort_buffer_size = 429496729533;
70
Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '429496729533'
71
SELECT @@global.myisam_sort_buffer_size ;
72
@@global.myisam_sort_buffer_size
74
SET @@global.myisam_sort_buffer_size = 65530.34.;
75
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
76
SELECT @@global.myisam_sort_buffer_size ;
77
@@global.myisam_sort_buffer_size
79
SET @@global.myisam_sort_buffer_size = test;
80
ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size'
81
SELECT @@global.myisam_sort_buffer_size ;
82
@@global.myisam_sort_buffer_size
84
SET @@global.myisam_sort_buffer_size = "test";
85
ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size'
86
SELECT @@global.myisam_sort_buffer_size ;
87
@@global.myisam_sort_buffer_size
89
SET @@global.myisam_sort_buffer_size = 'test';
90
ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size'
91
SELECT @@global.myisam_sort_buffer_size ;
92
@@global.myisam_sort_buffer_size
94
SET @@global.myisam_sort_buffer_size = ON;
95
ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size'
96
SELECT @@global.myisam_sort_buffer_size ;
97
@@global.myisam_sort_buffer_size
99
SET @@session.myisam_sort_buffer_size = 0;
101
Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '0'
102
SELECT @@session.myisam_sort_buffer_size ;
103
@@session.myisam_sort_buffer_size
105
SET @@session.myisam_sort_buffer_size = -2;
107
Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '0'
108
SELECT @@session.myisam_sort_buffer_size ;
109
@@session.myisam_sort_buffer_size
111
SET @@session.myisam_sort_buffer_size = 65530.34.;
112
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
113
SELECT @@session.myisam_sort_buffer_size ;
114
@@session.myisam_sort_buffer_size
116
SET @@session.myisam_sort_buffer_size = test;
117
ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size'
118
SELECT @@session.myisam_sort_buffer_size ;
119
@@session.myisam_sort_buffer_size
121
SET @@session.myisam_sort_buffer_size = "test";
122
ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size'
123
SELECT @@session.myisam_sort_buffer_size ;
124
@@session.myisam_sort_buffer_size
126
'#------------------FN_DYNVARS_005_06-----------------------#'
127
SELECT @@global.myisam_sort_buffer_size = VARIABLE_VALUE
128
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
129
WHERE VARIABLE_NAME='myisam_sort_buffer_size ';
130
@@global.myisam_sort_buffer_size = VARIABLE_VALUE
132
'#------------------FN_DYNVARS_005_07-----------------------#'
133
SELECT @@session.myisam_sort_buffer_size = VARIABLE_VALUE
134
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
135
WHERE VARIABLE_NAME='myisam_sort_buffer_size ';
136
@@session.myisam_sort_buffer_size = VARIABLE_VALUE
138
'#------------------FN_DYNVARS_005_08-----------------------#'
139
SET @@global.myisam_sort_buffer_size = TRUE;
141
Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '1'
142
SELECT @@global.myisam_sort_buffer_size ;
143
@@global.myisam_sort_buffer_size
145
SET @@global.myisam_sort_buffer_size = FALSE;
147
Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '0'
148
SELECT @@global.myisam_sort_buffer_size ;
149
@@global.myisam_sort_buffer_size
151
'#---------------------FN_DYNVARS_001_09----------------------#'
152
SET @@global.myisam_sort_buffer_size = 10;
153
SELECT @@myisam_sort_buffer_size = @@global.myisam_sort_buffer_size ;
154
@@myisam_sort_buffer_size = @@global.myisam_sort_buffer_size
156
'#---------------------FN_DYNVARS_001_10----------------------#'
157
SET @@myisam_sort_buffer_size = 100;
158
SELECT @@myisam_sort_buffer_size = @@local.myisam_sort_buffer_size ;
159
@@myisam_sort_buffer_size = @@local.myisam_sort_buffer_size
161
SELECT @@local.myisam_sort_buffer_size = @@session.myisam_sort_buffer_size ;
162
@@local.myisam_sort_buffer_size = @@session.myisam_sort_buffer_size
164
'#---------------------FN_DYNVARS_001_11----------------------#'
165
SET myisam_sort_buffer_size = 1;
167
Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '1'
168
SELECT @@myisam_sort_buffer_size ;
169
@@myisam_sort_buffer_size
171
SELECT local.myisam_sort_buffer_size ;
172
ERROR 42S02: Unknown table 'local' in field list
173
SELECT session.myisam_sort_buffer_size ;
174
ERROR 42S02: Unknown table 'session' in field list
175
SELECT myisam_sort_buffer_size = @@session.myisam_sort_buffer_size ;
176
ERROR 42S22: Unknown column 'myisam_sort_buffer_size' in 'field list'
177
SET @@global.myisam_sort_buffer_size = @start_global_value;
178
SELECT @@global.myisam_sort_buffer_size ;
179
@@global.myisam_sort_buffer_size
181
SET @@session.myisam_sort_buffer_size = @start_session_value;
182
SELECT @@session.myisam_sort_buffer_size ;
183
@@session.myisam_sort_buffer_size