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;
69
SELECT @@global.myisam_sort_buffer_size ;
70
@@global.myisam_sort_buffer_size
72
SET @@global.myisam_sort_buffer_size = 65530.34.;
73
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
74
SELECT @@global.myisam_sort_buffer_size ;
75
@@global.myisam_sort_buffer_size
77
SET @@global.myisam_sort_buffer_size = test;
78
ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size'
79
SELECT @@global.myisam_sort_buffer_size ;
80
@@global.myisam_sort_buffer_size
82
SET @@global.myisam_sort_buffer_size = "test";
83
ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size'
84
SELECT @@global.myisam_sort_buffer_size ;
85
@@global.myisam_sort_buffer_size
87
SET @@global.myisam_sort_buffer_size = 'test';
88
ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size'
89
SELECT @@global.myisam_sort_buffer_size ;
90
@@global.myisam_sort_buffer_size
92
SET @@global.myisam_sort_buffer_size = ON;
93
ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size'
94
SELECT @@global.myisam_sort_buffer_size ;
95
@@global.myisam_sort_buffer_size
97
SET @@session.myisam_sort_buffer_size = 0;
99
Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '0'
100
SELECT @@session.myisam_sort_buffer_size ;
101
@@session.myisam_sort_buffer_size
103
SET @@session.myisam_sort_buffer_size = -2;
105
Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '0'
106
SELECT @@session.myisam_sort_buffer_size ;
107
@@session.myisam_sort_buffer_size
109
SET @@session.myisam_sort_buffer_size = 65530.34.;
110
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
111
SELECT @@session.myisam_sort_buffer_size ;
112
@@session.myisam_sort_buffer_size
114
SET @@session.myisam_sort_buffer_size = test;
115
ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size'
116
SELECT @@session.myisam_sort_buffer_size ;
117
@@session.myisam_sort_buffer_size
119
SET @@session.myisam_sort_buffer_size = "test";
120
ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size'
121
SELECT @@session.myisam_sort_buffer_size ;
122
@@session.myisam_sort_buffer_size
124
'#------------------FN_DYNVARS_005_06-----------------------#'
125
SELECT @@global.myisam_sort_buffer_size = VARIABLE_VALUE
126
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
127
WHERE VARIABLE_NAME='myisam_sort_buffer_size ';
128
@@global.myisam_sort_buffer_size = VARIABLE_VALUE
130
'#------------------FN_DYNVARS_005_07-----------------------#'
131
SELECT @@session.myisam_sort_buffer_size = VARIABLE_VALUE
132
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
133
WHERE VARIABLE_NAME='myisam_sort_buffer_size ';
134
@@session.myisam_sort_buffer_size = VARIABLE_VALUE
136
'#------------------FN_DYNVARS_005_08-----------------------#'
137
SET @@global.myisam_sort_buffer_size = TRUE;
139
Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '1'
140
SELECT @@global.myisam_sort_buffer_size ;
141
@@global.myisam_sort_buffer_size
143
SET @@global.myisam_sort_buffer_size = FALSE;
145
Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '0'
146
SELECT @@global.myisam_sort_buffer_size ;
147
@@global.myisam_sort_buffer_size
149
'#---------------------FN_DYNVARS_001_09----------------------#'
150
SET @@global.myisam_sort_buffer_size = 10;
151
SELECT @@myisam_sort_buffer_size = @@global.myisam_sort_buffer_size ;
152
@@myisam_sort_buffer_size = @@global.myisam_sort_buffer_size
154
'#---------------------FN_DYNVARS_001_10----------------------#'
155
SET @@myisam_sort_buffer_size = 100;
156
SELECT @@myisam_sort_buffer_size = @@local.myisam_sort_buffer_size ;
157
@@myisam_sort_buffer_size = @@local.myisam_sort_buffer_size
159
SELECT @@local.myisam_sort_buffer_size = @@session.myisam_sort_buffer_size ;
160
@@local.myisam_sort_buffer_size = @@session.myisam_sort_buffer_size
162
'#---------------------FN_DYNVARS_001_11----------------------#'
163
SET myisam_sort_buffer_size = 1;
165
Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '1'
166
SELECT @@myisam_sort_buffer_size ;
167
@@myisam_sort_buffer_size
169
SELECT local.myisam_sort_buffer_size ;
170
ERROR 42S02: Unknown table 'local' in field list
171
SELECT session.myisam_sort_buffer_size ;
172
ERROR 42S02: Unknown table 'session' in field list
173
SELECT myisam_sort_buffer_size = @@session.myisam_sort_buffer_size ;
174
ERROR 42S22: Unknown column 'myisam_sort_buffer_size' in 'field list'
175
SET @@global.myisam_sort_buffer_size = @start_global_value;
176
SELECT @@global.myisam_sort_buffer_size ;
177
@@global.myisam_sort_buffer_size
179
SET @@session.myisam_sort_buffer_size = @start_session_value;
180
SELECT @@session.myisam_sort_buffer_size ;
181
@@session.myisam_sort_buffer_size