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. 148Warning 1292 Truncated incorrect multi_range_count value: '4294967296' 149SELECT @@global.multi_range_count; 150@@global.multi_range_count 1514294967295 152Warnings: 153Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 154SET @@global.multi_range_count = -1024; 155Warnings: 156Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 157Warning 1292 Truncated incorrect multi_range_count value: '-1024' 158SELECT @@global.multi_range_count; 159@@global.multi_range_count 1601 161Warnings: 162Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 163SET @@global.multi_range_count = 429496729500; 164Warnings: 165Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 166Warning 1292 Truncated incorrect multi_range_count value: '429496729500' 167SELECT @@global.multi_range_count; 168@@global.multi_range_count 1694294967295 170Warnings: 171Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 172SET @@global.multi_range_count = 65530.34; 173ERROR 42000: Incorrect argument type to variable 'multi_range_count' 174SELECT @@global.multi_range_count; 175@@global.multi_range_count 1764294967295 177Warnings: 178Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 179SET @@global.multi_range_count = test; 180ERROR 42000: Incorrect argument type to variable 'multi_range_count' 181SELECT @@global.multi_range_count; 182@@global.multi_range_count 1834294967295 184Warnings: 185Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 186SET @@session.multi_range_count = 0; 187Warnings: 188Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 189Warning 1292 Truncated incorrect multi_range_count value: '0' 190SELECT @@session.multi_range_count; 191@@session.multi_range_count 1921 193Warnings: 194Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 195SET @@session.multi_range_count = 4294967296; 196Warnings: 197Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 198Warning 1292 Truncated incorrect multi_range_count value: '4294967296' 199SELECT @@session.multi_range_count; 200@@session.multi_range_count 2014294967295 202Warnings: 203Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 204SET @@session.multi_range_count = -1; 205Warnings: 206Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 207Warning 1292 Truncated incorrect multi_range_count value: '-1' 208SELECT @@session.multi_range_count; 209@@session.multi_range_count 2101 211Warnings: 212Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 213SET @@session.multi_range_count = 65530.34.; 214ERROR 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 215SET @@session.multi_range_count = 4294967295021; 216Warnings: 217Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 218Warning 1292 Truncated incorrect multi_range_count value: '4294967295021' 219SELECT @@session.multi_range_count; 220@@session.multi_range_count 2214294967295 222Warnings: 223Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 224'Bug # 34837: Errors are not coming on assigning invalid values to variable'; 225SET @@session.multi_range_count = test; 226ERROR 42000: Incorrect argument type to variable 'multi_range_count' 227SELECT @@session.multi_range_count; 228@@session.multi_range_count 2294294967295 230Warnings: 231Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 232'#------------------FN_DYNVARS_090_06-----------------------#' 233SELECT VARIABLE_VALUE 234FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 235WHERE VARIABLE_NAME='multi_range_count' 236into @tmp; 237SELECT @@global.multi_range_count = @tmp; 238@@global.multi_range_count = @tmp 2391 240Warnings: 241Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 242'#------------------FN_DYNVARS_090_07-----------------------#' 243SELECT VARIABLE_VALUE 244FROM INFORMATION_SCHEMA.SESSION_VARIABLES 245WHERE VARIABLE_NAME='multi_range_count' 246into @tmp; 247SELECT @@session.multi_range_count = @tmp; 248@@session.multi_range_count = @tmp 2491 250Warnings: 251Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 252'#------------------FN_DYNVARS_090_08-----------------------#' 253SET @@global.multi_range_count = TRUE; 254Warnings: 255Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 256SELECT @@global.multi_range_count; 257@@global.multi_range_count 2581 259Warnings: 260Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 261SET @@global.multi_range_count = FALSE; 262Warnings: 263Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 264Warning 1292 Truncated incorrect multi_range_count value: '0' 265SELECT @@global.multi_range_count; 266@@global.multi_range_count 2671 268Warnings: 269Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 270'#---------------------FN_DYNVARS_090_09----------------------#' 271SET @@global.multi_range_count = 10; 272Warnings: 273Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 274SELECT @@multi_range_count = @@global.multi_range_count; 275@@multi_range_count = @@global.multi_range_count 2760 277Warnings: 278Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 279Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 280'#---------------------FN_DYNVARS_090_10----------------------#' 281SET @@multi_range_count = 100; 282Warnings: 283Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 284SELECT @@multi_range_count = @@local.multi_range_count; 285@@multi_range_count = @@local.multi_range_count 2861 287Warnings: 288Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 289Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 290SELECT @@local.multi_range_count = @@session.multi_range_count; 291@@local.multi_range_count = @@session.multi_range_count 2921 293Warnings: 294Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 295Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 296'#---------------------FN_DYNVARS_090_11----------------------#' 297SET multi_range_count = 1; 298Warnings: 299Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 300SELECT @@multi_range_count; 301@@multi_range_count 3021 303Warnings: 304Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 305SELECT local.multi_range_count; 306ERROR 42S02: Unknown table 'local' in field list 307SELECT session.multi_range_count; 308ERROR 42S02: Unknown table 'session' in field list 309SELECT multi_range_count = @@session.multi_range_count; 310ERROR 42S22: Unknown column 'multi_range_count' in 'field list' 311SET @@global.multi_range_count = @start_global_value; 312Warnings: 313Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 314SELECT @@global.multi_range_count; 315@@global.multi_range_count 316256 317Warnings: 318Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 319SET @@session.multi_range_count = @start_session_value; 320Warnings: 321Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 322SELECT @@session.multi_range_count; 323@@session.multi_range_count 324256 325Warnings: 326Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. 327