1SET @start_global_value = @@global.join_buffer_size; 2SELECT @start_global_value; 3@start_global_value 4262144 5SET @start_session_value = @@session.join_buffer_size; 6SELECT @start_session_value; 7@start_session_value 8262144 9'#--------------------FN_DYNVARS_053_01-------------------------#' 10SET @@global.join_buffer_size = DEFAULT; 11SELECT @@global.join_buffer_size; 12@@global.join_buffer_size 13262144 14SET @@session.join_buffer_size = DEFAULT; 15SELECT @@session.join_buffer_size; 16@@session.join_buffer_size 17262144 18'#--------------------FN_DYNVARS_053_03-------------------------#' 19SET @@global.join_buffer_size = 8200; 20Warnings: 21Warning 1292 Truncated incorrect join_buffer_size value: '8200' 22SELECT @@global.join_buffer_size; 23@@global.join_buffer_size 248192 25SET @@global.join_buffer_size = 65536; 26SELECT @@global.join_buffer_size; 27@@global.join_buffer_size 2865536 29SET @@global.join_buffer_size = 4294967295; 30Warnings: 31Warning 1292 Truncated incorrect join_buffer_size value: '4294967295' 32SELECT @@global.join_buffer_size; 33@@global.join_buffer_size 344294967168 35'#--------------------FN_DYNVARS_053_04-------------------------#' 36SET @@session.join_buffer_size = 8200; 37Warnings: 38Warning 1292 Truncated incorrect join_buffer_size value: '8200' 39SELECT @@session.join_buffer_size; 40@@session.join_buffer_size 418192 42SET @@session.join_buffer_size = 65536; 43SELECT @@session.join_buffer_size; 44@@session.join_buffer_size 4565536 46SET @@session.join_buffer_size = 4294967295; 47Warnings: 48Warning 1292 Truncated incorrect join_buffer_size value: '4294967295' 49SELECT @@session.join_buffer_size; 50@@session.join_buffer_size 514294967168 52'#------------------FN_DYNVARS_053_05-----------------------#' 53SET @@global.join_buffer_size = 0; 54Warnings: 55Warning 1292 Truncated incorrect join_buffer_size value: '0' 56SELECT @@global.join_buffer_size; 57@@global.join_buffer_size 58128 59SET @@global.join_buffer_size = -1024; 60Warnings: 61Warning 1292 Truncated incorrect join_buffer_size value: '-1024' 62SELECT @@global.join_buffer_size; 63@@global.join_buffer_size 64128 65SET @@global.join_buffer_size = 127; 66Warnings: 67Warning 1292 Truncated incorrect join_buffer_size value: '127' 68SELECT @@global.join_buffer_size; 69@@global.join_buffer_size 70128 71SET @@global.join_buffer_size = 42949672951; 72Warnings: 73Warning 1292 Truncated incorrect join_buffer_size value: '42949672951' 74SELECT @@global.join_buffer_size; 75@@global.join_buffer_size 7642949672832 77SET @@global.join_buffer_size = 65530.34; 78ERROR 42000: Incorrect argument type to variable 'join_buffer_size' 79SELECT @@global.join_buffer_size; 80@@global.join_buffer_size 8142949672832 82SET @@global.join_buffer_size = test; 83ERROR 42000: Incorrect argument type to variable 'join_buffer_size' 84SELECT @@global.join_buffer_size; 85@@global.join_buffer_size 8642949672832 87SET @@session.join_buffer_size = 0; 88Warnings: 89Warning 1292 Truncated incorrect join_buffer_size value: '0' 90SELECT @@session.join_buffer_size; 91@@session.join_buffer_size 92128 93SET @@session.join_buffer_size = -1024; 94Warnings: 95Warning 1292 Truncated incorrect join_buffer_size value: '-1024' 96SELECT @@session.join_buffer_size; 97@@session.join_buffer_size 98128 99SET @@session.join_buffer_size = 127; 100Warnings: 101Warning 1292 Truncated incorrect join_buffer_size value: '127' 102SELECT @@session.join_buffer_size; 103@@session.join_buffer_size 104128 105SET @@session.join_buffer_size = 42949672951; 106Warnings: 107Warning 1292 Truncated incorrect join_buffer_size value: '42949672951' 108SELECT @@session.join_buffer_size; 109@@session.join_buffer_size 11042949672832 111SET @@session.join_buffer_size = 65530.34; 112ERROR 42000: Incorrect argument type to variable 'join_buffer_size' 113SELECT @@session.join_buffer_size; 114@@session.join_buffer_size 11542949672832 116SET @@session.join_buffer_size = test; 117ERROR 42000: Incorrect argument type to variable 'join_buffer_size' 118SELECT @@session.join_buffer_size; 119@@session.join_buffer_size 12042949672832 121'#------------------FN_DYNVARS_053_06-----------------------#' 122SELECT @@global.join_buffer_size = VARIABLE_VALUE 123FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 124WHERE VARIABLE_NAME='join_buffer_size'; 125@@global.join_buffer_size = VARIABLE_VALUE 1261 127'#------------------FN_DYNVARS_053_07-----------------------#' 128SELECT @@session.join_buffer_size = VARIABLE_VALUE 129FROM INFORMATION_SCHEMA.SESSION_VARIABLES 130WHERE VARIABLE_NAME='join_buffer_size'; 131@@session.join_buffer_size = VARIABLE_VALUE 1321 133'#------------------FN_DYNVARS_053_08-----------------------#' 134SET @@global.join_buffer_size = TRUE; 135Warnings: 136Warning 1292 Truncated incorrect join_buffer_size value: '1' 137SET @@global.join_buffer_size = FALSE; 138Warnings: 139Warning 1292 Truncated incorrect join_buffer_size value: '0' 140'#---------------------FN_DYNVARS_001_09----------------------#' 141SET @@global.join_buffer_size = 10; 142Warnings: 143Warning 1292 Truncated incorrect join_buffer_size value: '10' 144SELECT @@join_buffer_size = @@global.join_buffer_size; 145@@join_buffer_size = @@global.join_buffer_size 1460 147'#---------------------FN_DYNVARS_001_10----------------------#' 148SET @@join_buffer_size = 100; 149Warnings: 150Warning 1292 Truncated incorrect join_buffer_size value: '100' 151SELECT @@join_buffer_size = @@local.join_buffer_size; 152@@join_buffer_size = @@local.join_buffer_size 1531 154SELECT @@local.join_buffer_size = @@session.join_buffer_size; 155@@local.join_buffer_size = @@session.join_buffer_size 1561 157'#---------------------FN_DYNVARS_001_11----------------------#' 158SET join_buffer_size = 1; 159Warnings: 160Warning 1292 Truncated incorrect join_buffer_size value: '1' 161SELECT @@join_buffer_size; 162@@join_buffer_size 163128 164SELECT local.join_buffer_size; 165ERROR 42S02: Unknown table 'local' in field list 166SELECT session.join_buffer_size; 167ERROR 42S02: Unknown table 'session' in field list 168SELECT join_buffer_size = @@session.join_buffer_size; 169ERROR 42S22: Unknown column 'join_buffer_size' in 'field list' 170SET @@global.join_buffer_size = @start_global_value; 171SELECT @@global.join_buffer_size; 172@@global.join_buffer_size 173262144 174SET @@session.join_buffer_size = @start_session_value; 175SELECT @@session.join_buffer_size; 176@@session.join_buffer_size 177262144 178