1
SET @start_global_value = @@global.read_rnd_buffer_size;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.read_rnd_buffer_size;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_140_01-------------------------#'
10
SET @@global.read_rnd_buffer_size = 1000;
12
Warning 1292 Truncated incorrect read_rnd_buffer_size value: '1000'
13
SET @@global.read_rnd_buffer_size = DEFAULT;
14
SELECT @@global.read_rnd_buffer_size;
15
@@global.read_rnd_buffer_size
17
SET @@session.read_rnd_buffer_size = 2000;
19
Warning 1292 Truncated incorrect read_rnd_buffer_size value: '2000'
20
SET @@session.read_rnd_buffer_size = DEFAULT;
21
SELECT @@session.read_rnd_buffer_size;
22
@@session.read_rnd_buffer_size
24
'#--------------------FN_DYNVARS_140_02-------------------------#'
25
SET @@global.read_rnd_buffer_size = DEFAULT;
26
SELECT @@global.read_rnd_buffer_size = 262144;
27
@@global.read_rnd_buffer_size = 262144
29
SET @@session.read_rnd_buffer_size = DEFAULT;
30
SELECT @@session.read_rnd_buffer_size = 262144;
31
@@session.read_rnd_buffer_size = 262144
33
'Bug# 34876: This variable has invalid default value as compared to documentation';
34
'#--------------------FN_DYNVARS_140_03-------------------------#'
35
SET @@global.read_rnd_buffer_size = 8201;
37
Warning 1292 Truncated incorrect read_rnd_buffer_size value: '8201'
38
SELECT @@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228;
39
@@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228
41
SET @@global.read_rnd_buffer_size = 8200;
43
Warning 1292 Truncated incorrect read_rnd_buffer_size value: '8200'
44
SELECT @@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228;
45
@@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228
47
SET @@global.read_rnd_buffer_size = 2147479552;
48
SELECT @@global.read_rnd_buffer_size;
49
@@global.read_rnd_buffer_size
51
SET @@global.read_rnd_buffer_size = 2147479551;
52
SELECT @@global.read_rnd_buffer_size;
53
@@global.read_rnd_buffer_size
55
'Bug# 34877: Invalid Values are coming in variable on assigning valid values';
56
'#--------------------FN_DYNVARS_140_04-------------------------#'
57
SET @@session.read_rnd_buffer_size = 8200;
59
Warning 1292 Truncated incorrect read_rnd_buffer_size value: '8200'
60
SELECT @@session.read_rnd_buffer_size= 8200 OR @@session.read_rnd_buffer_size= 8228;
61
@@session.read_rnd_buffer_size= 8200 OR @@session.read_rnd_buffer_size= 8228
63
SET @@session.read_rnd_buffer_size = 8201;
65
Warning 1292 Truncated incorrect read_rnd_buffer_size value: '8201'
66
SELECT @@session.read_rnd_buffer_size= 8200 OR @@session.read_rnd_buffer_size= 8228;
67
@@session.read_rnd_buffer_size= 8200 OR @@session.read_rnd_buffer_size= 8228
69
SET @@session.read_rnd_buffer_size = 2147479552;
70
SELECT @@session.read_rnd_buffer_size;
71
@@session.read_rnd_buffer_size
73
SET @@session.read_rnd_buffer_size = 2147479551;
74
SELECT @@session.read_rnd_buffer_size;
75
@@session.read_rnd_buffer_size
77
'#------------------FN_DYNVARS_140_05-----------------------#'
78
SET @@global.read_rnd_buffer_size = 8199;
80
Warning 1292 Truncated incorrect read_rnd_buffer_size value: '8199'
81
SELECT @@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228;
82
@@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228
84
SET @@global.read_rnd_buffer_size = -1024;
86
Warning 1292 Truncated incorrect read_rnd_buffer_size value: '0'
87
SELECT @@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228;
88
@@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228
90
SET @@global.read_rnd_buffer_size = 2147479553;
92
Warning 1292 Truncated incorrect read_rnd_buffer_size value: '2147479553'
93
SELECT @@global.read_rnd_buffer_size;
94
@@global.read_rnd_buffer_size
96
SET @@global.read_rnd_buffer_size = 65530.34.;
97
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
98
SELECT @@global.read_rnd_buffer_size;
99
@@global.read_rnd_buffer_size
101
SET @@global.read_rnd_buffer_size = test;
102
ERROR 42000: Incorrect argument type to variable 'read_rnd_buffer_size'
103
SELECT @@global.read_rnd_buffer_size;
104
@@global.read_rnd_buffer_size
106
SET @@session.read_rnd_buffer_size = 8199;
108
Warning 1292 Truncated incorrect read_rnd_buffer_size value: '8199'
109
SELECT @@session.read_rnd_buffer_size= 8200 OR @@session.read_rnd_buffer_size= 8228;
110
@@session.read_rnd_buffer_size= 8200 OR @@session.read_rnd_buffer_size= 8228
112
SET @@session.read_rnd_buffer_size = -2;
114
Warning 1292 Truncated incorrect read_rnd_buffer_size value: '0'
115
SELECT @@session.read_rnd_buffer_size= 8200 OR @@session.read_rnd_buffer_size= 8228;
116
@@session.read_rnd_buffer_size= 8200 OR @@session.read_rnd_buffer_size= 8228
118
SET @@session.read_rnd_buffer_size = 65530.34.;
119
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
120
SET @@session.read_rnd_buffer_size = 2147479553;
122
Warning 1292 Truncated incorrect read_rnd_buffer_size value: '2147479553'
123
SELECT @@session.read_rnd_buffer_size;
124
@@session.read_rnd_buffer_size
126
'Bug # 34837: Errors are not coming on assigning invalid values to variable';
127
SET @@session.read_rnd_buffer_size = test;
128
ERROR 42000: Incorrect argument type to variable 'read_rnd_buffer_size'
129
SELECT @@session.read_rnd_buffer_size;
130
@@session.read_rnd_buffer_size
132
'#------------------FN_DYNVARS_140_06-----------------------#'
133
SELECT @@global.read_rnd_buffer_size = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='read_rnd_buffer_size';
134
@@global.read_rnd_buffer_size = VARIABLE_VALUE
136
'#------------------FN_DYNVARS_140_07-----------------------#'
137
SELECT @@session.read_rnd_buffer_size =
138
VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='read_rnd_buffer_size';
139
@@session.read_rnd_buffer_size =
142
'#------------------FN_DYNVARS_140_08-----------------------#'
143
SET @@global.read_rnd_buffer_size = TRUE;
145
Warning 1292 Truncated incorrect read_rnd_buffer_size value: '1'
146
SELECT @@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228;
147
@@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228
149
SET @@global.read_rnd_buffer_size = FALSE;
151
Warning 1292 Truncated incorrect read_rnd_buffer_size value: '0'
152
SELECT @@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228;
153
@@global.read_rnd_buffer_size= 8200 OR @@global.read_rnd_buffer_size= 8228
155
'#---------------------FN_DYNVARS_140_09----------------------#'
156
SET @@global.read_rnd_buffer_size = 9000;
158
Warning 1292 Truncated incorrect read_rnd_buffer_size value: '9000'
159
SELECT @@read_rnd_buffer_size = @@global.read_rnd_buffer_size;
160
@@read_rnd_buffer_size = @@global.read_rnd_buffer_size
162
'#---------------------FN_DYNVARS_140_10----------------------#'
163
SET @@read_rnd_buffer_size = 9000;
165
Warning 1292 Truncated incorrect read_rnd_buffer_size value: '9000'
166
SELECT @@read_rnd_buffer_size = @@local.read_rnd_buffer_size;
167
@@read_rnd_buffer_size = @@local.read_rnd_buffer_size
169
SELECT @@local.read_rnd_buffer_size = @@session.read_rnd_buffer_size;
170
@@local.read_rnd_buffer_size = @@session.read_rnd_buffer_size
172
'#---------------------FN_DYNVARS_140_11----------------------#'
173
SET read_rnd_buffer_size = 9100;
175
Warning 1292 Truncated incorrect read_rnd_buffer_size value: '9100'
176
SELECT @@read_rnd_buffer_size= 8200 OR @@read_rnd_buffer_size= 8228;
177
@@read_rnd_buffer_size= 8200 OR @@read_rnd_buffer_size= 8228
179
SELECT local.read_rnd_buffer_size;
180
ERROR 42S02: Unknown table 'local' in field list
181
SELECT session.read_rnd_buffer_size;
182
ERROR 42S02: Unknown table 'session' in field list
183
SELECT read_rnd_buffer_size = @@session.read_rnd_buffer_size;
184
ERROR 42S22: Unknown column 'read_rnd_buffer_size' in 'field list'
185
SET @@global.read_rnd_buffer_size = @start_global_value;
186
SELECT @@global.read_rnd_buffer_size;
187
@@global.read_rnd_buffer_size
189
SET @@session.read_rnd_buffer_size = @start_session_value;
190
SELECT @@session.read_rnd_buffer_size;
191
@@session.read_rnd_buffer_size