1
SET @start_global_value = @@global.multi_range_count;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.multi_range_count;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_090_01-------------------------#'
10
SET @@global.multi_range_count = 100;
11
SET @@global.multi_range_count = DEFAULT;
12
SELECT @@global.multi_range_count;
13
@@global.multi_range_count
15
SET @@session.multi_range_count = 200;
16
SET @@session.multi_range_count = DEFAULT;
17
SELECT @@session.multi_range_count;
18
@@session.multi_range_count
20
'#--------------------FN_DYNVARS_090_02-------------------------#'
21
SET @@global.multi_range_count = DEFAULT;
22
SELECT @@global.multi_range_count = 256;
23
@@global.multi_range_count = 256
25
SET @@session.multi_range_count = DEFAULT;
26
SELECT @@session.multi_range_count = 256;
27
@@session.multi_range_count = 256
29
'#--------------------FN_DYNVARS_090_03-------------------------#'
30
SET @@global.multi_range_count = 1;
31
SELECT @@global.multi_range_count;
32
@@global.multi_range_count
34
SET @@global.multi_range_count = 60020;
35
SELECT @@global.multi_range_count;
36
@@global.multi_range_count
38
SET @@global.multi_range_count = 65535;
39
SELECT @@global.multi_range_count;
40
@@global.multi_range_count
42
SET @@global.multi_range_count = 4294967295;
43
SELECT @@global.multi_range_count;
44
@@global.multi_range_count
46
SET @@global.multi_range_count = 4294967294;
47
SELECT @@global.multi_range_count;
48
@@global.multi_range_count
50
'#--------------------FN_DYNVARS_090_04-------------------------#'
51
SET @@session.multi_range_count = 1;
52
SELECT @@session.multi_range_count;
53
@@session.multi_range_count
55
SET @@session.multi_range_count = 50050;
56
SELECT @@session.multi_range_count;
57
@@session.multi_range_count
59
SET @@session.multi_range_count = 65535;
60
SELECT @@session.multi_range_count;
61
@@session.multi_range_count
63
SET @@session.multi_range_count = 4294967295;
64
SELECT @@session.multi_range_count;
65
@@session.multi_range_count
67
SET @@session.multi_range_count = 4294967294;
68
SELECT @@session.multi_range_count;
69
@@session.multi_range_count
71
'#------------------FN_DYNVARS_090_05-----------------------#'
72
SET @@global.multi_range_count = 0;
74
Warning 1292 Truncated incorrect multi_range_count value: '0'
75
SELECT @@global.multi_range_count;
76
@@global.multi_range_count
78
SET @@global.multi_range_count = 4294967296;
80
Warning 1292 Truncated incorrect multi_range_count value: '4294967296'
81
SELECT @@global.multi_range_count;
82
@@global.multi_range_count
84
SET @@global.multi_range_count = -1024;
86
Warning 1292 Truncated incorrect multi_range_count value: '0'
87
SELECT @@global.multi_range_count;
88
@@global.multi_range_count
90
SET @@global.multi_range_count = 429496729500;
92
Warning 1292 Truncated incorrect multi_range_count value: '429496729500'
93
SELECT @@global.multi_range_count;
94
@@global.multi_range_count
96
SET @@global.multi_range_count = 65530.34;
97
ERROR 42000: Incorrect argument type to variable 'multi_range_count'
98
SELECT @@global.multi_range_count;
99
@@global.multi_range_count
101
SET @@global.multi_range_count = test;
102
ERROR 42000: Incorrect argument type to variable 'multi_range_count'
103
SELECT @@global.multi_range_count;
104
@@global.multi_range_count
106
SET @@session.multi_range_count = 0;
108
Warning 1292 Truncated incorrect multi_range_count value: '0'
109
SELECT @@session.multi_range_count;
110
@@session.multi_range_count
112
SET @@session.multi_range_count = 4294967296;
114
Warning 1292 Truncated incorrect multi_range_count value: '4294967296'
115
SELECT @@session.multi_range_count;
116
@@session.multi_range_count
118
SET @@session.multi_range_count = -1;
120
Warning 1292 Truncated incorrect multi_range_count value: '0'
121
SELECT @@session.multi_range_count;
122
@@session.multi_range_count
124
SET @@session.multi_range_count = 65530.34.;
125
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
126
SET @@session.multi_range_count = 4294967295021;
128
Warning 1292 Truncated incorrect multi_range_count value: '4294967295021'
129
SELECT @@session.multi_range_count;
130
@@session.multi_range_count
132
'Bug # 34837: Errors are not coming on assigning invalid values to variable';
133
SET @@session.multi_range_count = test;
134
ERROR 42000: Incorrect argument type to variable 'multi_range_count'
135
SELECT @@session.multi_range_count;
136
@@session.multi_range_count
138
'#------------------FN_DYNVARS_090_06-----------------------#'
139
SELECT @@global.multi_range_count = VARIABLE_VALUE
140
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
141
WHERE VARIABLE_NAME='multi_range_count';
142
@@global.multi_range_count = VARIABLE_VALUE
144
'#------------------FN_DYNVARS_090_07-----------------------#'
145
SELECT @@session.multi_range_count = VARIABLE_VALUE
146
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
147
WHERE VARIABLE_NAME='multi_range_count';
148
@@session.multi_range_count = VARIABLE_VALUE
150
'#------------------FN_DYNVARS_090_08-----------------------#'
151
SET @@global.multi_range_count = TRUE;
152
SELECT @@global.multi_range_count;
153
@@global.multi_range_count
155
SET @@global.multi_range_count = FALSE;
157
Warning 1292 Truncated incorrect multi_range_count value: '0'
158
SELECT @@global.multi_range_count;
159
@@global.multi_range_count
161
'#---------------------FN_DYNVARS_090_09----------------------#'
162
SET @@global.multi_range_count = 10;
163
SELECT @@multi_range_count = @@global.multi_range_count;
164
@@multi_range_count = @@global.multi_range_count
166
'#---------------------FN_DYNVARS_090_10----------------------#'
167
SET @@multi_range_count = 100;
168
SELECT @@multi_range_count = @@local.multi_range_count;
169
@@multi_range_count = @@local.multi_range_count
171
SELECT @@local.multi_range_count = @@session.multi_range_count;
172
@@local.multi_range_count = @@session.multi_range_count
174
'#---------------------FN_DYNVARS_090_11----------------------#'
175
SET multi_range_count = 1;
176
SELECT @@multi_range_count;
179
SELECT local.multi_range_count;
180
ERROR 42S02: Unknown table 'local' in field list
181
SELECT session.multi_range_count;
182
ERROR 42S02: Unknown table 'session' in field list
183
SELECT multi_range_count = @@session.multi_range_count;
184
ERROR 42S22: Unknown column 'multi_range_count' in 'field list'
185
SET @@global.multi_range_count = @start_global_value;
186
SELECT @@global.multi_range_count;
187
@@global.multi_range_count
189
SET @@session.multi_range_count = @start_session_value;
190
SELECT @@session.multi_range_count;
191
@@session.multi_range_count