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 = ON; 65ERROR 42000: Incorrect argument type to variable 'tmp_table_size' 66SET @@global.tmp_table_size = OFF; 67ERROR 42000: Incorrect argument type to variable 'tmp_table_size' 68SET @@global.tmp_table_size = True; 69Warnings: 70Warning 1292 Truncated incorrect tmp_table_size value: '1' 71SELECT @@global.tmp_table_size; 72@@global.tmp_table_size 731024 74SET @@global.tmp_table_size = False; 75Warnings: 76Warning 1292 Truncated incorrect tmp_table_size value: '0' 77SELECT @@global.tmp_table_size; 78@@global.tmp_table_size 791024 80SET @@global.tmp_table_size = 65530.34; 81ERROR 42000: Incorrect argument type to variable 'tmp_table_size' 82SET @@global.tmp_table_size ="Test"; 83ERROR 42000: Incorrect argument type to variable 'tmp_table_size' 84SET @@session.tmp_table_size = ON; 85ERROR 42000: Incorrect argument type to variable 'tmp_table_size' 86SET @@session.tmp_table_size = OFF; 87ERROR 42000: Incorrect argument type to variable 'tmp_table_size' 88SET @@session.tmp_table_size = True; 89Warnings: 90Warning 1292 Truncated incorrect tmp_table_size value: '1' 91SELECT @@session.tmp_table_size; 92@@session.tmp_table_size 931024 94SET @@session.tmp_table_size = False; 95Warnings: 96Warning 1292 Truncated incorrect tmp_table_size value: '0' 97SELECT @@session.tmp_table_size; 98@@session.tmp_table_size 991024 100SET @@session.tmp_table_size = "Test"; 101ERROR 42000: Incorrect argument type to variable 'tmp_table_size' 102SET @@session.tmp_table_size = 12345678901; 103SELECT @@session.tmp_table_size IN (12345678901,4294967295); 104@@session.tmp_table_size IN (12345678901,4294967295) 1051 106'#------------------FN_DYNVARS_005_06-----------------------#' 107SELECT @@global.tmp_table_size = VARIABLE_VALUE 108FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 109WHERE VARIABLE_NAME='tmp_table_size'; 110@@global.tmp_table_size = VARIABLE_VALUE 1111 112'#------------------FN_DYNVARS_005_07-----------------------#' 113SELECT @@session.tmp_table_size = VARIABLE_VALUE 114FROM INFORMATION_SCHEMA.SESSION_VARIABLES 115WHERE VARIABLE_NAME='tmp_table_size'; 116@@session.tmp_table_size = VARIABLE_VALUE 1171 118'#---------------------FN_DYNVARS_001_09----------------------#' 119SET @@global.tmp_table_size = 1024; 120SET @@tmp_table_size = 4294967295; 121SELECT @@tmp_table_size = @@global.tmp_table_size; 122@@tmp_table_size = @@global.tmp_table_size 1230 124'#---------------------FN_DYNVARS_001_10----------------------#' 125SET @@tmp_table_size = 100; 126Warnings: 127Warning 1292 Truncated incorrect tmp_table_size value: '100' 128SELECT @@tmp_table_size = @@local.tmp_table_size; 129@@tmp_table_size = @@local.tmp_table_size 1301 131SELECT @@local.tmp_table_size = @@session.tmp_table_size; 132@@local.tmp_table_size = @@session.tmp_table_size 1331 134'#---------------------FN_DYNVARS_001_11----------------------#' 135SET tmp_table_size = 1027; 136SELECT @@tmp_table_size; 137@@tmp_table_size 1381027 139SELECT local.tmp_table_size; 140ERROR 42S02: Unknown table 'local' in field list 141SELECT global.tmp_table_size; 142ERROR 42S02: Unknown table 'global' in field list 143SELECT tmp_table_size = @@session.tmp_table_size; 144ERROR 42S22: Unknown column 'tmp_table_size' in 'field list' 145SET @@global.tmp_table_size = @start_global_value; 146SET @@session.tmp_table_size = @start_session_value; 147