1
SET @start_global_value = @@global.range_alloc_block_size;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.range_alloc_block_size;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_137_01-------------------------#'
10
SET @@global.range_alloc_block_size = 100;
12
Warning 1292 Truncated incorrect range_alloc_block_size value: '100'
13
SET @@global.range_alloc_block_size = DEFAULT;
14
SELECT @@global.range_alloc_block_size;
15
@@global.range_alloc_block_size
17
SET @@session.range_alloc_block_size = 200;
19
Warning 1292 Truncated incorrect range_alloc_block_size value: '200'
20
SET @@session.range_alloc_block_size = DEFAULT;
21
SELECT @@session.range_alloc_block_size;
22
@@session.range_alloc_block_size
24
'#--------------------FN_DYNVARS_137_02-------------------------#'
25
SET @@global.range_alloc_block_size = DEFAULT;
26
SELECT @@global.range_alloc_block_size = 2048;
27
@@global.range_alloc_block_size = 2048
29
SET @@session.range_alloc_block_size = DEFAULT;
30
SELECT @@session.range_alloc_block_size = 2048;
31
@@session.range_alloc_block_size = 2048
33
'#--------------------FN_DYNVARS_137_03-------------------------#'
34
SET @@global.range_alloc_block_size = 2048;
36
Warning 1292 Truncated incorrect range_alloc_block_size value: '2048'
37
SELECT @@global.range_alloc_block_size;
38
@@global.range_alloc_block_size
40
'Bug# 34877: Invalid Values are coming in variable on assigning valid values';
41
SET @@global.range_alloc_block_size = 4294967295;
42
SELECT @@global.range_alloc_block_size;
43
@@global.range_alloc_block_size
45
SET @@global.range_alloc_block_size = 4294967294;
46
SELECT @@global.range_alloc_block_size;
47
@@global.range_alloc_block_size
49
'Bug# 34877: Invalid Values are coming in variable on assigning valid values';
50
'#--------------------FN_DYNVARS_137_04-------------------------#'
51
SET @@session.range_alloc_block_size = 2048;
53
Warning 1292 Truncated incorrect range_alloc_block_size value: '2048'
54
SELECT @@session.range_alloc_block_size;
55
@@session.range_alloc_block_size
57
SET @@session.range_alloc_block_size = 4294967295;
58
SELECT @@session.range_alloc_block_size;
59
@@session.range_alloc_block_size
61
SET @@session.range_alloc_block_size = 4294967294;
62
SELECT @@session.range_alloc_block_size;
63
@@session.range_alloc_block_size
65
'#------------------FN_DYNVARS_137_05-----------------------#'
66
SET @@global.range_alloc_block_size = 0;
68
Warning 1292 Truncated incorrect range_alloc_block_size value: '0'
69
SELECT @@global.range_alloc_block_size;
70
@@global.range_alloc_block_size
72
SET @@global.range_alloc_block_size = -1024;
74
Warning 1292 Truncated incorrect range_alloc_block_size value: '0'
75
SELECT @@global.range_alloc_block_size;
76
@@global.range_alloc_block_size
78
SET @@global.range_alloc_block_size = 42949672951;
80
Warning 1292 Truncated incorrect range_alloc_block_size value: '42949672951'
81
SELECT @@global.range_alloc_block_size;
82
@@global.range_alloc_block_size
84
SET @@global.range_alloc_block_size = 65530.34.;
85
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
86
SELECT @@global.range_alloc_block_size;
87
@@global.range_alloc_block_size
89
SET @@global.range_alloc_block_size = test;
90
ERROR 42000: Incorrect argument type to variable 'range_alloc_block_size'
91
SELECT @@global.range_alloc_block_size;
92
@@global.range_alloc_block_size
94
SET @@session.range_alloc_block_size = 0;
96
Warning 1292 Truncated incorrect range_alloc_block_size value: '0'
97
SELECT @@session.range_alloc_block_size;
98
@@session.range_alloc_block_size
100
SET @@session.range_alloc_block_size = -2;
102
Warning 1292 Truncated incorrect range_alloc_block_size value: '0'
103
SELECT @@session.range_alloc_block_size;
104
@@session.range_alloc_block_size
106
SET @@session.range_alloc_block_size = 65530.34.;
107
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
108
SET @@session.range_alloc_block_size = 4294967296;
110
Warning 1292 Truncated incorrect range_alloc_block_size value: '4294967296'
111
SELECT @@session.range_alloc_block_size;
112
@@session.range_alloc_block_size
114
'Bug # 34837: Errors are not coming on assigning invalid values to variable';
115
SET @@session.range_alloc_block_size = test;
116
ERROR 42000: Incorrect argument type to variable 'range_alloc_block_size'
117
SELECT @@session.range_alloc_block_size;
118
@@session.range_alloc_block_size
120
'#------------------FN_DYNVARS_137_06-----------------------#'
121
SELECT @@global.range_alloc_block_size = VARIABLE_VALUE
122
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
123
WHERE VARIABLE_NAME='range_alloc_block_size';
124
@@global.range_alloc_block_size = VARIABLE_VALUE
126
'#------------------FN_DYNVARS_137_07-----------------------#'
127
SELECT @@session.range_alloc_block_size = VARIABLE_VALUE
128
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
129
WHERE VARIABLE_NAME='range_alloc_block_size';
130
@@session.range_alloc_block_size = VARIABLE_VALUE
132
'#------------------FN_DYNVARS_137_08-----------------------#'
133
SET @@global.range_alloc_block_size = TRUE;
135
Warning 1292 Truncated incorrect range_alloc_block_size value: '1'
136
SELECT @@global.range_alloc_block_size;
137
@@global.range_alloc_block_size
139
SET @@global.range_alloc_block_size = FALSE;
141
Warning 1292 Truncated incorrect range_alloc_block_size value: '0'
142
SELECT @@global.range_alloc_block_size;
143
@@global.range_alloc_block_size
145
'#---------------------FN_DYNVARS_137_09----------------------#'
146
SET @@global.range_alloc_block_size = 10;
148
Warning 1292 Truncated incorrect range_alloc_block_size value: '10'
149
SELECT @@range_alloc_block_size = @@global.range_alloc_block_size;
150
@@range_alloc_block_size = @@global.range_alloc_block_size
152
'#---------------------FN_DYNVARS_137_10----------------------#'
153
SET @@range_alloc_block_size = 100;
155
Warning 1292 Truncated incorrect range_alloc_block_size value: '100'
156
SELECT @@range_alloc_block_size = @@local.range_alloc_block_size;
157
@@range_alloc_block_size = @@local.range_alloc_block_size
159
SELECT @@local.range_alloc_block_size = @@session.range_alloc_block_size;
160
@@local.range_alloc_block_size = @@session.range_alloc_block_size
162
'#---------------------FN_DYNVARS_137_11----------------------#'
163
SET range_alloc_block_size = 1;
165
Warning 1292 Truncated incorrect range_alloc_block_size value: '1'
166
SELECT @@range_alloc_block_size;
167
@@range_alloc_block_size
169
SELECT local.range_alloc_block_size;
170
ERROR 42S02: Unknown table 'local' in field list
171
SELECT session.range_alloc_block_size;
172
ERROR 42S02: Unknown table 'session' in field list
173
SELECT range_alloc_block_size = @@session.range_alloc_block_size;
174
ERROR 42S22: Unknown column 'range_alloc_block_size' in 'field list'
175
SET @@global.range_alloc_block_size = @start_global_value;
176
SELECT @@global.range_alloc_block_size;
177
@@global.range_alloc_block_size
179
SET @@session.range_alloc_block_size = @start_session_value;
180
SELECT @@session.range_alloc_block_size;
181
@@session.range_alloc_block_size