1SET @start_global_value = @@global.max_heap_table_size; 2SELECT @start_global_value; 3@start_global_value 41048576 5SET @start_session_value = @@session.max_heap_table_size; 6SELECT @start_session_value; 7@start_session_value 81048576 9'#--------------------FN_DYNVARS_077_01-------------------------#' 10SET @@global.max_heap_table_size = 1677721610; 11Warnings: 12Warning 1292 Truncated incorrect max_heap_table_size value: '1677721610' 13SET @@global.max_heap_table_size = DEFAULT; 14SELECT @@global.max_heap_table_size; 15@@global.max_heap_table_size 1616777216 17SET @@session.max_heap_table_size = 1677721610; 18Warnings: 19Warning 1292 Truncated incorrect max_heap_table_size value: '1677721610' 20SET @@session.max_heap_table_size = DEFAULT; 21SELECT @@session.max_heap_table_size; 22@@session.max_heap_table_size 2316777216 24'#--------------------FN_DYNVARS_077_02-------------------------#' 25SET @@global.max_heap_table_size = DEFAULT; 26SELECT @@global.max_heap_table_size = 16777216; 27@@global.max_heap_table_size = 16777216 281 29SET @@session.max_heap_table_size = DEFAULT; 30SELECT @@session.max_heap_table_size = 16777216; 31@@session.max_heap_table_size = 16777216 321 33'#--------------------FN_DYNVARS_077_03-------------------------#' 34SET @@global.max_heap_table_size = 16384; 35SELECT @@global.max_heap_table_size; 36@@global.max_heap_table_size 3716384 38SET @@global.max_heap_table_size = 16385; 39Warnings: 40Warning 1292 Truncated incorrect max_heap_table_size value: '16385' 41SELECT @@global.max_heap_table_size; 42@@global.max_heap_table_size 4316384 44SET @@global.max_heap_table_size = 65535; 45Warnings: 46Warning 1292 Truncated incorrect max_heap_table_size value: '65535' 47SELECT @@global.max_heap_table_size; 48@@global.max_heap_table_size 4964512 50SET @@global.max_heap_table_size = 4294967294; 51Warnings: 52Warning 1292 Truncated incorrect max_heap_table_size value: '4294967294' 53SELECT @@global.max_heap_table_size; 54@@global.max_heap_table_size 554294966272 56SET @@global.max_heap_table_size = 4294967295; 57Warnings: 58Warning 1292 Truncated incorrect max_heap_table_size value: '4294967295' 59SELECT @@global.max_heap_table_size; 60@@global.max_heap_table_size 614294966272 62'#--------------------FN_DYNVARS_077_04-------------------------#' 63SET @@session.max_heap_table_size = 16384; 64SELECT @@session.max_heap_table_size; 65@@session.max_heap_table_size 6616384 67SET @@session.max_heap_table_size = 16385; 68Warnings: 69Warning 1292 Truncated incorrect max_heap_table_size value: '16385' 70SELECT @@session.max_heap_table_size; 71@@session.max_heap_table_size 7216384 73SET @@session.max_heap_table_size = 65535; 74Warnings: 75Warning 1292 Truncated incorrect max_heap_table_size value: '65535' 76SELECT @@session.max_heap_table_size; 77@@session.max_heap_table_size 7864512 79SET @@session.max_heap_table_size = 4294967294; 80Warnings: 81Warning 1292 Truncated incorrect max_heap_table_size value: '4294967294' 82SELECT @@session.max_heap_table_size; 83@@session.max_heap_table_size 844294966272 85SET @@session.max_heap_table_size = 4294967295; 86Warnings: 87Warning 1292 Truncated incorrect max_heap_table_size value: '4294967295' 88SELECT @@session.max_heap_table_size; 89@@session.max_heap_table_size 904294966272 91'#------------------FN_DYNVARS_077_05-----------------------#' 92SET @@global.max_heap_table_size = -1; 93Warnings: 94Warning 1292 Truncated incorrect max_heap_table_size value: '-1' 95SELECT @@global.max_heap_table_size; 96@@global.max_heap_table_size 9716384 98SET @@global.max_heap_table_size = -1024; 99Warnings: 100Warning 1292 Truncated incorrect max_heap_table_size value: '-1024' 101SELECT @@global.max_heap_table_size; 102@@global.max_heap_table_size 10316384 104SET @@global.max_heap_table_size = 1024; 105Warnings: 106Warning 1292 Truncated incorrect max_heap_table_size value: '1024' 107SELECT @@global.max_heap_table_size; 108@@global.max_heap_table_size 10916384 110SET @@global.max_heap_table_size = 16383; 111Warnings: 112Warning 1292 Truncated incorrect max_heap_table_size value: '16383' 113SELECT @@global.max_heap_table_size; 114@@global.max_heap_table_size 11516384 116SET @@global.max_heap_table_size = 4294967296; 117SELECT @@global.max_heap_table_size; 118@@global.max_heap_table_size 1194294967296 120SET @@global.max_heap_table_size = 65530.34; 121ERROR 42000: Incorrect argument type to variable 'max_heap_table_size' 122SELECT @@global.max_heap_table_size; 123@@global.max_heap_table_size 1244294967296 125SET @@global.max_heap_table_size = test; 126ERROR 42000: Incorrect argument type to variable 'max_heap_table_size' 127SELECT @@global.max_heap_table_size; 128@@global.max_heap_table_size 1294294967296 130SET @@global.max_heap_table_size = ' '; 131ERROR 42000: Incorrect argument type to variable 'max_heap_table_size' 132SELECT @@global.max_heap_table_size; 133@@global.max_heap_table_size 1344294967296 135SET @@session.max_heap_table_size = -1; 136Warnings: 137Warning 1292 Truncated incorrect max_heap_table_size value: '-1' 138SELECT @@session.max_heap_table_size; 139@@session.max_heap_table_size 14016384 141SET @@session.max_heap_table_size = 16383; 142Warnings: 143Warning 1292 Truncated incorrect max_heap_table_size value: '16383' 144SELECT @@session.max_heap_table_size; 145@@session.max_heap_table_size 14616384 147SET @@session.max_heap_table_size = 4294967296; 148SELECT @@session.max_heap_table_size; 149@@session.max_heap_table_size 1504294967296 151SET @@session.max_heap_table_size = 65530.34; 152ERROR 42000: Incorrect argument type to variable 'max_heap_table_size' 153SET @@session.max_heap_table_size = 10737418241; 154Warnings: 155Warning 1292 Truncated incorrect max_heap_table_size value: '10737418241' 156SELECT @@session.max_heap_table_size; 157@@session.max_heap_table_size 15810737418240 159SET @@session.max_heap_table_size = test; 160ERROR 42000: Incorrect argument type to variable 'max_heap_table_size' 161SELECT @@session.max_heap_table_size; 162@@session.max_heap_table_size 16310737418240 164SET @@session.max_heap_table_size = ' '; 165ERROR 42000: Incorrect argument type to variable 'max_heap_table_size' 166SELECT @@session.max_heap_table_size; 167@@session.max_heap_table_size 16810737418240 169'#------------------FN_DYNVARS_077_06-----------------------#' 170SELECT @@global.max_heap_table_size = VARIABLE_VALUE 171FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 172WHERE VARIABLE_NAME='max_heap_table_size'; 173@@global.max_heap_table_size = VARIABLE_VALUE 1741 175'#------------------FN_DYNVARS_077_07-----------------------#' 176SELECT @@session.max_heap_table_size = VARIABLE_VALUE 177FROM INFORMATION_SCHEMA.SESSION_VARIABLES 178WHERE VARIABLE_NAME='max_heap_table_size'; 179@@session.max_heap_table_size = VARIABLE_VALUE 1801 181'#------------------FN_DYNVARS_077_08-----------------------#' 182SET @@global.max_heap_table_size = TRUE; 183Warnings: 184Warning 1292 Truncated incorrect max_heap_table_size value: '1' 185SELECT @@global.max_heap_table_size; 186@@global.max_heap_table_size 18716384 188SET @@global.max_heap_table_size = FALSE; 189Warnings: 190Warning 1292 Truncated incorrect max_heap_table_size value: '0' 191SELECT @@global.max_heap_table_size; 192@@global.max_heap_table_size 19316384 194'#---------------------FN_DYNVARS_077_09----------------------#' 195SET @@global.max_heap_table_size = 163845; 196Warnings: 197Warning 1292 Truncated incorrect max_heap_table_size value: '163845' 198SELECT @@max_heap_table_size = @@global.max_heap_table_size; 199@@max_heap_table_size = @@global.max_heap_table_size 2000 201'#---------------------FN_DYNVARS_077_10----------------------#' 202SET @@max_heap_table_size = 16777216; 203SELECT @@max_heap_table_size = @@local.max_heap_table_size; 204@@max_heap_table_size = @@local.max_heap_table_size 2051 206SELECT @@local.max_heap_table_size = @@session.max_heap_table_size; 207@@local.max_heap_table_size = @@session.max_heap_table_size 2081 209'#---------------------FN_DYNVARS_077_11----------------------#' 210SET max_heap_table_size = 316777216; 211Warnings: 212Warning 1292 Truncated incorrect max_heap_table_size value: '316777216' 213SELECT @@max_heap_table_size; 214@@max_heap_table_size 215316776448 216SELECT local.max_heap_table_size; 217ERROR 42S02: Unknown table 'local' in field list 218SELECT session.max_heap_table_size; 219ERROR 42S02: Unknown table 'session' in field list 220SELECT max_heap_table_size = @@session.max_heap_table_size; 221ERROR 42S22: Unknown column 'max_heap_table_size' in 'field list' 222SET @@global.max_heap_table_size = @start_global_value; 223SELECT @@global.max_heap_table_size; 224@@global.max_heap_table_size 2251048576 226SET @@session.max_heap_table_size = @start_session_value; 227SELECT @@session.max_heap_table_size; 228@@session.max_heap_table_size 2291048576 230