1SET @start_global_value = @@global.sort_buffer_size; 2SET @start_session_value = @@session.sort_buffer_size; 3'#--------------------FN_DYNVARS_151_01-------------------------#' 4SET @@global.sort_buffer_size = 1000; 5SET @@global.sort_buffer_size = DEFAULT; 6SELECT @@global.sort_buffer_size; 7@@global.sort_buffer_size 8262144 9SET @@session.sort_buffer_size = 2000; 10SET @@session.sort_buffer_size = DEFAULT; 11SELECT @@session.sort_buffer_size; 12@@session.sort_buffer_size 13262144 14'#--------------------FN_DYNVARS_151_02-------------------------#' 15SET @@global.sort_buffer_size = DEFAULT; 16SELECT @@global.sort_buffer_size; 17@@global.sort_buffer_size 18262144 19SET @@session.sort_buffer_size = DEFAULT; 20SELECT @@session.sort_buffer_size; 21@@session.sort_buffer_size 22262144 23'#--------------------FN_DYNVARS_151_03-------------------------#' 24SET @@global.sort_buffer_size = 32776; 25SELECT @@global.sort_buffer_size; 26@@global.sort_buffer_size 2732776 28SET @@global.sort_buffer_size = 32777; 29SELECT @@global.sort_buffer_size; 30@@global.sort_buffer_size 3132777 32SET @@global.sort_buffer_size = 4294967295; 33SELECT @@global.sort_buffer_size; 34@@global.sort_buffer_size 354294967295 36SET @@global.sort_buffer_size = 4294967294; 37SELECT @@global.sort_buffer_size; 38@@global.sort_buffer_size 394294967294 40'#--------------------FN_DYNVARS_151_04-------------------------#' 41SET @@session.sort_buffer_size = 32776; 42SELECT @@session.sort_buffer_size; 43@@session.sort_buffer_size 4432776 45SET @@session.sort_buffer_size = 32777; 46SELECT @@session.sort_buffer_size; 47@@session.sort_buffer_size 4832777 49SET @@session.sort_buffer_size = 4294967295; 50SELECT @@session.sort_buffer_size; 51@@session.sort_buffer_size 524294967295 53SET @@session.sort_buffer_size = 4294967294; 54SELECT @@session.sort_buffer_size; 55@@session.sort_buffer_size 564294967294 57'#------------------FN_DYNVARS_151_05-----------------------#' 58SET @@global.sort_buffer_size = 32775; 59SELECT @@global.sort_buffer_size; 60@@global.sort_buffer_size 6132775 62SET @@global.sort_buffer_size = -1024; 63SELECT @@global.sort_buffer_size; 64@@global.sort_buffer_size 6532768 66SET @@global.sort_buffer_size = 4294967296; 67SELECT @@global.sort_buffer_size; 68@@global.sort_buffer_size 694294967295 70SET @@global.sort_buffer_size = 65530.34; 71ERROR 42000: Incorrect argument type to variable 'sort_buffer_size' 72SELECT @@global.sort_buffer_size; 73@@global.sort_buffer_size 744294967295 75SET @@global.sort_buffer_size = test; 76ERROR 42000: Incorrect argument type to variable 'sort_buffer_size' 77SELECT @@global.sort_buffer_size; 78@@global.sort_buffer_size 794294967295 80SET @@session.sort_buffer_size = 32775; 81SELECT @@session.sort_buffer_size; 82@@session.sort_buffer_size 8332775 84SET @@session.sort_buffer_size = -2; 85SELECT @@session.sort_buffer_size; 86@@session.sort_buffer_size 8732768 88SET @@session.sort_buffer_size = 65530.34; 89ERROR 42000: Incorrect argument type to variable 'sort_buffer_size' 90SET @@session.sort_buffer_size = 4294967296; 91SELECT @@session.sort_buffer_size; 92@@session.sort_buffer_size 934294967295 94SET @@session.sort_buffer_size = test; 95ERROR 42000: Incorrect argument type to variable 'sort_buffer_size' 96'#------------------FN_DYNVARS_151_06-----------------------#' 97SELECT @@global.sort_buffer_size = VARIABLE_VALUE FROM 98INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='sort_buffer_size'; 99@@global.sort_buffer_size = VARIABLE_VALUE 1001 101'#------------------FN_DYNVARS_151_07-----------------------#' 102SELECT @@session.sort_buffer_size = VARIABLE_VALUE FROM 103INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='sort_buffer_size'; 104@@session.sort_buffer_size = VARIABLE_VALUE 1051 106'#------------------FN_DYNVARS_151_08-----------------------#' 107SET @@global.sort_buffer_size = TRUE; 108SELECT @@global.sort_buffer_size; 109@@global.sort_buffer_size 11032768 111SET @@global.sort_buffer_size = FALSE; 112SELECT @@global.sort_buffer_size; 113@@global.sort_buffer_size 11432768 115'#---------------------FN_DYNVARS_151_09----------------------#' 116SET @@global.sort_buffer_size = 9000; 117SELECT @@sort_buffer_size = @@global.sort_buffer_size; 118@@sort_buffer_size = @@global.sort_buffer_size 1190 120'#---------------------FN_DYNVARS_151_10----------------------#' 121SET @@sort_buffer_size = 9000; 122SELECT @@sort_buffer_size = @@local.sort_buffer_size; 123@@sort_buffer_size = @@local.sort_buffer_size 1241 125SELECT @@local.sort_buffer_size = @@session.sort_buffer_size; 126@@local.sort_buffer_size = @@session.sort_buffer_size 1271 128'#---------------------FN_DYNVARS_151_11----------------------#' 129SET sort_buffer_size = 9100; 130SELECT @@sort_buffer_size; 131@@sort_buffer_size 13232768 133SELECT local.sort_buffer_size; 134ERROR 42S02: Unknown table 'local' in field list 135SELECT session.sort_buffer_size; 136ERROR 42S02: Unknown table 'session' in field list 137SELECT sort_buffer_size = @@session.sort_buffer_size; 138ERROR 42S22: Unknown column 'sort_buffer_size' in 'field list' 139SET @@global.sort_buffer_size = @start_global_value; 140SET @@session.sort_buffer_size = @start_session_value; 141