1SET @start_global_value = @@global.max_tmp_tables; 2Warnings: 3Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 4SELECT @start_global_value; 5@start_global_value 632 7SET @start_session_value = @@session.max_tmp_tables; 8Warnings: 9Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 10SELECT @start_session_value; 11@start_session_value 1232 13'#--------------------FN_DYNVARS_086_01-------------------------#' 14SET @@global.max_tmp_tables = 1000; 15Warnings: 16Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 17SET @@global.max_tmp_tables = DEFAULT; 18Warnings: 19Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 20SELECT @@global.max_tmp_tables; 21@@global.max_tmp_tables 2232 23Warnings: 24Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 25SET @@session.max_tmp_tables = 1000; 26Warnings: 27Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 28SET @@session.max_tmp_tables = DEFAULT; 29Warnings: 30Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 31SELECT @@session.max_tmp_tables; 32@@session.max_tmp_tables 3332 34Warnings: 35Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 36'#--------------------FN_DYNVARS_086_02-------------------------#' 37SET @@global.max_tmp_tables = DEFAULT; 38Warnings: 39Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 40SELECT @@global.max_tmp_tables = 32; 41@@global.max_tmp_tables = 32 421 43Warnings: 44Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 45SET @@session.max_tmp_tables = DEFAULT; 46Warnings: 47Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 48SELECT @@session.max_tmp_tables = 32; 49@@session.max_tmp_tables = 32 501 51Warnings: 52Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 53'#--------------------FN_DYNVARS_086_03-------------------------#' 54SET @@global.max_tmp_tables = 1; 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 591 60Warnings: 61Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 62SET @@global.max_tmp_tables = 2; 63Warnings: 64Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 65SELECT @@global.max_tmp_tables; 66@@global.max_tmp_tables 672 68Warnings: 69Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 70SET @@global.max_tmp_tables = 65536; 71Warnings: 72Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 73SELECT @@global.max_tmp_tables; 74@@global.max_tmp_tables 7565536 76Warnings: 77Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 78SET @@global.max_tmp_tables = 4294967295; 79Warnings: 80Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 81SELECT @@global.max_tmp_tables; 82@@global.max_tmp_tables 834294967295 84Warnings: 85Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 86SET @@global.max_tmp_tables = 4294967294; 87Warnings: 88Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 89SELECT @@global.max_tmp_tables; 90@@global.max_tmp_tables 914294967294 92Warnings: 93Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 94'#--------------------FN_DYNVARS_086_04-------------------------#' 95SET @@session.max_tmp_tables = 1; 96Warnings: 97Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 98SELECT @@session.max_tmp_tables; 99@@session.max_tmp_tables 1001 101Warnings: 102Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 103SET @@session.max_tmp_tables = 2; 104Warnings: 105Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 106SELECT @@session.max_tmp_tables; 107@@session.max_tmp_tables 1082 109Warnings: 110Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 111SET @@session.max_tmp_tables = 65536; 112Warnings: 113Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 114SELECT @@session.max_tmp_tables; 115@@session.max_tmp_tables 11665536 117Warnings: 118Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 119SET @@session.max_tmp_tables = 4294967295; 120Warnings: 121Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 122SELECT @@session.max_tmp_tables; 123@@session.max_tmp_tables 1244294967295 125Warnings: 126Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 127SET @@session.max_tmp_tables = 4294967294; 128Warnings: 129Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 130SELECT @@session.max_tmp_tables; 131@@session.max_tmp_tables 1324294967294 133Warnings: 134Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 135'#------------------FN_DYNVARS_086_05-----------------------#' 136SET @@global.max_tmp_tables = -1024; 137Warnings: 138Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 139Warning 1292 Truncated incorrect max_tmp_tables value: '-1024' 140SELECT @@global.max_tmp_tables; 141@@global.max_tmp_tables 1421 143Warnings: 144Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 145SET @@global.max_tmp_tables = 4294967296; 146Warnings: 147Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 148SELECT @@global.max_tmp_tables; 149@@global.max_tmp_tables 1504294967296 151Warnings: 152Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 153SET @@global.max_tmp_tables = -1; 154Warnings: 155Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 156Warning 1292 Truncated incorrect max_tmp_tables value: '-1' 157SELECT @@global.max_tmp_tables; 158@@global.max_tmp_tables 1591 160Warnings: 161Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 162SET @@global.max_tmp_tables = 429496729500; 163Warnings: 164Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 165SELECT @@global.max_tmp_tables; 166@@global.max_tmp_tables 167429496729500 168Warnings: 169Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 170SET @@global.max_tmp_tables = 65530.34; 171ERROR 42000: Incorrect argument type to variable 'max_tmp_tables' 172SELECT @@global.max_tmp_tables; 173@@global.max_tmp_tables 174429496729500 175Warnings: 176Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 177SET @@global.max_tmp_tables = test; 178ERROR 42000: Incorrect argument type to variable 'max_tmp_tables' 179SELECT @@global.max_tmp_tables; 180@@global.max_tmp_tables 181429496729500 182Warnings: 183Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 184SET @@session.max_tmp_tables = 4294967296; 185Warnings: 186Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 187SELECT @@session.max_tmp_tables; 188@@session.max_tmp_tables 1894294967296 190Warnings: 191Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 192SET @@session.max_tmp_tables = -1; 193Warnings: 194Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 195Warning 1292 Truncated incorrect max_tmp_tables value: '-1' 196SELECT @@session.max_tmp_tables; 197@@session.max_tmp_tables 1981 199Warnings: 200Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 201SET @@session.max_tmp_tables = 429496729500; 202Warnings: 203Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 204SELECT @@session.max_tmp_tables; 205@@session.max_tmp_tables 206429496729500 207Warnings: 208Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 209SET @@session.max_tmp_tables = -001; 210Warnings: 211Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 212Warning 1292 Truncated incorrect max_tmp_tables value: '-1' 213SELECT @@session.max_tmp_tables; 214@@session.max_tmp_tables 2151 216Warnings: 217Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 218SET @@session.max_tmp_tables = 65530.34; 219ERROR 42000: Incorrect argument type to variable 'max_tmp_tables' 220SET @@session.max_tmp_tables = 10737418241; 221Warnings: 222Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 223SELECT @@session.max_tmp_tables; 224@@session.max_tmp_tables 22510737418241 226Warnings: 227Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 228SET @@session.max_tmp_tables = test; 229ERROR 42000: Incorrect argument type to variable 'max_tmp_tables' 230SELECT @@session.max_tmp_tables; 231@@session.max_tmp_tables 23210737418241 233Warnings: 234Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 235'#------------------FN_DYNVARS_086_06-----------------------#' 236SELECT VARIABLE_VALUE 237FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 238WHERE VARIABLE_NAME='max_tmp_tables' 239into @tmp; 240SELECT @@global.max_tmp_tables = @tmp; 241@@global.max_tmp_tables = @tmp 2421 243Warnings: 244Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 245'#------------------FN_DYNVARS_086_07-----------------------#' 246SELECT VARIABLE_VALUE 247FROM INFORMATION_SCHEMA.SESSION_VARIABLES 248WHERE VARIABLE_NAME='max_tmp_tables' 249into @tmp; 250SELECT @@session.max_tmp_tables = @tmp; 251@@session.max_tmp_tables = @tmp 2521 253Warnings: 254Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 255'#------------------FN_DYNVARS_086_08-----------------------#' 256SET @@global.max_tmp_tables = TRUE; 257Warnings: 258Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 259SELECT @@global.max_tmp_tables; 260@@global.max_tmp_tables 2611 262Warnings: 263Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 264SET @@global.max_tmp_tables = FALSE; 265Warnings: 266Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 267Warning 1292 Truncated incorrect max_tmp_tables value: '0' 268SELECT @@global.max_tmp_tables; 269@@global.max_tmp_tables 2701 271Warnings: 272Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 273'#---------------------FN_DYNVARS_086_09----------------------#' 274SET @@global.max_tmp_tables = 20; 275Warnings: 276Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 277SELECT @@max_tmp_tables = @@global.max_tmp_tables; 278@@max_tmp_tables = @@global.max_tmp_tables 2790 280Warnings: 281Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 282Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 283'#---------------------FN_DYNVARS_086_10----------------------#' 284SET @@max_tmp_tables = 255; 285Warnings: 286Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 287SELECT @@max_tmp_tables = @@local.max_tmp_tables; 288@@max_tmp_tables = @@local.max_tmp_tables 2891 290Warnings: 291Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 292Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 293SELECT @@local.max_tmp_tables = @@session.max_tmp_tables; 294@@local.max_tmp_tables = @@session.max_tmp_tables 2951 296Warnings: 297Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 298Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 299'#---------------------FN_DYNVARS_086_11----------------------#' 300SET max_tmp_tables = 102; 301Warnings: 302Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 303SELECT @@max_tmp_tables; 304@@max_tmp_tables 305102 306Warnings: 307Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 308SELECT local.max_tmp_tables; 309ERROR 42S02: Unknown table 'local' in field list 310SELECT session.max_tmp_tables; 311ERROR 42S02: Unknown table 'session' in field list 312SELECT max_tmp_tables = @@session.max_tmp_tables; 313ERROR 42S22: Unknown column 'max_tmp_tables' in 'field list' 314SET @@global.max_tmp_tables = @start_global_value; 315Warnings: 316Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 317SELECT @@global.max_tmp_tables; 318@@global.max_tmp_tables 31932 320Warnings: 321Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 322SET @@session.max_tmp_tables = @start_session_value; 323Warnings: 324Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 325SELECT @@session.max_tmp_tables; 326@@session.max_tmp_tables 32732 328Warnings: 329Warning 1287 '@@max_tmp_tables' is deprecated and will be removed in a future release. 330