1SET @start_global_value = @@global.max_tmp_tables; 2SELECT @start_global_value; 3@start_global_value 432 5SET @start_session_value = @@session.max_tmp_tables; 6SELECT @start_session_value; 7@start_session_value 832 9'#--------------------FN_DYNVARS_086_01-------------------------#' 10SET @@global.max_tmp_tables = 1000; 11Warnings: 12Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 13SET @@global.max_tmp_tables = DEFAULT; 14Warnings: 15Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 16SELECT @@global.max_tmp_tables; 17@@global.max_tmp_tables 1832 19SET @@session.max_tmp_tables = 1000; 20Warnings: 21Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 22SET @@session.max_tmp_tables = DEFAULT; 23Warnings: 24Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 25SELECT @@session.max_tmp_tables; 26@@session.max_tmp_tables 2732 28'#--------------------FN_DYNVARS_086_02-------------------------#' 29SET @@global.max_tmp_tables = DEFAULT; 30Warnings: 31Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 32SELECT @@global.max_tmp_tables = 32; 33@@global.max_tmp_tables = 32 341 35SET @@session.max_tmp_tables = DEFAULT; 36Warnings: 37Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 38SELECT @@session.max_tmp_tables = 32; 39@@session.max_tmp_tables = 32 401 41'#--------------------FN_DYNVARS_086_03-------------------------#' 42SET @@global.max_tmp_tables = 1; 43Warnings: 44Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 45SELECT @@global.max_tmp_tables; 46@@global.max_tmp_tables 471 48SET @@global.max_tmp_tables = 2; 49Warnings: 50Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 51SELECT @@global.max_tmp_tables; 52@@global.max_tmp_tables 532 54SET @@global.max_tmp_tables = 65536; 55Warnings: 56Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 57SELECT @@global.max_tmp_tables; 58@@global.max_tmp_tables 5965536 60SET @@global.max_tmp_tables = 4294967295; 61Warnings: 62Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 63SELECT @@global.max_tmp_tables; 64@@global.max_tmp_tables 654294967295 66SET @@global.max_tmp_tables = 4294967294; 67Warnings: 68Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 69SELECT @@global.max_tmp_tables; 70@@global.max_tmp_tables 714294967294 72'#--------------------FN_DYNVARS_086_04-------------------------#' 73SET @@session.max_tmp_tables = 1; 74Warnings: 75Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 76SELECT @@session.max_tmp_tables; 77@@session.max_tmp_tables 781 79SET @@session.max_tmp_tables = 2; 80Warnings: 81Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 82SELECT @@session.max_tmp_tables; 83@@session.max_tmp_tables 842 85SET @@session.max_tmp_tables = 65536; 86Warnings: 87Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 88SELECT @@session.max_tmp_tables; 89@@session.max_tmp_tables 9065536 91SET @@session.max_tmp_tables = 4294967295; 92Warnings: 93Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 94SELECT @@session.max_tmp_tables; 95@@session.max_tmp_tables 964294967295 97SET @@session.max_tmp_tables = 4294967294; 98Warnings: 99Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 100SELECT @@session.max_tmp_tables; 101@@session.max_tmp_tables 1024294967294 103'#------------------FN_DYNVARS_086_05-----------------------#' 104SET @@global.max_tmp_tables = -1024; 105Warnings: 106Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 107Warning 1292 Truncated incorrect max_tmp_tables value: '-1024' 108SELECT @@global.max_tmp_tables; 109@@global.max_tmp_tables 1101 111SET @@global.max_tmp_tables = 4294967296; 112Warnings: 113Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 114Warning 1292 Truncated incorrect max_tmp_tables value: '4294967296' 115SELECT @@global.max_tmp_tables; 116@@global.max_tmp_tables 1174294967295 118SET @@global.max_tmp_tables = -1; 119Warnings: 120Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 121Warning 1292 Truncated incorrect max_tmp_tables value: '-1' 122SELECT @@global.max_tmp_tables; 123@@global.max_tmp_tables 1241 125SET @@global.max_tmp_tables = 429496729500; 126Warnings: 127Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 128Warning 1292 Truncated incorrect max_tmp_tables value: '429496729500' 129SELECT @@global.max_tmp_tables; 130@@global.max_tmp_tables 1314294967295 132SET @@global.max_tmp_tables = 65530.34; 133ERROR 42000: Incorrect argument type to variable 'max_tmp_tables' 134SELECT @@global.max_tmp_tables; 135@@global.max_tmp_tables 1364294967295 137SET @@global.max_tmp_tables = test; 138ERROR 42000: Incorrect argument type to variable 'max_tmp_tables' 139SELECT @@global.max_tmp_tables; 140@@global.max_tmp_tables 1414294967295 142SET @@session.max_tmp_tables = 4294967296; 143Warnings: 144Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 145Warning 1292 Truncated incorrect max_tmp_tables value: '4294967296' 146SELECT @@session.max_tmp_tables; 147@@session.max_tmp_tables 1484294967295 149SET @@session.max_tmp_tables = -1; 150Warnings: 151Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 152Warning 1292 Truncated incorrect max_tmp_tables value: '-1' 153SELECT @@session.max_tmp_tables; 154@@session.max_tmp_tables 1551 156SET @@session.max_tmp_tables = 429496729500; 157Warnings: 158Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 159Warning 1292 Truncated incorrect max_tmp_tables value: '429496729500' 160SELECT @@session.max_tmp_tables; 161@@session.max_tmp_tables 1624294967295 163SET @@session.max_tmp_tables = -001; 164Warnings: 165Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 166Warning 1292 Truncated incorrect max_tmp_tables value: '-1' 167SELECT @@session.max_tmp_tables; 168@@session.max_tmp_tables 1691 170SET @@session.max_tmp_tables = 65530.34; 171ERROR 42000: Incorrect argument type to variable 'max_tmp_tables' 172SET @@session.max_tmp_tables = 10737418241; 173Warnings: 174Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 175Warning 1292 Truncated incorrect max_tmp_tables value: '10737418241' 176SELECT @@session.max_tmp_tables; 177@@session.max_tmp_tables 1784294967295 179SET @@session.max_tmp_tables = test; 180ERROR 42000: Incorrect argument type to variable 'max_tmp_tables' 181SELECT @@session.max_tmp_tables; 182@@session.max_tmp_tables 1834294967295 184'#------------------FN_DYNVARS_086_06-----------------------#' 185SELECT @@global.max_tmp_tables = VARIABLE_VALUE 186FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 187WHERE VARIABLE_NAME='max_tmp_tables'; 188@@global.max_tmp_tables = VARIABLE_VALUE 1891 190'#------------------FN_DYNVARS_086_07-----------------------#' 191SELECT @@session.max_tmp_tables = VARIABLE_VALUE 192FROM INFORMATION_SCHEMA.SESSION_VARIABLES 193WHERE VARIABLE_NAME='max_tmp_tables'; 194@@session.max_tmp_tables = VARIABLE_VALUE 1951 196'#------------------FN_DYNVARS_086_08-----------------------#' 197SET @@global.max_tmp_tables = TRUE; 198Warnings: 199Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 200SELECT @@global.max_tmp_tables; 201@@global.max_tmp_tables 2021 203SET @@global.max_tmp_tables = FALSE; 204Warnings: 205Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 206Warning 1292 Truncated incorrect max_tmp_tables value: '0' 207SELECT @@global.max_tmp_tables; 208@@global.max_tmp_tables 2091 210'#---------------------FN_DYNVARS_086_09----------------------#' 211SET @@global.max_tmp_tables = 20; 212Warnings: 213Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 214SELECT @@max_tmp_tables = @@global.max_tmp_tables; 215@@max_tmp_tables = @@global.max_tmp_tables 2160 217'#---------------------FN_DYNVARS_086_10----------------------#' 218SET @@max_tmp_tables = 255; 219Warnings: 220Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 221SELECT @@max_tmp_tables = @@local.max_tmp_tables; 222@@max_tmp_tables = @@local.max_tmp_tables 2231 224SELECT @@local.max_tmp_tables = @@session.max_tmp_tables; 225@@local.max_tmp_tables = @@session.max_tmp_tables 2261 227'#---------------------FN_DYNVARS_086_11----------------------#' 228SET max_tmp_tables = 102; 229Warnings: 230Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 231SELECT @@max_tmp_tables; 232@@max_tmp_tables 233102 234SELECT local.max_tmp_tables; 235ERROR 42S02: Unknown table 'local' in field list 236SELECT session.max_tmp_tables; 237ERROR 42S02: Unknown table 'session' in field list 238SELECT max_tmp_tables = @@session.max_tmp_tables; 239ERROR 42S22: Unknown column 'max_tmp_tables' in 'field list' 240SET @@global.max_tmp_tables = @start_global_value; 241Warnings: 242Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 243SELECT @@global.max_tmp_tables; 244@@global.max_tmp_tables 24532 246SET @@session.max_tmp_tables = @start_session_value; 247Warnings: 248Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release 249SELECT @@session.max_tmp_tables; 250@@session.max_tmp_tables 25132 252