1SET @start_global_value = @@global.multi_range_count; 2Warnings: 3Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 4SELECT @start_global_value; 5@start_global_value 6256 7SET @start_session_value = @@session.multi_range_count; 8Warnings: 9Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 10SELECT @start_session_value; 11@start_session_value 12256 13'#--------------------FN_DYNVARS_090_01-------------------------#' 14SET @@global.multi_range_count = 100; 15Warnings: 16Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 17SET @@global.multi_range_count = DEFAULT; 18Warnings: 19Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 20SELECT @@global.multi_range_count; 21@@global.multi_range_count 22256 23Warnings: 24Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 25SET @@session.multi_range_count = 200; 26Warnings: 27Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 28SET @@session.multi_range_count = DEFAULT; 29Warnings: 30Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 31SELECT @@session.multi_range_count; 32@@session.multi_range_count 33256 34Warnings: 35Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 36'#--------------------FN_DYNVARS_090_02-------------------------#' 37SET @@global.multi_range_count = DEFAULT; 38Warnings: 39Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 40SELECT @@global.multi_range_count = 256; 41@@global.multi_range_count = 256 421 43Warnings: 44Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 45SET @@session.multi_range_count = DEFAULT; 46Warnings: 47Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 48SELECT @@session.multi_range_count = 256; 49@@session.multi_range_count = 256 501 51Warnings: 52Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 53'#--------------------FN_DYNVARS_090_03-------------------------#' 54SET @@global.multi_range_count = 1; 55Warnings: 56Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 57SELECT @@global.multi_range_count; 58@@global.multi_range_count 591 60Warnings: 61Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 62SET @@global.multi_range_count = 60020; 63Warnings: 64Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 65SELECT @@global.multi_range_count; 66@@global.multi_range_count 6760020 68Warnings: 69Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 70SET @@global.multi_range_count = 65535; 71Warnings: 72Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 73SELECT @@global.multi_range_count; 74@@global.multi_range_count 7565535 76Warnings: 77Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 78SET @@global.multi_range_count = 4294967295; 79Warnings: 80Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 81SELECT @@global.multi_range_count; 82@@global.multi_range_count 834294967295 84Warnings: 85Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 86SET @@global.multi_range_count = 4294967294; 87Warnings: 88Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 89SELECT @@global.multi_range_count; 90@@global.multi_range_count 914294967294 92Warnings: 93Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 94'#--------------------FN_DYNVARS_090_04-------------------------#' 95SET @@session.multi_range_count = 1; 96Warnings: 97Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 98SELECT @@session.multi_range_count; 99@@session.multi_range_count 1001 101Warnings: 102Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 103SET @@session.multi_range_count = 50050; 104Warnings: 105Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 106SELECT @@session.multi_range_count; 107@@session.multi_range_count 10850050 109Warnings: 110Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 111SET @@session.multi_range_count = 65535; 112Warnings: 113Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 114SELECT @@session.multi_range_count; 115@@session.multi_range_count 11665535 117Warnings: 118Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 119SET @@session.multi_range_count = 4294967295; 120Warnings: 121Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 122SELECT @@session.multi_range_count; 123@@session.multi_range_count 1244294967295 125Warnings: 126Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 127SET @@session.multi_range_count = 4294967294; 128Warnings: 129Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 130SELECT @@session.multi_range_count; 131@@session.multi_range_count 1324294967294 133Warnings: 134Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 135'#------------------FN_DYNVARS_090_05-----------------------#' 136SET @@global.multi_range_count = 0; 137Warnings: 138Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 139Warning 1292 Truncated incorrect multi_range_count value: '0' 140SELECT @@global.multi_range_count; 141@@global.multi_range_count 1421 143Warnings: 144Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 145SET @@global.multi_range_count = 4294967296; 146Warnings: 147Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 148SELECT @@global.multi_range_count; 149@@global.multi_range_count 1504294967296 151Warnings: 152Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 153SET @@global.multi_range_count = -1024; 154Warnings: 155Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 156Warning 1292 Truncated incorrect multi_range_count value: '-1024' 157SELECT @@global.multi_range_count; 158@@global.multi_range_count 1591 160Warnings: 161Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 162SET @@global.multi_range_count = 429496729500; 163Warnings: 164Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 165SELECT @@global.multi_range_count; 166@@global.multi_range_count 167429496729500 168Warnings: 169Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 170SET @@global.multi_range_count = 65530.34; 171ERROR 42000: Incorrect argument type to variable 'multi_range_count' 172SELECT @@global.multi_range_count; 173@@global.multi_range_count 174429496729500 175Warnings: 176Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 177SET @@global.multi_range_count = test; 178ERROR 42000: Incorrect argument type to variable 'multi_range_count' 179SELECT @@global.multi_range_count; 180@@global.multi_range_count 181429496729500 182Warnings: 183Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 184SET @@session.multi_range_count = 0; 185Warnings: 186Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 187Warning 1292 Truncated incorrect multi_range_count value: '0' 188SELECT @@session.multi_range_count; 189@@session.multi_range_count 1901 191Warnings: 192Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 193SET @@session.multi_range_count = 4294967296; 194Warnings: 195Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 196SELECT @@session.multi_range_count; 197@@session.multi_range_count 1984294967296 199Warnings: 200Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 201SET @@session.multi_range_count = -1; 202Warnings: 203Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 204Warning 1292 Truncated incorrect multi_range_count value: '-1' 205SELECT @@session.multi_range_count; 206@@session.multi_range_count 2071 208Warnings: 209Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 210SET @@session.multi_range_count = 65530.34.; 211ERROR 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 212SET @@session.multi_range_count = 4294967295021; 213Warnings: 214Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 215SELECT @@session.multi_range_count; 216@@session.multi_range_count 2174294967295021 218Warnings: 219Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 220'Bug # 34837: Errors are not coming on assigning invalid values to variable'; 221SET @@session.multi_range_count = test; 222ERROR 42000: Incorrect argument type to variable 'multi_range_count' 223SELECT @@session.multi_range_count; 224@@session.multi_range_count 2254294967295021 226Warnings: 227Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 228'#------------------FN_DYNVARS_090_06-----------------------#' 229SELECT @@global.multi_range_count = VARIABLE_VALUE 230FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 231WHERE VARIABLE_NAME='multi_range_count'; 232@@global.multi_range_count = VARIABLE_VALUE 2331 234Warnings: 235Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 236'#------------------FN_DYNVARS_090_07-----------------------#' 237SELECT @@session.multi_range_count = VARIABLE_VALUE 238FROM INFORMATION_SCHEMA.SESSION_VARIABLES 239WHERE VARIABLE_NAME='multi_range_count'; 240@@session.multi_range_count = VARIABLE_VALUE 2411 242Warnings: 243Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 244'#------------------FN_DYNVARS_090_08-----------------------#' 245SET @@global.multi_range_count = TRUE; 246Warnings: 247Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 248SELECT @@global.multi_range_count; 249@@global.multi_range_count 2501 251Warnings: 252Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 253SET @@global.multi_range_count = FALSE; 254Warnings: 255Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 256Warning 1292 Truncated incorrect multi_range_count value: '0' 257SELECT @@global.multi_range_count; 258@@global.multi_range_count 2591 260Warnings: 261Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 262'#---------------------FN_DYNVARS_090_09----------------------#' 263SET @@global.multi_range_count = 10; 264Warnings: 265Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 266SELECT @@multi_range_count = @@global.multi_range_count; 267@@multi_range_count = @@global.multi_range_count 2680 269Warnings: 270Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 271Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 272'#---------------------FN_DYNVARS_090_10----------------------#' 273SET @@multi_range_count = 100; 274Warnings: 275Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 276SELECT @@multi_range_count = @@local.multi_range_count; 277@@multi_range_count = @@local.multi_range_count 2781 279Warnings: 280Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 281Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 282SELECT @@local.multi_range_count = @@session.multi_range_count; 283@@local.multi_range_count = @@session.multi_range_count 2841 285Warnings: 286Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 287Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 288'#---------------------FN_DYNVARS_090_11----------------------#' 289SET multi_range_count = 1; 290Warnings: 291Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 292SELECT @@multi_range_count; 293@@multi_range_count 2941 295Warnings: 296Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 297SELECT local.multi_range_count; 298ERROR 42S02: Unknown table 'local' in field list 299SELECT session.multi_range_count; 300ERROR 42S02: Unknown table 'session' in field list 301SELECT multi_range_count = @@session.multi_range_count; 302ERROR 42S22: Unknown column 'multi_range_count' in 'field list' 303SET @@global.multi_range_count = @start_global_value; 304Warnings: 305Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 306SELECT @@global.multi_range_count; 307@@global.multi_range_count 308256 309Warnings: 310Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 311SET @@session.multi_range_count = @start_session_value; 312Warnings: 313Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 314SELECT @@session.multi_range_count; 315@@session.multi_range_count 316256 317Warnings: 318Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 319