1SET @start_global_value = @@global.myisam_sort_buffer_size ; 2SELECT @start_global_value; 3@start_global_value 48388608 5SET @start_session_value = @@session.myisam_sort_buffer_size ; 6SELECT @start_session_value; 7@start_session_value 88388608 9'#--------------------FN_DYNVARS_005_01-------------------------#' 10SET @@global.myisam_sort_buffer_size = 100; 11Warnings: 12Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '100' 13SET @@global.myisam_sort_buffer_size = DEFAULT; 14SELECT @@global.myisam_sort_buffer_size ; 15@@global.myisam_sort_buffer_size 168388608 17SET @@session.myisam_sort_buffer_size = 200; 18Warnings: 19Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '200' 20SET @@session.myisam_sort_buffer_size = DEFAULT; 21SELECT @@session.myisam_sort_buffer_size ; 22@@session.myisam_sort_buffer_size 238388608 24'#--------------------FN_DYNVARS_005_02-------------------------#' 25SET @@global.myisam_sort_buffer_size = DEFAULT; 26SELECT @@global.myisam_sort_buffer_size = 8388608; 27@@global.myisam_sort_buffer_size = 8388608 281 29SET @@session.myisam_sort_buffer_size = DEFAULT; 30SELECT @@session.myisam_sort_buffer_size = 8388608; 31@@session.myisam_sort_buffer_size = 8388608 321 33'#--------------------FN_DYNVARS_005_03-------------------------#' 34SET @@global.myisam_sort_buffer_size = 4; 35Warnings: 36Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '4' 37SELECT @@global.myisam_sort_buffer_size ; 38@@global.myisam_sort_buffer_size 394096 40SET @@global.myisam_sort_buffer_size = 4294967295; 41SELECT @@global.myisam_sort_buffer_size ; 42@@global.myisam_sort_buffer_size 434294967295 44SET @@global.myisam_sort_buffer_size = 655354; 45SELECT @@global.myisam_sort_buffer_size ; 46@@global.myisam_sort_buffer_size 47655354 48'#--------------------FN_DYNVARS_005_04-------------------------#' 49SET @@session.myisam_sort_buffer_size = 4; 50Warnings: 51Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '4' 52SELECT @@session.myisam_sort_buffer_size ; 53@@session.myisam_sort_buffer_size 544096 55SET @@session.myisam_sort_buffer_size = 4294967295; 56SELECT @@session.myisam_sort_buffer_size ; 57@@session.myisam_sort_buffer_size 584294967295 59SET @@session.myisam_sort_buffer_size = 655345; 60SELECT @@session.myisam_sort_buffer_size ; 61@@session.myisam_sort_buffer_size 62655345 63'#------------------FN_DYNVARS_005_05-----------------------#' 64SET @@global.myisam_sort_buffer_size = 0; 65Warnings: 66Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '0' 67SELECT @@global.myisam_sort_buffer_size ; 68@@global.myisam_sort_buffer_size 694096 70SET @@global.myisam_sort_buffer_size = -1024; 71Warnings: 72Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '-1024' 73SELECT @@global.myisam_sort_buffer_size ; 74@@global.myisam_sort_buffer_size 754096 76SET @@global.myisam_sort_buffer_size = 429496729533; 77Warnings: 78Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '429496729533' 79SELECT @@global.myisam_sort_buffer_size ; 80@@global.myisam_sort_buffer_size 814294967295 82SET @@global.myisam_sort_buffer_size = 65530.34; 83ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size' 84SELECT @@global.myisam_sort_buffer_size ; 85@@global.myisam_sort_buffer_size 864294967295 87SET @@global.myisam_sort_buffer_size = test; 88ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size' 89SELECT @@global.myisam_sort_buffer_size ; 90@@global.myisam_sort_buffer_size 914294967295 92SET @@global.myisam_sort_buffer_size = "test"; 93ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size' 94SELECT @@global.myisam_sort_buffer_size ; 95@@global.myisam_sort_buffer_size 964294967295 97SET @@global.myisam_sort_buffer_size = 'test'; 98ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size' 99SELECT @@global.myisam_sort_buffer_size ; 100@@global.myisam_sort_buffer_size 1014294967295 102SET @@global.myisam_sort_buffer_size = ON; 103ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size' 104SELECT @@global.myisam_sort_buffer_size ; 105@@global.myisam_sort_buffer_size 1064294967295 107SET @@session.myisam_sort_buffer_size = 0; 108Warnings: 109Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '0' 110SELECT @@session.myisam_sort_buffer_size ; 111@@session.myisam_sort_buffer_size 1124096 113SET @@session.myisam_sort_buffer_size = -2; 114Warnings: 115Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '-2' 116SELECT @@session.myisam_sort_buffer_size ; 117@@session.myisam_sort_buffer_size 1184096 119SET @@session.myisam_sort_buffer_size = 65530.34; 120ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size' 121SELECT @@session.myisam_sort_buffer_size ; 122@@session.myisam_sort_buffer_size 1234096 124SET @@session.myisam_sort_buffer_size = test; 125ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size' 126SELECT @@session.myisam_sort_buffer_size ; 127@@session.myisam_sort_buffer_size 1284096 129SET @@session.myisam_sort_buffer_size = "test"; 130ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size' 131SELECT @@session.myisam_sort_buffer_size ; 132@@session.myisam_sort_buffer_size 1334096 134'#------------------FN_DYNVARS_005_06-----------------------#' 135SELECT @@global.myisam_sort_buffer_size = VARIABLE_VALUE 136FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 137WHERE VARIABLE_NAME='myisam_sort_buffer_size '; 138@@global.myisam_sort_buffer_size = VARIABLE_VALUE 1391 140'#------------------FN_DYNVARS_005_07-----------------------#' 141SELECT @@session.myisam_sort_buffer_size = VARIABLE_VALUE 142FROM INFORMATION_SCHEMA.SESSION_VARIABLES 143WHERE VARIABLE_NAME='myisam_sort_buffer_size '; 144@@session.myisam_sort_buffer_size = VARIABLE_VALUE 1451 146'#------------------FN_DYNVARS_005_08-----------------------#' 147SET @@global.myisam_sort_buffer_size = TRUE; 148Warnings: 149Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '1' 150SELECT @@global.myisam_sort_buffer_size ; 151@@global.myisam_sort_buffer_size 1524096 153SET @@global.myisam_sort_buffer_size = FALSE; 154Warnings: 155Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '0' 156SELECT @@global.myisam_sort_buffer_size ; 157@@global.myisam_sort_buffer_size 1584096 159'#---------------------FN_DYNVARS_001_09----------------------#' 160SET @@global.myisam_sort_buffer_size = 10; 161Warnings: 162Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '10' 163SELECT @@myisam_sort_buffer_size = @@global.myisam_sort_buffer_size ; 164@@myisam_sort_buffer_size = @@global.myisam_sort_buffer_size 1651 166'#---------------------FN_DYNVARS_001_10----------------------#' 167SET @@myisam_sort_buffer_size = 100; 168Warnings: 169Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '100' 170SELECT @@myisam_sort_buffer_size = @@local.myisam_sort_buffer_size ; 171@@myisam_sort_buffer_size = @@local.myisam_sort_buffer_size 1721 173SELECT @@local.myisam_sort_buffer_size = @@session.myisam_sort_buffer_size ; 174@@local.myisam_sort_buffer_size = @@session.myisam_sort_buffer_size 1751 176'#---------------------FN_DYNVARS_001_11----------------------#' 177SET myisam_sort_buffer_size = 1; 178Warnings: 179Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '1' 180SELECT @@myisam_sort_buffer_size ; 181@@myisam_sort_buffer_size 1824096 183SELECT local.myisam_sort_buffer_size ; 184ERROR 42S02: Unknown table 'local' in field list 185SELECT session.myisam_sort_buffer_size ; 186ERROR 42S02: Unknown table 'session' in field list 187SELECT myisam_sort_buffer_size = @@session.myisam_sort_buffer_size ; 188ERROR 42S22: Unknown column 'myisam_sort_buffer_size' in 'field list' 189SET @@global.myisam_sort_buffer_size = @start_global_value; 190SELECT @@global.myisam_sort_buffer_size ; 191@@global.myisam_sort_buffer_size 1928388608 193SET @@session.myisam_sort_buffer_size = @start_session_value; 194SELECT @@session.myisam_sort_buffer_size ; 195@@session.myisam_sort_buffer_size 1968388608 197