1SET @start_global_value = @@global.tmp_table_size; 2SET @start_session_value = @@session.tmp_table_size; 3'#--------------------FN_DYNVARS_005_01-------------------------#' 4SET @@global.tmp_table_size = 100; 5Warnings: 6Warning 1292 Truncated incorrect tmp_table_size value: '100' 7SET @@global.tmp_table_size = DEFAULT; 8SET @@session.tmp_table_size = 200; 9Warnings: 10Warning 1292 Truncated incorrect tmp_table_size value: '200' 11SET @@session.tmp_table_size = DEFAULT; 12'#--------------------FN_DYNVARS_005_02-------------------------#' 13SELECT @@global.tmp_table_size >= 16777216; 14@@global.tmp_table_size >= 16777216 151 16SELECT @@session.tmp_table_size >= 16777216; 17@@session.tmp_table_size >= 16777216 181 19'#--------------------FN_DYNVARS_005_03-------------------------#' 20SET @@global.tmp_table_size = 1024; 21SELECT @@global.tmp_table_size; 22@@global.tmp_table_size 231024 24SET @@global.tmp_table_size = 60020; 25SELECT @@global.tmp_table_size; 26@@global.tmp_table_size 2760020 28SET @@global.tmp_table_size = 4294967295; 29SELECT @@global.tmp_table_size; 30@@global.tmp_table_size 314294967295 32'#--------------------FN_DYNVARS_005_04-------------------------#' 33SET @@session.tmp_table_size = 1024; 34SELECT @@session.tmp_table_size; 35@@session.tmp_table_size 361024 37SET @@session.tmp_table_size = 4294967295; 38SELECT @@session.tmp_table_size; 39@@session.tmp_table_size 404294967295 41SET @@session.tmp_table_size = 65535; 42SELECT @@session.tmp_table_size; 43@@session.tmp_table_size 4465535 45'#------------------FN_DYNVARS_005_05-----------------------#' 46SET @@global.tmp_table_size = 0; 47Warnings: 48Warning 1292 Truncated incorrect tmp_table_size value: '0' 49SELECT @@global.tmp_table_size; 50@@global.tmp_table_size 511024 52SET @@global.tmp_table_size = -1024; 53Warnings: 54Warning 1292 Truncated incorrect tmp_table_size value: '-1024' 55SELECT @@global.tmp_table_size; 56@@global.tmp_table_size 571024 58SET @@global.tmp_table_size = 1000; 59Warnings: 60Warning 1292 Truncated incorrect tmp_table_size value: '1000' 61SELECT @@global.tmp_table_size; 62@@global.tmp_table_size 631024 64SET @@global.tmp_table_size = 4294967299; 65SELECT @@global.tmp_table_size; 66@@global.tmp_table_size 674294967299 68SET @@global.tmp_table_size = ' '; 69ERROR 42000: Incorrect argument type to variable 'tmp_table_size' 70SELECT @@global.tmp_table_size; 71@@global.tmp_table_size 724294967299 73SET @@global.tmp_table_size = ON; 74ERROR 42000: Incorrect argument type to variable 'tmp_table_size' 75SET @@global.tmp_table_size = OFF; 76ERROR 42000: Incorrect argument type to variable 'tmp_table_size' 77SET @@global.tmp_table_size = True; 78Warnings: 79Warning 1292 Truncated incorrect tmp_table_size value: '1' 80SELECT @@global.tmp_table_size; 81@@global.tmp_table_size 821024 83SET @@global.tmp_table_size = False; 84Warnings: 85Warning 1292 Truncated incorrect tmp_table_size value: '0' 86SELECT @@global.tmp_table_size; 87@@global.tmp_table_size 881024 89SET @@global.tmp_table_size = 65530.34; 90ERROR 42000: Incorrect argument type to variable 'tmp_table_size' 91SET @@global.tmp_table_size ="Test"; 92ERROR 42000: Incorrect argument type to variable 'tmp_table_size' 93SET @@session.tmp_table_size = ON; 94ERROR 42000: Incorrect argument type to variable 'tmp_table_size' 95SET @@session.tmp_table_size = OFF; 96ERROR 42000: Incorrect argument type to variable 'tmp_table_size' 97SET @@session.tmp_table_size = True; 98Warnings: 99Warning 1292 Truncated incorrect tmp_table_size value: '1' 100SELECT @@session.tmp_table_size; 101@@session.tmp_table_size 1021024 103SET @@session.tmp_table_size = 65530.34; 104ERROR 42000: Incorrect argument type to variable 'tmp_table_size' 105SET @@session.tmp_table_size = False; 106Warnings: 107Warning 1292 Truncated incorrect tmp_table_size value: '0' 108SELECT @@session.tmp_table_size; 109@@session.tmp_table_size 1101024 111SET @@session.tmp_table_size = "Test"; 112ERROR 42000: Incorrect argument type to variable 'tmp_table_size' 113SET @@session.tmp_table_size = ' '; 114ERROR 42000: Incorrect argument type to variable 'tmp_table_size' 115SELECT @@session.tmp_table_size; 116@@session.tmp_table_size 1171024 118SET @@session.tmp_table_size = 1000; 119Warnings: 120Warning 1292 Truncated incorrect tmp_table_size value: '1000' 121SELECT @@session.tmp_table_size; 122@@session.tmp_table_size 1231024 124SET @@session.tmp_table_size = 12345678901; 125SELECT @@session.tmp_table_size IN (12345678901,4294967295); 126@@session.tmp_table_size IN (12345678901,4294967295) 1271 128'#------------------FN_DYNVARS_005_06-----------------------#' 129SELECT @@global.tmp_table_size = VARIABLE_VALUE 130FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 131WHERE VARIABLE_NAME='tmp_table_size'; 132@@global.tmp_table_size = VARIABLE_VALUE 1331 134'#------------------FN_DYNVARS_005_07-----------------------#' 135SELECT @@session.tmp_table_size = VARIABLE_VALUE 136FROM INFORMATION_SCHEMA.SESSION_VARIABLES 137WHERE VARIABLE_NAME='tmp_table_size'; 138@@session.tmp_table_size = VARIABLE_VALUE 1391 140'#---------------------FN_DYNVARS_001_09----------------------#' 141SET @@global.tmp_table_size = 1024; 142SET @@tmp_table_size = 4294967295; 143SELECT @@tmp_table_size = @@global.tmp_table_size; 144@@tmp_table_size = @@global.tmp_table_size 1450 146'#---------------------FN_DYNVARS_001_10----------------------#' 147SET @@tmp_table_size = 100; 148Warnings: 149Warning 1292 Truncated incorrect tmp_table_size value: '100' 150SELECT @@tmp_table_size = @@local.tmp_table_size; 151@@tmp_table_size = @@local.tmp_table_size 1521 153SELECT @@local.tmp_table_size = @@session.tmp_table_size; 154@@local.tmp_table_size = @@session.tmp_table_size 1551 156'#---------------------FN_DYNVARS_001_11----------------------#' 157SET tmp_table_size = 1027; 158SELECT @@tmp_table_size; 159@@tmp_table_size 1601027 161SELECT local.tmp_table_size; 162ERROR 42S02: Unknown table 'local' in field list 163SELECT global.tmp_table_size; 164ERROR 42S02: Unknown table 'global' in field list 165SELECT tmp_table_size = @@session.tmp_table_size; 166ERROR 42S22: Unknown column 'tmp_table_size' in 'field list' 167SET @@global.tmp_table_size = @start_global_value; 168SET @@session.tmp_table_size = @start_session_value; 169