1SET @start_global_value = @@global.myisam_sort_buffer_size ; 2SELECT @@session.myisam_sort_buffer_size = @@global.myisam_sort_buffer_size; 3@@session.myisam_sort_buffer_size = @@global.myisam_sort_buffer_size 41 5SET @@global.myisam_sort_buffer_size= default; 6SET @default_myisam_sort_buffer_size= @@global.myisam_sort_buffer_size; 7'#--------------------FN_DYNVARS_005_01-------------------------#' 8SET @@global.myisam_sort_buffer_size = 100; 9Warnings: 10Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '100' 11SET @@global.myisam_sort_buffer_size = DEFAULT; 12SELECT @@global.myisam_sort_buffer_size = @default_myisam_sort_buffer_size; 13@@global.myisam_sort_buffer_size = @default_myisam_sort_buffer_size 141 15SET @@session.myisam_sort_buffer_size = 200; 16Warnings: 17Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '200' 18SET @@session.myisam_sort_buffer_size = DEFAULT; 19SELECT @@session.myisam_sort_buffer_size = @default_myisam_sort_buffer_size; 20@@session.myisam_sort_buffer_size = @default_myisam_sort_buffer_size 211 22'#--------------------FN_DYNVARS_005_03-------------------------#' 23SET @@global.myisam_sort_buffer_size = 4; 24Warnings: 25Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '4' 26SELECT @@global.myisam_sort_buffer_size ; 27@@global.myisam_sort_buffer_size 284096 29SET @@global.myisam_sort_buffer_size = 4294967295; 30SELECT @@global.myisam_sort_buffer_size ; 31@@global.myisam_sort_buffer_size 324294967295 33SET @@global.myisam_sort_buffer_size = 655354; 34SELECT @@global.myisam_sort_buffer_size ; 35@@global.myisam_sort_buffer_size 36655354 37'#--------------------FN_DYNVARS_005_04-------------------------#' 38SET @@session.myisam_sort_buffer_size = 4; 39Warnings: 40Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '4' 41SELECT @@session.myisam_sort_buffer_size ; 42@@session.myisam_sort_buffer_size 434096 44SET @@session.myisam_sort_buffer_size = 4294967295; 45SELECT @@session.myisam_sort_buffer_size ; 46@@session.myisam_sort_buffer_size 474294967295 48SET @@session.myisam_sort_buffer_size = 655345; 49SELECT @@session.myisam_sort_buffer_size ; 50@@session.myisam_sort_buffer_size 51655345 52'#------------------FN_DYNVARS_005_05-----------------------#' 53SET @@global.myisam_sort_buffer_size = 0; 54Warnings: 55Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '0' 56SELECT @@global.myisam_sort_buffer_size ; 57@@global.myisam_sort_buffer_size 584096 59SET @@global.myisam_sort_buffer_size = -1024; 60Warnings: 61Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '-1024' 62SELECT @@global.myisam_sort_buffer_size ; 63@@global.myisam_sort_buffer_size 644096 65SET @@global.myisam_sort_buffer_size = 429496729533; 66SELECT @@global.myisam_sort_buffer_size ; 67@@global.myisam_sort_buffer_size 684294967295 69SET @@global.myisam_sort_buffer_size = 65530.34; 70ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size' 71SELECT @@global.myisam_sort_buffer_size ; 72@@global.myisam_sort_buffer_size 734294967295 74SET @@global.myisam_sort_buffer_size = test; 75ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size' 76SELECT @@global.myisam_sort_buffer_size ; 77@@global.myisam_sort_buffer_size 784294967295 79SET @@global.myisam_sort_buffer_size = "test"; 80ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size' 81SELECT @@global.myisam_sort_buffer_size ; 82@@global.myisam_sort_buffer_size 834294967295 84SET @@global.myisam_sort_buffer_size = 'test'; 85ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size' 86SELECT @@global.myisam_sort_buffer_size ; 87@@global.myisam_sort_buffer_size 884294967295 89SET @@global.myisam_sort_buffer_size = ON; 90ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size' 91SELECT @@global.myisam_sort_buffer_size ; 92@@global.myisam_sort_buffer_size 934294967295 94SET @@session.myisam_sort_buffer_size = 0; 95Warnings: 96Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '0' 97SELECT @@session.myisam_sort_buffer_size ; 98@@session.myisam_sort_buffer_size 994096 100SET @@session.myisam_sort_buffer_size = -2; 101Warnings: 102Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '-2' 103SELECT @@session.myisam_sort_buffer_size ; 104@@session.myisam_sort_buffer_size 1054096 106SET @@session.myisam_sort_buffer_size = 65530.34; 107ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size' 108SELECT @@session.myisam_sort_buffer_size ; 109@@session.myisam_sort_buffer_size 1104096 111SET @@session.myisam_sort_buffer_size = test; 112ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size' 113SELECT @@session.myisam_sort_buffer_size ; 114@@session.myisam_sort_buffer_size 1154096 116SET @@session.myisam_sort_buffer_size = "test"; 117ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size' 118SELECT @@session.myisam_sort_buffer_size ; 119@@session.myisam_sort_buffer_size 1204096 121'#------------------FN_DYNVARS_005_06-----------------------#' 122SELECT @@global.myisam_sort_buffer_size = VARIABLE_VALUE 123FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 124WHERE VARIABLE_NAME='myisam_sort_buffer_size '; 125@@global.myisam_sort_buffer_size = VARIABLE_VALUE 1261 127'#------------------FN_DYNVARS_005_07-----------------------#' 128SELECT @@session.myisam_sort_buffer_size = VARIABLE_VALUE 129FROM INFORMATION_SCHEMA.SESSION_VARIABLES 130WHERE VARIABLE_NAME='myisam_sort_buffer_size '; 131@@session.myisam_sort_buffer_size = VARIABLE_VALUE 1321 133'#------------------FN_DYNVARS_005_08-----------------------#' 134SET @@global.myisam_sort_buffer_size = TRUE; 135Warnings: 136Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '1' 137SELECT @@global.myisam_sort_buffer_size ; 138@@global.myisam_sort_buffer_size 1394096 140SET @@global.myisam_sort_buffer_size = FALSE; 141Warnings: 142Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '0' 143SELECT @@global.myisam_sort_buffer_size ; 144@@global.myisam_sort_buffer_size 1454096 146'#---------------------FN_DYNVARS_001_09----------------------#' 147SET @@global.myisam_sort_buffer_size = 10; 148Warnings: 149Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '10' 150SELECT @@myisam_sort_buffer_size = @@global.myisam_sort_buffer_size ; 151@@myisam_sort_buffer_size = @@global.myisam_sort_buffer_size 1521 153'#---------------------FN_DYNVARS_001_10----------------------#' 154SET @@myisam_sort_buffer_size = 100; 155Warnings: 156Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '100' 157SELECT @@myisam_sort_buffer_size = @@local.myisam_sort_buffer_size ; 158@@myisam_sort_buffer_size = @@local.myisam_sort_buffer_size 1591 160SELECT @@local.myisam_sort_buffer_size = @@session.myisam_sort_buffer_size ; 161@@local.myisam_sort_buffer_size = @@session.myisam_sort_buffer_size 1621 163'#---------------------FN_DYNVARS_001_11----------------------#' 164SET myisam_sort_buffer_size = 1; 165Warnings: 166Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '1' 167SELECT @@myisam_sort_buffer_size ; 168@@myisam_sort_buffer_size 1694096 170SELECT local.myisam_sort_buffer_size ; 171ERROR 42S02: Unknown table 'local' in field list 172SELECT session.myisam_sort_buffer_size ; 173ERROR 42S02: Unknown table 'session' in field list 174SELECT myisam_sort_buffer_size = @@session.myisam_sort_buffer_size ; 175ERROR 42S22: Unknown column 'myisam_sort_buffer_size' in 'field list' 176SET @@global.myisam_sort_buffer_size = @start_global_value; 177