1
SET @start_global_value = @@global.query_alloc_block_size;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.query_alloc_block_size;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_130_01-------------------------#'
10
SET @@global.query_alloc_block_size = 10000;
12
Warning 1292 Truncated incorrect query_alloc_block_size value: '10000'
13
SET @@global.query_alloc_block_size = DEFAULT;
14
SELECT @@global.query_alloc_block_size;
15
@@global.query_alloc_block_size
17
SET @@session.query_alloc_block_size = 20000;
19
Warning 1292 Truncated incorrect query_alloc_block_size value: '20000'
20
SET @@session.query_alloc_block_size = DEFAULT;
21
SELECT @@session.query_alloc_block_size;
22
@@session.query_alloc_block_size
24
'#--------------------FN_DYNVARS_130_02-------------------------#'
25
SET @@global.query_alloc_block_size = DEFAULT;
26
SELECT @@global.query_alloc_block_size = 8192;
27
@@global.query_alloc_block_size = 8192
29
SET @@session.query_alloc_block_size = DEFAULT;
30
SELECT @@session.query_alloc_block_size = 8192;
31
@@session.query_alloc_block_size = 8192
33
'#--------------------FN_DYNVARS_130_03-------------------------#'
34
SET @@global.query_alloc_block_size = 1024;
35
SELECT @@global.query_alloc_block_size;
36
@@global.query_alloc_block_size
38
SET @@global.query_alloc_block_size = 1025;
40
Warning 1292 Truncated incorrect query_alloc_block_size value: '1025'
41
SELECT @@global.query_alloc_block_size;
42
@@global.query_alloc_block_size
44
SET @@global.query_alloc_block_size = 4294967295;
46
Warning 1292 Truncated incorrect query_alloc_block_size value: '4294967295'
47
SELECT @@global.query_alloc_block_size;
48
@@global.query_alloc_block_size
50
SET @@global.query_alloc_block_size = 4294967294;
52
Warning 1292 Truncated incorrect query_alloc_block_size value: '4294967294'
53
SELECT @@global.query_alloc_block_size;
54
@@global.query_alloc_block_size
56
SET @@global.query_alloc_block_size = 65536;
57
SELECT @@global.query_alloc_block_size;
58
@@global.query_alloc_block_size
60
'#--------------------FN_DYNVARS_130_04-------------------------#'
61
SET @@session.query_alloc_block_size = 1024;
62
SELECT @@session.query_alloc_block_size;
63
@@session.query_alloc_block_size
65
SET @@session.query_alloc_block_size = 1025;
67
Warning 1292 Truncated incorrect query_alloc_block_size value: '1025'
68
SELECT @@session.query_alloc_block_size;
69
@@session.query_alloc_block_size
71
SET @@session.query_alloc_block_size = 4294967295;
73
Warning 1292 Truncated incorrect query_alloc_block_size value: '4294967295'
74
SELECT @@session.query_alloc_block_size;
75
@@session.query_alloc_block_size
77
SET @@session.query_alloc_block_size = 4294967294;
79
Warning 1292 Truncated incorrect query_alloc_block_size value: '4294967294'
80
SELECT @@session.query_alloc_block_size;
81
@@session.query_alloc_block_size
83
SET @@session.query_alloc_block_size = 655536;
85
Warning 1292 Truncated incorrect query_alloc_block_size value: '655536'
86
SELECT @@session.query_alloc_block_size;
87
@@session.query_alloc_block_size
89
'#------------------FN_DYNVARS_130_05-----------------------#'
90
SET @@global.query_alloc_block_size = 64;
92
Warning 1292 Truncated incorrect query_alloc_block_size value: '64'
93
SELECT @@global.query_alloc_block_size;
94
@@global.query_alloc_block_size
96
SET @@global.query_alloc_block_size = -1;
98
Warning 1292 Truncated incorrect query_alloc_block_size value: '-1'
99
SELECT @@global.query_alloc_block_size;
100
@@global.query_alloc_block_size
102
SET @@global.query_alloc_block_size = 1023;
104
Warning 1292 Truncated incorrect query_alloc_block_size value: '1023'
105
SELECT @@global.query_alloc_block_size;
106
@@global.query_alloc_block_size
108
SET @@global.query_alloc_block_size = 4294967296;
109
SELECT @@global.query_alloc_block_size;
110
@@global.query_alloc_block_size
112
SET @@global.query_alloc_block_size = 65530.34;
113
ERROR 42000: Incorrect argument type to variable 'query_alloc_block_size'
114
SELECT @@global.query_alloc_block_size;
115
@@global.query_alloc_block_size
117
SET @@global.query_alloc_block_size = test;
118
ERROR 42000: Incorrect argument type to variable 'query_alloc_block_size'
119
SELECT @@global.query_alloc_block_size;
120
@@global.query_alloc_block_size
122
SET @@session.query_alloc_block_size = 64;
124
Warning 1292 Truncated incorrect query_alloc_block_size value: '64'
125
SELECT @@session.query_alloc_block_size;
126
@@session.query_alloc_block_size
128
SET @@session.query_alloc_block_size = -2;
130
Warning 1292 Truncated incorrect query_alloc_block_size value: '-2'
131
SELECT @@session.query_alloc_block_size;
132
@@session.query_alloc_block_size
134
SET @@session.query_alloc_block_size = 65530.34;
135
ERROR 42000: Incorrect argument type to variable 'query_alloc_block_size'
136
SET @@session.query_alloc_block_size = 1023;
138
Warning 1292 Truncated incorrect query_alloc_block_size value: '1023'
139
SELECT @@session.query_alloc_block_size;
140
@@session.query_alloc_block_size
142
SET @@session.query_alloc_block_size = test;
143
ERROR 42000: Incorrect argument type to variable 'query_alloc_block_size'
144
SELECT @@session.query_alloc_block_size;
145
@@session.query_alloc_block_size
147
'#------------------FN_DYNVARS_130_06-----------------------#'
148
SET @@global.query_alloc_block_size = 1;
150
Warning 1292 Truncated incorrect query_alloc_block_size value: '1'
151
SET @@session.query_alloc_block_size = 12;
153
Warning 1292 Truncated incorrect query_alloc_block_size value: '12'
154
SELECT @@global.query_alloc_block_size =
155
VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
156
WHERE VARIABLE_NAME='query_alloc_block_size';
157
@@global.query_alloc_block_size =
160
'#------------------FN_DYNVARS_130_07-----------------------#'
161
SELECT @@session.query_alloc_block_size = VARIABLE_VALUE
162
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
163
WHERE VARIABLE_NAME='query_alloc_block_size';
164
@@session.query_alloc_block_size = VARIABLE_VALUE
166
'#------------------FN_DYNVARS_130_08-----------------------#'
167
SET @@global.query_alloc_block_size = TRUE;
169
Warning 1292 Truncated incorrect query_alloc_block_size value: '1'
170
SELECT @@global.query_alloc_block_size;
171
@@global.query_alloc_block_size
173
SET @@global.query_alloc_block_size = FALSE;
175
Warning 1292 Truncated incorrect query_alloc_block_size value: '0'
176
SELECT @@global.query_alloc_block_size;
177
@@global.query_alloc_block_size
179
'#---------------------FN_DYNVARS_130_09----------------------#'
180
SET @@global.query_alloc_block_size = 2048;
181
SELECT @@query_alloc_block_size = @@global.query_alloc_block_size;
182
@@query_alloc_block_size = @@global.query_alloc_block_size
184
'#---------------------FN_DYNVARS_130_10----------------------#'
185
SET @@query_alloc_block_size = 5000;
187
Warning 1292 Truncated incorrect query_alloc_block_size value: '5000'
188
SELECT @@query_alloc_block_size = @@local.query_alloc_block_size;
189
@@query_alloc_block_size = @@local.query_alloc_block_size
191
SELECT @@local.query_alloc_block_size = @@session.query_alloc_block_size;
192
@@local.query_alloc_block_size = @@session.query_alloc_block_size
194
'#---------------------FN_DYNVARS_130_11----------------------#'
195
SET query_alloc_block_size = 1024;
196
SELECT @@query_alloc_block_size;
197
@@query_alloc_block_size
199
SELECT local.query_alloc_block_size;
200
ERROR 42S02: Unknown table 'local' in field list
201
SELECT session.query_alloc_block_size;
202
ERROR 42S02: Unknown table 'session' in field list
203
SELECT query_alloc_block_size = @@session.query_alloc_block_size;
204
ERROR 42S22: Unknown column 'query_alloc_block_size' in 'field list'
205
SET @@global.query_alloc_block_size = @start_global_value;
206
SELECT @@global.query_alloc_block_size;
207
@@global.query_alloc_block_size
209
SET @@session.query_alloc_block_size = @start_session_value;
210
SELECT @@session.query_alloc_block_size;
211
@@session.query_alloc_block_size