1SET @start_global_value = @@global.max_heap_table_size; 2SET @start_session_value = @@session.max_heap_table_size; 3SELECT @start_session_value = @start_global_value; 4@start_session_value = @start_global_value 51 6'#--------------------FN_DYNVARS_077_01-------------------------#' 7SET @@global.max_heap_table_size = 1677721610; 8Warnings: 9Warning 1292 Truncated incorrect max_heap_table_size value: '1677721610' 10SET @@global.max_heap_table_size = DEFAULT; 11SELECT @@global.max_heap_table_size > 0; 12@@global.max_heap_table_size > 0 131 14SET @@session.max_heap_table_size = 1677721610; 15Warnings: 16Warning 1292 Truncated incorrect max_heap_table_size value: '1677721610' 17SET @@session.max_heap_table_size = DEFAULT; 18SELECT @@session.max_heap_table_size > 0; 19@@session.max_heap_table_size > 0 201 21'#--------------------FN_DYNVARS_077_03-------------------------#' 22SET @@global.max_heap_table_size = 16384; 23SELECT @@global.max_heap_table_size; 24@@global.max_heap_table_size 2516384 26SET @@global.max_heap_table_size = 16385; 27Warnings: 28Warning 1292 Truncated incorrect max_heap_table_size value: '16385' 29SELECT @@global.max_heap_table_size; 30@@global.max_heap_table_size 3116384 32SET @@global.max_heap_table_size = 65535; 33Warnings: 34Warning 1292 Truncated incorrect max_heap_table_size value: '65535' 35SELECT @@global.max_heap_table_size; 36@@global.max_heap_table_size 3764512 38SET @@global.max_heap_table_size = 4294967294; 39Warnings: 40Warning 1292 Truncated incorrect max_heap_table_size value: '4294967294' 41SELECT @@global.max_heap_table_size; 42@@global.max_heap_table_size 434294966272 44SET @@global.max_heap_table_size = 4294967295; 45Warnings: 46Warning 1292 Truncated incorrect max_heap_table_size value: '4294967295' 47SELECT @@global.max_heap_table_size; 48@@global.max_heap_table_size 494294966272 50'#--------------------FN_DYNVARS_077_04-------------------------#' 51SET @@session.max_heap_table_size = 16384; 52SELECT @@session.max_heap_table_size; 53@@session.max_heap_table_size 5416384 55SET @@session.max_heap_table_size = 16385; 56Warnings: 57Warning 1292 Truncated incorrect max_heap_table_size value: '16385' 58SELECT @@session.max_heap_table_size; 59@@session.max_heap_table_size 6016384 61SET @@session.max_heap_table_size = 65535; 62Warnings: 63Warning 1292 Truncated incorrect max_heap_table_size value: '65535' 64SELECT @@session.max_heap_table_size; 65@@session.max_heap_table_size 6664512 67SET @@session.max_heap_table_size = 4294967294; 68Warnings: 69Warning 1292 Truncated incorrect max_heap_table_size value: '4294967294' 70SELECT @@session.max_heap_table_size; 71@@session.max_heap_table_size 724294966272 73SET @@session.max_heap_table_size = 4294967295; 74Warnings: 75Warning 1292 Truncated incorrect max_heap_table_size value: '4294967295' 76SELECT @@session.max_heap_table_size; 77@@session.max_heap_table_size 784294966272 79'#------------------FN_DYNVARS_077_05-----------------------#' 80SET @@global.max_heap_table_size = -1; 81Warnings: 82Warning 1292 Truncated incorrect max_heap_table_size value: '-1' 83SELECT @@global.max_heap_table_size; 84@@global.max_heap_table_size 8516384 86SET @@global.max_heap_table_size = -1024; 87Warnings: 88Warning 1292 Truncated incorrect max_heap_table_size value: '-1024' 89SELECT @@global.max_heap_table_size; 90@@global.max_heap_table_size 9116384 92SET @@global.max_heap_table_size = 1024; 93Warnings: 94Warning 1292 Truncated incorrect max_heap_table_size value: '1024' 95SELECT @@global.max_heap_table_size; 96@@global.max_heap_table_size 9716384 98SET @@global.max_heap_table_size = 16383; 99Warnings: 100Warning 1292 Truncated incorrect max_heap_table_size value: '16383' 101SELECT @@global.max_heap_table_size; 102@@global.max_heap_table_size 10316384 104SET @@global.max_heap_table_size = 4294967296; 105SELECT @@global.max_heap_table_size; 106@@global.max_heap_table_size 1074294967296 108SET @@global.max_heap_table_size = 65530.34; 109ERROR 42000: Incorrect argument type to variable 'max_heap_table_size' 110SELECT @@global.max_heap_table_size; 111@@global.max_heap_table_size 1124294967296 113SET @@global.max_heap_table_size = test; 114ERROR 42000: Incorrect argument type to variable 'max_heap_table_size' 115SELECT @@global.max_heap_table_size; 116@@global.max_heap_table_size 1174294967296 118SET @@session.max_heap_table_size = -1; 119Warnings: 120Warning 1292 Truncated incorrect max_heap_table_size value: '-1' 121SELECT @@session.max_heap_table_size; 122@@session.max_heap_table_size 12316384 124SET @@session.max_heap_table_size = 16383; 125Warnings: 126Warning 1292 Truncated incorrect max_heap_table_size value: '16383' 127SELECT @@session.max_heap_table_size; 128@@session.max_heap_table_size 12916384 130SET @@session.max_heap_table_size = 4294967296; 131SELECT @@session.max_heap_table_size; 132@@session.max_heap_table_size 1334294967296 134SET @@session.max_heap_table_size = 65530.34; 135ERROR 42000: Incorrect argument type to variable 'max_heap_table_size' 136SET @@session.max_heap_table_size = 10737418241; 137Warnings: 138Warning 1292 Truncated incorrect max_heap_table_size value: '10737418241' 139SELECT @@session.max_heap_table_size; 140@@session.max_heap_table_size 14110737418240 142SET @@session.max_heap_table_size = test; 143ERROR 42000: Incorrect argument type to variable 'max_heap_table_size' 144SELECT @@session.max_heap_table_size; 145@@session.max_heap_table_size 14610737418240 147'#------------------FN_DYNVARS_077_06-----------------------#' 148SELECT @@global.max_heap_table_size = VARIABLE_VALUE 149FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 150WHERE VARIABLE_NAME='max_heap_table_size'; 151@@global.max_heap_table_size = VARIABLE_VALUE 1521 153'#------------------FN_DYNVARS_077_07-----------------------#' 154SELECT @@session.max_heap_table_size = VARIABLE_VALUE 155FROM INFORMATION_SCHEMA.SESSION_VARIABLES 156WHERE VARIABLE_NAME='max_heap_table_size'; 157@@session.max_heap_table_size = VARIABLE_VALUE 1581 159'#------------------FN_DYNVARS_077_08-----------------------#' 160SET @@global.max_heap_table_size = TRUE; 161Warnings: 162Warning 1292 Truncated incorrect max_heap_table_size value: '1' 163SELECT @@global.max_heap_table_size; 164@@global.max_heap_table_size 16516384 166SET @@global.max_heap_table_size = FALSE; 167Warnings: 168Warning 1292 Truncated incorrect max_heap_table_size value: '0' 169SELECT @@global.max_heap_table_size; 170@@global.max_heap_table_size 17116384 172'#---------------------FN_DYNVARS_077_09----------------------#' 173SET @@global.max_heap_table_size = 163845; 174Warnings: 175Warning 1292 Truncated incorrect max_heap_table_size value: '163845' 176SELECT @@max_heap_table_size = @@global.max_heap_table_size; 177@@max_heap_table_size = @@global.max_heap_table_size 1780 179'#---------------------FN_DYNVARS_077_10----------------------#' 180SET @@max_heap_table_size = 16777216; 181SELECT @@max_heap_table_size = @@local.max_heap_table_size; 182@@max_heap_table_size = @@local.max_heap_table_size 1831 184SELECT @@local.max_heap_table_size = @@session.max_heap_table_size; 185@@local.max_heap_table_size = @@session.max_heap_table_size 1861 187'#---------------------FN_DYNVARS_077_11----------------------#' 188SET max_heap_table_size = 316777216; 189Warnings: 190Warning 1292 Truncated incorrect max_heap_table_size value: '316777216' 191SELECT @@max_heap_table_size; 192@@max_heap_table_size 193316776448 194SELECT local.max_heap_table_size; 195ERROR 42S02: Unknown table 'local' in field list 196SELECT session.max_heap_table_size; 197ERROR 42S02: Unknown table 'session' in field list 198SELECT max_heap_table_size = @@session.max_heap_table_size; 199ERROR 42S22: Unknown column 'max_heap_table_size' in 'field list' 200SET @@global.max_heap_table_size = @start_global_value; 201