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;
11
SET @@global.query_alloc_block_size = DEFAULT;
12
SELECT @@global.query_alloc_block_size;
13
@@global.query_alloc_block_size
15
SET @@session.query_alloc_block_size = 20000;
16
SET @@session.query_alloc_block_size = DEFAULT;
17
SELECT @@session.query_alloc_block_size;
18
@@session.query_alloc_block_size
20
'#--------------------FN_DYNVARS_130_02-------------------------#'
21
SET @@global.query_alloc_block_size = DEFAULT;
22
SELECT @@global.query_alloc_block_size = 8192;
23
@@global.query_alloc_block_size = 8192
25
SET @@session.query_alloc_block_size = DEFAULT;
26
SELECT @@session.query_alloc_block_size = 8192;
27
@@session.query_alloc_block_size = 8192
29
'#--------------------FN_DYNVARS_130_03-------------------------#'
30
SET @@global.query_alloc_block_size = 1024;
31
SELECT @@global.query_alloc_block_size;
32
@@global.query_alloc_block_size
34
SET @@global.query_alloc_block_size = 1025;
35
SELECT @@global.query_alloc_block_size;
36
@@global.query_alloc_block_size
38
SET @@global.query_alloc_block_size = 4294967295;
39
SELECT @@global.query_alloc_block_size;
40
@@global.query_alloc_block_size
42
SET @@global.query_alloc_block_size = 4294967294;
43
SELECT @@global.query_alloc_block_size;
44
@@global.query_alloc_block_size
46
SET @@global.query_alloc_block_size = 65536;
47
SELECT @@global.query_alloc_block_size;
48
@@global.query_alloc_block_size
50
'Bug# 34877: Invalid Values are coming in variable on assigning valid values';
51
'#--------------------FN_DYNVARS_130_04-------------------------#'
52
SET @@session.query_alloc_block_size = 1024;
53
SELECT @@session.query_alloc_block_size;
54
@@session.query_alloc_block_size
56
SET @@session.query_alloc_block_size = 1025;
57
SELECT @@session.query_alloc_block_size;
58
@@session.query_alloc_block_size
60
SET @@session.query_alloc_block_size = 4294967295;
61
SELECT @@session.query_alloc_block_size;
62
@@session.query_alloc_block_size
64
SET @@session.query_alloc_block_size = 4294967294;
65
SELECT @@session.query_alloc_block_size;
66
@@session.query_alloc_block_size
68
SET @@session.query_alloc_block_size = 655536;
69
SELECT @@session.query_alloc_block_size;
70
@@session.query_alloc_block_size
72
'#------------------FN_DYNVARS_130_05-----------------------#'
73
SET @@global.query_alloc_block_size = 64;
75
Warning 1292 Truncated incorrect query_alloc_block_size value: '64'
76
SELECT @@global.query_alloc_block_size;
77
@@global.query_alloc_block_size
79
SET @@global.query_alloc_block_size = -1;
81
Warning 1292 Truncated incorrect query_alloc_block_size value: '0'
82
SELECT @@global.query_alloc_block_size;
83
@@global.query_alloc_block_size
85
SET @@global.query_alloc_block_size = 1023;
87
Warning 1292 Truncated incorrect query_alloc_block_size value: '1023'
88
SELECT @@global.query_alloc_block_size;
89
@@global.query_alloc_block_size
91
SET @@global.query_alloc_block_size = 4294967296;
93
Warning 1292 Truncated incorrect query_alloc_block_size value: '4294967296'
94
SELECT @@global.query_alloc_block_size;
95
@@global.query_alloc_block_size
97
SET @@global.query_alloc_block_size = 65530.34.;
98
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
99
SELECT @@global.query_alloc_block_size;
100
@@global.query_alloc_block_size
102
SET @@global.query_alloc_block_size = test;
103
ERROR 42000: Incorrect argument type to variable 'query_alloc_block_size'
104
SELECT @@global.query_alloc_block_size;
105
@@global.query_alloc_block_size
107
SET @@session.query_alloc_block_size = 64;
109
Warning 1292 Truncated incorrect query_alloc_block_size value: '64'
110
SELECT @@session.query_alloc_block_size;
111
@@session.query_alloc_block_size
113
SET @@session.query_alloc_block_size = -2;
115
Warning 1292 Truncated incorrect query_alloc_block_size value: '0'
116
SELECT @@session.query_alloc_block_size;
117
@@session.query_alloc_block_size
119
SET @@session.query_alloc_block_size = 65530.34.;
120
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
121
SET @@session.query_alloc_block_size = 1023;
123
Warning 1292 Truncated incorrect query_alloc_block_size value: '1023'
124
SELECT @@session.query_alloc_block_size;
125
@@session.query_alloc_block_size
127
SET @@session.query_alloc_block_size = 4294967296;
129
Warning 1292 Truncated incorrect query_alloc_block_size value: '4294967296'
130
SELECT @@session.query_alloc_block_size;
131
@@session.query_alloc_block_size
133
'Bug # 34837: Errors are not coming on assigning invalid values to variable';
134
SET @@session.query_alloc_block_size = test;
135
ERROR 42000: Incorrect argument type to variable 'query_alloc_block_size'
136
SELECT @@session.query_alloc_block_size;
137
@@session.query_alloc_block_size
139
'#------------------FN_DYNVARS_130_06-----------------------#'
140
'Bug# 34877: OutOFMemeory errors are coming if we dont assign these values to variable before comparision statement';
141
SET @@global.query_alloc_block_size = 1;
143
Warning 1292 Truncated incorrect query_alloc_block_size value: '1'
144
SET @@session.query_alloc_block_size = 12;
146
Warning 1292 Truncated incorrect query_alloc_block_size value: '12'
147
SELECT @@global.query_alloc_block_size =
148
VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
149
WHERE VARIABLE_NAME='query_alloc_block_size';
150
@@global.query_alloc_block_size =
153
'#------------------FN_DYNVARS_130_07-----------------------#'
154
SELECT @@session.query_alloc_block_size = VARIABLE_VALUE
155
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
156
WHERE VARIABLE_NAME='query_alloc_block_size';
157
@@session.query_alloc_block_size = VARIABLE_VALUE
159
'#------------------FN_DYNVARS_130_08-----------------------#'
160
SET @@global.query_alloc_block_size = TRUE;
162
Warning 1292 Truncated incorrect query_alloc_block_size value: '1'
163
SELECT @@global.query_alloc_block_size;
164
@@global.query_alloc_block_size
166
SET @@global.query_alloc_block_size = FALSE;
168
Warning 1292 Truncated incorrect query_alloc_block_size value: '0'
169
SELECT @@global.query_alloc_block_size;
170
@@global.query_alloc_block_size
172
'#---------------------FN_DYNVARS_130_09----------------------#'
173
SET @@global.query_alloc_block_size = 2048;
174
SELECT @@query_alloc_block_size = @@global.query_alloc_block_size;
175
@@query_alloc_block_size = @@global.query_alloc_block_size
177
'#---------------------FN_DYNVARS_130_10----------------------#'
178
SET @@query_alloc_block_size = 5000;
179
SELECT @@query_alloc_block_size = @@local.query_alloc_block_size;
180
@@query_alloc_block_size = @@local.query_alloc_block_size
182
SELECT @@local.query_alloc_block_size = @@session.query_alloc_block_size;
183
@@local.query_alloc_block_size = @@session.query_alloc_block_size
185
'#---------------------FN_DYNVARS_130_11----------------------#'
186
SET query_alloc_block_size = 1024;
187
SELECT @@query_alloc_block_size;
188
@@query_alloc_block_size
190
SELECT local.query_alloc_block_size;
191
ERROR 42S02: Unknown table 'local' in field list
192
SELECT session.query_alloc_block_size;
193
ERROR 42S02: Unknown table 'session' in field list
194
SELECT query_alloc_block_size = @@session.query_alloc_block_size;
195
ERROR 42S22: Unknown column 'query_alloc_block_size' in 'field list'
196
SET @@global.query_alloc_block_size = @start_global_value;
197
SELECT @@global.query_alloc_block_size;
198
@@global.query_alloc_block_size
200
SET @@session.query_alloc_block_size = @start_session_value;
201
SELECT @@session.query_alloc_block_size;
202
@@session.query_alloc_block_size