1SET @start_global_value = @@global.range_alloc_block_size; 2SELECT @start_global_value; 3@start_global_value 44096 5SET @start_session_value = @@session.range_alloc_block_size; 6SELECT @start_session_value; 7@start_session_value 84096 9'#--------------------FN_DYNVARS_137_01-------------------------#' 10SET @@global.range_alloc_block_size = 100; 11Warnings: 12Warning 1292 Truncated incorrect range_alloc_block_size value: '100' 13SET @@global.range_alloc_block_size = DEFAULT; 14SELECT @@global.range_alloc_block_size; 15@@global.range_alloc_block_size 164096 17SET @@session.range_alloc_block_size = 200; 18Warnings: 19Warning 1292 Truncated incorrect range_alloc_block_size value: '200' 20SET @@session.range_alloc_block_size = DEFAULT; 21SELECT @@session.range_alloc_block_size; 22@@session.range_alloc_block_size 234096 24'#--------------------FN_DYNVARS_137_02-------------------------#' 25SET @@global.range_alloc_block_size = DEFAULT; 26SELECT @@global.range_alloc_block_size = 2048; 27@@global.range_alloc_block_size = 2048 280 29SET @@session.range_alloc_block_size = DEFAULT; 30SELECT @@session.range_alloc_block_size = 2048; 31@@session.range_alloc_block_size = 2048 320 33'#--------------------FN_DYNVARS_137_03-------------------------#' 34SET @@global.range_alloc_block_size = 2048; 35Warnings: 36Warning 1292 Truncated incorrect range_alloc_block_size value: '2048' 37SELECT @@global.range_alloc_block_size; 38@@global.range_alloc_block_size 394096 40SET @@global.range_alloc_block_size = 4294967295; 41Warnings: 42Warning 1292 Truncated incorrect range_alloc_block_size value: '4294967295' 43SELECT @@global.range_alloc_block_size; 44@@global.range_alloc_block_size 454294966272 46SET @@global.range_alloc_block_size = 4294967294; 47Warnings: 48Warning 1292 Truncated incorrect range_alloc_block_size value: '4294967294' 49SELECT @@global.range_alloc_block_size; 50@@global.range_alloc_block_size 514294966272 52'#--------------------FN_DYNVARS_137_04-------------------------#' 53SET @@session.range_alloc_block_size = 2048; 54Warnings: 55Warning 1292 Truncated incorrect range_alloc_block_size value: '2048' 56SELECT @@session.range_alloc_block_size; 57@@session.range_alloc_block_size 584096 59SET @@session.range_alloc_block_size = 4294967295; 60Warnings: 61Warning 1292 Truncated incorrect range_alloc_block_size value: '4294967295' 62SELECT @@session.range_alloc_block_size; 63@@session.range_alloc_block_size 644294966272 65SET @@session.range_alloc_block_size = 4294967294; 66Warnings: 67Warning 1292 Truncated incorrect range_alloc_block_size value: '4294967294' 68SELECT @@session.range_alloc_block_size; 69@@session.range_alloc_block_size 704294966272 71'#------------------FN_DYNVARS_137_05-----------------------#' 72SET @@global.range_alloc_block_size = 0; 73Warnings: 74Warning 1292 Truncated incorrect range_alloc_block_size value: '0' 75SELECT @@global.range_alloc_block_size; 76@@global.range_alloc_block_size 774096 78SET @@global.range_alloc_block_size = -1024; 79Warnings: 80Warning 1292 Truncated incorrect range_alloc_block_size value: '-1024' 81SELECT @@global.range_alloc_block_size; 82@@global.range_alloc_block_size 834096 84SET @@global.range_alloc_block_size = 42949672951; 85Warnings: 86Warning 1292 Truncated incorrect range_alloc_block_size value: '42949672951' 87SELECT @@global.range_alloc_block_size; 88@@global.range_alloc_block_size 894294966272 90SET @@global.range_alloc_block_size = 65530.34; 91ERROR 42000: Incorrect argument type to variable 'range_alloc_block_size' 92SELECT @@global.range_alloc_block_size; 93@@global.range_alloc_block_size 944294966272 95SET @@global.range_alloc_block_size = test; 96ERROR 42000: Incorrect argument type to variable 'range_alloc_block_size' 97SELECT @@global.range_alloc_block_size; 98@@global.range_alloc_block_size 994294966272 100SET @@session.range_alloc_block_size = 0; 101Warnings: 102Warning 1292 Truncated incorrect range_alloc_block_size value: '0' 103SELECT @@session.range_alloc_block_size; 104@@session.range_alloc_block_size 1054096 106SET @@session.range_alloc_block_size = -2; 107Warnings: 108Warning 1292 Truncated incorrect range_alloc_block_size value: '-2' 109SELECT @@session.range_alloc_block_size; 110@@session.range_alloc_block_size 1114096 112SET @@session.range_alloc_block_size = 65530.34; 113ERROR 42000: Incorrect argument type to variable 'range_alloc_block_size' 114SET @@session.range_alloc_block_size = 4294967296; 115Warnings: 116Warning 1292 Truncated incorrect range_alloc_block_size value: '4294967296' 117SELECT @@session.range_alloc_block_size; 118@@session.range_alloc_block_size 1194294966272 120SET @@session.range_alloc_block_size = test; 121ERROR 42000: Incorrect argument type to variable 'range_alloc_block_size' 122SELECT @@session.range_alloc_block_size; 123@@session.range_alloc_block_size 1244294966272 125'#------------------FN_DYNVARS_137_06-----------------------#' 126SELECT @@global.range_alloc_block_size = VARIABLE_VALUE 127FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 128WHERE VARIABLE_NAME='range_alloc_block_size'; 129@@global.range_alloc_block_size = VARIABLE_VALUE 1301 131'#------------------FN_DYNVARS_137_07-----------------------#' 132SELECT @@session.range_alloc_block_size = VARIABLE_VALUE 133FROM INFORMATION_SCHEMA.SESSION_VARIABLES 134WHERE VARIABLE_NAME='range_alloc_block_size'; 135@@session.range_alloc_block_size = VARIABLE_VALUE 1361 137'#------------------FN_DYNVARS_137_08-----------------------#' 138SET @@global.range_alloc_block_size = TRUE; 139Warnings: 140Warning 1292 Truncated incorrect range_alloc_block_size value: '1' 141SELECT @@global.range_alloc_block_size; 142@@global.range_alloc_block_size 1434096 144SET @@global.range_alloc_block_size = FALSE; 145Warnings: 146Warning 1292 Truncated incorrect range_alloc_block_size value: '0' 147SELECT @@global.range_alloc_block_size; 148@@global.range_alloc_block_size 1494096 150'#---------------------FN_DYNVARS_137_09----------------------#' 151SET @@global.range_alloc_block_size = 10; 152Warnings: 153Warning 1292 Truncated incorrect range_alloc_block_size value: '10' 154SELECT @@range_alloc_block_size = @@global.range_alloc_block_size; 155@@range_alloc_block_size = @@global.range_alloc_block_size 1560 157'#---------------------FN_DYNVARS_137_10----------------------#' 158SET @@range_alloc_block_size = 100; 159Warnings: 160Warning 1292 Truncated incorrect range_alloc_block_size value: '100' 161SELECT @@range_alloc_block_size = @@local.range_alloc_block_size; 162@@range_alloc_block_size = @@local.range_alloc_block_size 1631 164SELECT @@local.range_alloc_block_size = @@session.range_alloc_block_size; 165@@local.range_alloc_block_size = @@session.range_alloc_block_size 1661 167'#---------------------FN_DYNVARS_137_11----------------------#' 168SET range_alloc_block_size = 1; 169Warnings: 170Warning 1292 Truncated incorrect range_alloc_block_size value: '1' 171SELECT @@range_alloc_block_size; 172@@range_alloc_block_size 1734096 174SELECT local.range_alloc_block_size; 175ERROR 42S02: Unknown table 'local' in field list 176SELECT session.range_alloc_block_size; 177ERROR 42S02: Unknown table 'session' in field list 178SELECT range_alloc_block_size = @@session.range_alloc_block_size; 179ERROR 42S22: Unknown column 'range_alloc_block_size' in 'field list' 180SET @@global.range_alloc_block_size = @start_global_value; 181SELECT @@global.range_alloc_block_size; 182@@global.range_alloc_block_size 1834096 184SET @@session.range_alloc_block_size = @start_session_value; 185SELECT @@session.range_alloc_block_size; 186@@session.range_alloc_block_size 1874096 188