1SET @start_global_value = @@global.multi_range_count; 2SELECT @start_global_value; 3@start_global_value 4256 5SET @start_session_value = @@session.multi_range_count; 6SELECT @start_session_value; 7@start_session_value 8256 9'#--------------------FN_DYNVARS_090_01-------------------------#' 10SET @@global.multi_range_count = 100; 11Warnings: 12Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 13SET @@global.multi_range_count = DEFAULT; 14Warnings: 15Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 16SELECT @@global.multi_range_count; 17@@global.multi_range_count 18256 19SET @@session.multi_range_count = 200; 20Warnings: 21Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 22SET @@session.multi_range_count = DEFAULT; 23Warnings: 24Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 25SELECT @@session.multi_range_count; 26@@session.multi_range_count 27256 28'#--------------------FN_DYNVARS_090_02-------------------------#' 29SET @@global.multi_range_count = DEFAULT; 30Warnings: 31Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 32SELECT @@global.multi_range_count = 256; 33@@global.multi_range_count = 256 341 35SET @@session.multi_range_count = DEFAULT; 36Warnings: 37Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 38SELECT @@session.multi_range_count = 256; 39@@session.multi_range_count = 256 401 41'#--------------------FN_DYNVARS_090_03-------------------------#' 42SET @@global.multi_range_count = 1; 43Warnings: 44Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 45SELECT @@global.multi_range_count; 46@@global.multi_range_count 471 48SET @@global.multi_range_count = 60020; 49Warnings: 50Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 51SELECT @@global.multi_range_count; 52@@global.multi_range_count 5360020 54SET @@global.multi_range_count = 65535; 55Warnings: 56Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 57SELECT @@global.multi_range_count; 58@@global.multi_range_count 5965535 60SET @@global.multi_range_count = 4294967295; 61Warnings: 62Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 63SELECT @@global.multi_range_count; 64@@global.multi_range_count 654294967295 66SET @@global.multi_range_count = 4294967294; 67Warnings: 68Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 69SELECT @@global.multi_range_count; 70@@global.multi_range_count 714294967294 72'#--------------------FN_DYNVARS_090_04-------------------------#' 73SET @@session.multi_range_count = 1; 74Warnings: 75Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 76SELECT @@session.multi_range_count; 77@@session.multi_range_count 781 79SET @@session.multi_range_count = 50050; 80Warnings: 81Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 82SELECT @@session.multi_range_count; 83@@session.multi_range_count 8450050 85SET @@session.multi_range_count = 65535; 86Warnings: 87Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 88SELECT @@session.multi_range_count; 89@@session.multi_range_count 9065535 91SET @@session.multi_range_count = 4294967295; 92Warnings: 93Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 94SELECT @@session.multi_range_count; 95@@session.multi_range_count 964294967295 97SET @@session.multi_range_count = 4294967294; 98Warnings: 99Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 100SELECT @@session.multi_range_count; 101@@session.multi_range_count 1024294967294 103'#------------------FN_DYNVARS_090_05-----------------------#' 104SET @@global.multi_range_count = 0; 105Warnings: 106Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 107Warning 1292 Truncated incorrect multi_range_count value: '0' 108SELECT @@global.multi_range_count; 109@@global.multi_range_count 1101 111SET @@global.multi_range_count = 4294967296; 112SELECT @@global.multi_range_count; 113@@global.multi_range_count 1144294967295 115SET @@global.multi_range_count = -1024; 116Warnings: 117Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 118Warning 1292 Truncated incorrect multi_range_count value: '-1024' 119SELECT @@global.multi_range_count; 120@@global.multi_range_count 1211 122SET @@global.multi_range_count = 429496729500; 123SELECT @@global.multi_range_count; 124@@global.multi_range_count 1254294967295 126SET @@global.multi_range_count = 65530.34; 127ERROR 42000: Incorrect argument type to variable 'multi_range_count' 128SELECT @@global.multi_range_count; 129@@global.multi_range_count 1304294967295 131SET @@global.multi_range_count = test; 132ERROR 42000: Incorrect argument type to variable 'multi_range_count' 133SELECT @@global.multi_range_count; 134@@global.multi_range_count 1354294967295 136SET @@session.multi_range_count = 0; 137Warnings: 138Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 139Warning 1292 Truncated incorrect multi_range_count value: '0' 140SELECT @@session.multi_range_count; 141@@session.multi_range_count 1421 143SET @@session.multi_range_count = 4294967296; 144SELECT @@session.multi_range_count; 145@@session.multi_range_count 1464294967295 147SET @@session.multi_range_count = -1; 148Warnings: 149Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 150Warning 1292 Truncated incorrect multi_range_count value: '-1' 151SELECT @@session.multi_range_count; 152@@session.multi_range_count 1531 154SET @@session.multi_range_count = 65530.34.; 155ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.' at line 1 156SET @@session.multi_range_count = 4294967295021; 157SELECT @@session.multi_range_count; 158@@session.multi_range_count 1594294967295 160'Bug # 34837: Errors are not coming on assigning invalid values to variable'; 161SET @@session.multi_range_count = test; 162ERROR 42000: Incorrect argument type to variable 'multi_range_count' 163SELECT @@session.multi_range_count; 164@@session.multi_range_count 1654294967295 166'#------------------FN_DYNVARS_090_06-----------------------#' 167SELECT @@global.multi_range_count = VARIABLE_VALUE 168FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 169WHERE VARIABLE_NAME='multi_range_count'; 170@@global.multi_range_count = VARIABLE_VALUE 1711 172'#------------------FN_DYNVARS_090_07-----------------------#' 173SELECT @@session.multi_range_count = VARIABLE_VALUE 174FROM INFORMATION_SCHEMA.SESSION_VARIABLES 175WHERE VARIABLE_NAME='multi_range_count'; 176@@session.multi_range_count = VARIABLE_VALUE 1771 178'#------------------FN_DYNVARS_090_08-----------------------#' 179SET @@global.multi_range_count = TRUE; 180Warnings: 181Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 182SELECT @@global.multi_range_count; 183@@global.multi_range_count 1841 185SET @@global.multi_range_count = FALSE; 186Warnings: 187Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 188Warning 1292 Truncated incorrect multi_range_count value: '0' 189SELECT @@global.multi_range_count; 190@@global.multi_range_count 1911 192'#---------------------FN_DYNVARS_090_09----------------------#' 193SET @@global.multi_range_count = 10; 194Warnings: 195Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 196SELECT @@multi_range_count = @@global.multi_range_count; 197@@multi_range_count = @@global.multi_range_count 1980 199'#---------------------FN_DYNVARS_090_10----------------------#' 200SET @@multi_range_count = 100; 201Warnings: 202Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 203SELECT @@multi_range_count = @@local.multi_range_count; 204@@multi_range_count = @@local.multi_range_count 2051 206SELECT @@local.multi_range_count = @@session.multi_range_count; 207@@local.multi_range_count = @@session.multi_range_count 2081 209'#---------------------FN_DYNVARS_090_11----------------------#' 210SET multi_range_count = 1; 211Warnings: 212Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 213SELECT @@multi_range_count; 214@@multi_range_count 2151 216SELECT local.multi_range_count; 217ERROR 42S02: Unknown table 'local' in field list 218SELECT session.multi_range_count; 219ERROR 42S02: Unknown table 'session' in field list 220SELECT multi_range_count = @@session.multi_range_count; 221ERROR 42S22: Unknown column 'multi_range_count' in 'field list' 222SET @@global.multi_range_count = @start_global_value; 223Warnings: 224Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 225SELECT @@global.multi_range_count; 226@@global.multi_range_count 227256 228SET @@session.multi_range_count = @start_session_value; 229Warnings: 230Warning 1287 '@@multi_range_count' is deprecated and will be removed in a future release. Please use '@@mrr_buffer_size' instead 231SELECT @@session.multi_range_count; 232@@session.multi_range_count 233256 234