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 82097152 9SET @@session.sort_buffer_size = 2000; 10SET @@session.sort_buffer_size = DEFAULT; 11SELECT @@session.sort_buffer_size; 12@@session.sort_buffer_size 132097152 14'#--------------------FN_DYNVARS_151_02-------------------------#' 15SET @@global.sort_buffer_size = DEFAULT; 16SELECT @@global.sort_buffer_size; 17@@global.sort_buffer_size 182097152 19SET @@session.sort_buffer_size = DEFAULT; 20SELECT @@session.sort_buffer_size; 21@@session.sort_buffer_size 222097152 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 651024 66SET @@global.sort_buffer_size = 4294967296; 67SELECT @@global.sort_buffer_size; 68@@global.sort_buffer_size 69max_sort_buffer_size 70SET @@global.sort_buffer_size = 1024*1024; 71SET @@global.sort_buffer_size = 65530.34; 72ERROR 42000: Incorrect argument type to variable 'sort_buffer_size' 73SELECT @@global.sort_buffer_size; 74@@global.sort_buffer_size 751048576 76SET @@global.sort_buffer_size = test; 77ERROR 42000: Incorrect argument type to variable 'sort_buffer_size' 78SELECT @@global.sort_buffer_size; 79@@global.sort_buffer_size 801048576 81SET @@session.sort_buffer_size = 32775; 82SELECT @@session.sort_buffer_size; 83@@session.sort_buffer_size 8432775 85SET @@session.sort_buffer_size = -2; 86SELECT @@session.sort_buffer_size; 87@@session.sort_buffer_size 881024 89SET @@session.sort_buffer_size = 65530.34; 90ERROR 42000: Incorrect argument type to variable 'sort_buffer_size' 91SET @@session.sort_buffer_size = 4294967295; 92SELECT @@session.sort_buffer_size; 93@@session.sort_buffer_size 944294967295 95SET @@session.sort_buffer_size = test; 96ERROR 42000: Incorrect argument type to variable 'sort_buffer_size' 97'#------------------FN_DYNVARS_151_06-----------------------#' 98SELECT @@global.sort_buffer_size = VARIABLE_VALUE FROM 99INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='sort_buffer_size'; 100@@global.sort_buffer_size = VARIABLE_VALUE 1011 102'#------------------FN_DYNVARS_151_07-----------------------#' 103SELECT @@session.sort_buffer_size = VARIABLE_VALUE FROM 104INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='sort_buffer_size'; 105@@session.sort_buffer_size = VARIABLE_VALUE 1061 107'#------------------FN_DYNVARS_151_08-----------------------#' 108SET @@global.sort_buffer_size = TRUE; 109SELECT @@global.sort_buffer_size; 110@@global.sort_buffer_size 1111024 112SET @@global.sort_buffer_size = FALSE; 113SELECT @@global.sort_buffer_size; 114@@global.sort_buffer_size 1151024 116'#---------------------FN_DYNVARS_151_09----------------------#' 117SET @@global.sort_buffer_size = 9000; 118SELECT @@sort_buffer_size = @@global.sort_buffer_size; 119@@sort_buffer_size = @@global.sort_buffer_size 1200 121'#---------------------FN_DYNVARS_151_10----------------------#' 122SET @@sort_buffer_size = 9000; 123SELECT @@sort_buffer_size = @@local.sort_buffer_size; 124@@sort_buffer_size = @@local.sort_buffer_size 1251 126SELECT @@local.sort_buffer_size = @@session.sort_buffer_size; 127@@local.sort_buffer_size = @@session.sort_buffer_size 1281 129'#---------------------FN_DYNVARS_151_11----------------------#' 130SET sort_buffer_size = 9100; 131SELECT @@sort_buffer_size; 132@@sort_buffer_size 1339100 134SELECT local.sort_buffer_size; 135ERROR 42S02: Unknown table 'local' in field list 136SELECT session.sort_buffer_size; 137ERROR 42S02: Unknown table 'session' in field list 138SELECT sort_buffer_size = @@session.sort_buffer_size; 139ERROR 42S22: Unknown column 'sort_buffer_size' in 'field list' 140SET @@global.sort_buffer_size = @start_global_value; 141SET @@session.sort_buffer_size = @start_session_value; 142