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; 77SELECT @@global.myisam_sort_buffer_size ; 78@@global.myisam_sort_buffer_size 79429496729533 80SET @@global.myisam_sort_buffer_size = 65530.34; 81ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size' 82SELECT @@global.myisam_sort_buffer_size ; 83@@global.myisam_sort_buffer_size 84429496729533 85SET @@global.myisam_sort_buffer_size = test; 86ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size' 87SELECT @@global.myisam_sort_buffer_size ; 88@@global.myisam_sort_buffer_size 89429496729533 90SET @@global.myisam_sort_buffer_size = "test"; 91ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size' 92SELECT @@global.myisam_sort_buffer_size ; 93@@global.myisam_sort_buffer_size 94429496729533 95SET @@global.myisam_sort_buffer_size = 'test'; 96ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size' 97SELECT @@global.myisam_sort_buffer_size ; 98@@global.myisam_sort_buffer_size 99429496729533 100SET @@global.myisam_sort_buffer_size = ON; 101ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size' 102SELECT @@global.myisam_sort_buffer_size ; 103@@global.myisam_sort_buffer_size 104429496729533 105SET @@session.myisam_sort_buffer_size = 0; 106Warnings: 107Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '0' 108SELECT @@session.myisam_sort_buffer_size ; 109@@session.myisam_sort_buffer_size 1104096 111SET @@session.myisam_sort_buffer_size = -2; 112Warnings: 113Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '-2' 114SELECT @@session.myisam_sort_buffer_size ; 115@@session.myisam_sort_buffer_size 1164096 117SET @@session.myisam_sort_buffer_size = 65530.34; 118ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size' 119SELECT @@session.myisam_sort_buffer_size ; 120@@session.myisam_sort_buffer_size 1214096 122SET @@session.myisam_sort_buffer_size = test; 123ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size' 124SELECT @@session.myisam_sort_buffer_size ; 125@@session.myisam_sort_buffer_size 1264096 127SET @@session.myisam_sort_buffer_size = "test"; 128ERROR 42000: Incorrect argument type to variable 'myisam_sort_buffer_size' 129SELECT @@session.myisam_sort_buffer_size ; 130@@session.myisam_sort_buffer_size 1314096 132'#------------------FN_DYNVARS_005_06-----------------------#' 133SELECT @@global.myisam_sort_buffer_size = VARIABLE_VALUE 134FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 135WHERE VARIABLE_NAME='myisam_sort_buffer_size '; 136@@global.myisam_sort_buffer_size = VARIABLE_VALUE 1371 138'#------------------FN_DYNVARS_005_07-----------------------#' 139SELECT @@session.myisam_sort_buffer_size = VARIABLE_VALUE 140FROM INFORMATION_SCHEMA.SESSION_VARIABLES 141WHERE VARIABLE_NAME='myisam_sort_buffer_size '; 142@@session.myisam_sort_buffer_size = VARIABLE_VALUE 1431 144'#------------------FN_DYNVARS_005_08-----------------------#' 145SET @@global.myisam_sort_buffer_size = TRUE; 146Warnings: 147Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '1' 148SELECT @@global.myisam_sort_buffer_size ; 149@@global.myisam_sort_buffer_size 1504096 151SET @@global.myisam_sort_buffer_size = FALSE; 152Warnings: 153Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '0' 154SELECT @@global.myisam_sort_buffer_size ; 155@@global.myisam_sort_buffer_size 1564096 157'#---------------------FN_DYNVARS_001_09----------------------#' 158SET @@global.myisam_sort_buffer_size = 10; 159Warnings: 160Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '10' 161SELECT @@myisam_sort_buffer_size = @@global.myisam_sort_buffer_size ; 162@@myisam_sort_buffer_size = @@global.myisam_sort_buffer_size 1631 164'#---------------------FN_DYNVARS_001_10----------------------#' 165SET @@myisam_sort_buffer_size = 100; 166Warnings: 167Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '100' 168SELECT @@myisam_sort_buffer_size = @@local.myisam_sort_buffer_size ; 169@@myisam_sort_buffer_size = @@local.myisam_sort_buffer_size 1701 171SELECT @@local.myisam_sort_buffer_size = @@session.myisam_sort_buffer_size ; 172@@local.myisam_sort_buffer_size = @@session.myisam_sort_buffer_size 1731 174'#---------------------FN_DYNVARS_001_11----------------------#' 175SET myisam_sort_buffer_size = 1; 176Warnings: 177Warning 1292 Truncated incorrect myisam_sort_buffer_size value: '1' 178SELECT @@myisam_sort_buffer_size ; 179@@myisam_sort_buffer_size 1804096 181SELECT local.myisam_sort_buffer_size ; 182ERROR 42S02: Unknown table 'local' in field list 183SELECT session.myisam_sort_buffer_size ; 184ERROR 42S02: Unknown table 'session' in field list 185SELECT myisam_sort_buffer_size = @@session.myisam_sort_buffer_size ; 186ERROR 42S22: Unknown column 'myisam_sort_buffer_size' in 'field list' 187SET @@global.myisam_sort_buffer_size = @start_global_value; 188SELECT @@global.myisam_sort_buffer_size ; 189@@global.myisam_sort_buffer_size 1908388608 191SET @@session.myisam_sort_buffer_size = @start_session_value; 192SELECT @@session.myisam_sort_buffer_size ; 193@@session.myisam_sort_buffer_size 1948388608 195