1SET @start_global_value = @@global.myisam_max_sort_file_size; 2SELECT @start_global_value; 3@start_global_value 42146435072 5'#--------------------FN_DYNVARS_094_01-------------------------#' 6SET @@global.myisam_max_sort_file_size = 500000; 7Warnings: 8Warning 1292 Truncated incorrect myisam_max_sort_file_size value: '500000' 9SET @@global.myisam_max_sort_file_size = DEFAULT; 10SELECT @@global.myisam_max_sort_file_size; 11@@global.myisam_max_sort_file_size 122146435072 13'#--------------------FN_DYNVARS_094_02-------------------------#' 14SET @@global.myisam_max_sort_file_size = DEFAULT; 15SELECT @@global.myisam_max_sort_file_size = 2147483648; 16@@global.myisam_max_sort_file_size = 2147483648 170 18'#--------------------FN_DYNVARS_094_03-------------------------#' 19SET @@global.myisam_max_sort_file_size = 0; 20SELECT @@global.myisam_max_sort_file_size; 21@@global.myisam_max_sort_file_size 220 23SET @@global.myisam_max_sort_file_size = 1024; 24Warnings: 25Warning 1292 Truncated incorrect myisam_max_sort_file_size value: '1024' 26SELECT @@global.myisam_max_sort_file_size; 27@@global.myisam_max_sort_file_size 280 29SET @@global.myisam_max_sort_file_size = 123456789; 30Warnings: 31Warning 1292 Truncated incorrect myisam_max_sort_file_size value: '123456789' 32SELECT @@global.myisam_max_sort_file_size; 33@@global.myisam_max_sort_file_size 34122683392 35SET @@global.myisam_max_sort_file_size = 2147483648*2; 36SELECT @@global.myisam_max_sort_file_size; 37@@global.myisam_max_sort_file_size 384294967296 39SET @@global.myisam_max_sort_file_size = 2147483648*1024; 40SELECT @@global.myisam_max_sort_file_size; 41@@global.myisam_max_sort_file_size 422199023255552 43SELECT @@global.myisam_max_sort_file_size; 44@@global.myisam_max_sort_file_size 452199023255552 46SET @@global.myisam_max_sort_file_size = 2147483648*2147483648; 47'#--------------------FN_DYNVARS_094_04-------------------------#' 48SET @@myisam_max_sort_file_size = 2; 49ERROR HY000: Variable 'myisam_max_sort_file_size' is a GLOBAL variable and should be set with SET GLOBAL 50SET @@session.myisam_max_sort_file_size = 3; 51ERROR HY000: Variable 'myisam_max_sort_file_size' is a GLOBAL variable and should be set with SET GLOBAL 52SET @@local.myisam_max_sort_file_size = 4; 53ERROR HY000: Variable 'myisam_max_sort_file_size' is a GLOBAL variable and should be set with SET GLOBAL 54'#------------------FN_DYNVARS_094_05-----------------------#' 55SET @@global.myisam_max_sort_file_size = -1; 56Warnings: 57Warning 1292 Truncated incorrect myisam_max_sort_file_size value: '-1' 58SELECT @@global.myisam_max_sort_file_size; 59@@global.myisam_max_sort_file_size 600 61SET @@global.myisam_max_sort_file_size = -2147483648; 62Warnings: 63Warning 1292 Truncated incorrect myisam_max_sort_file_size value: '-2147483648' 64SELECT @@global.myisam_max_sort_file_size; 65@@global.myisam_max_sort_file_size 660 67SET @@global.myisam_max_sort_file_size = -2147483649; 68Warnings: 69Warning 1292 Truncated incorrect myisam_max_sort_file_size value: '-2147483649' 70SELECT @@global.myisam_max_sort_file_size; 71@@global.myisam_max_sort_file_size 720 73SET @@global.myisam_max_sort_file_size = 65530.34; 74ERROR 42000: Incorrect argument type to variable 'myisam_max_sort_file_size' 75SELECT @@global.myisam_max_sort_file_size; 76@@global.myisam_max_sort_file_size 770 78SET @@global.myisam_max_sort_file_size = 2147483649.56; 79ERROR 42000: Incorrect argument type to variable 'myisam_max_sort_file_size' 80SELECT @@global.myisam_max_sort_file_size; 81@@global.myisam_max_sort_file_size 820 83SET @@global.myisam_max_sort_file_size = 1G; 84ERROR 42000: Incorrect argument type to variable 'myisam_max_sort_file_size' 85'#------------------FN_DYNVARS_094_06-----------------------#' 86SET @@global.myisam_max_sort_file_size = 3000; 87Warnings: 88Warning 1292 Truncated incorrect myisam_max_sort_file_size value: '3000' 89SELECT @@global.myisam_max_sort_file_size = VARIABLE_VALUE 90FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 91WHERE VARIABLE_NAME='myisam_max_sort_file_size'; 92@@global.myisam_max_sort_file_size = VARIABLE_VALUE 931 94'#------------------FN_DYNVARS_094_07-----------------------#' 95SELECT count(VARIABLE_VALUE) 96FROM INFORMATION_SCHEMA.SESSION_VARIABLES 97WHERE VARIABLE_NAME='myisam_max_sort_file_size'; 98count(VARIABLE_VALUE) 991 100'#------------------FN_DYNVARS_094_08-----------------------#' 101SET @@global.myisam_max_sort_file_size = TRUE; 102Warnings: 103Warning 1292 Truncated incorrect myisam_max_sort_file_size value: '1' 104SELECT @@global.myisam_max_sort_file_size; 105@@global.myisam_max_sort_file_size 1060 107SET @@global.myisam_max_sort_file_size = FALSE; 108SELECT @@global.myisam_max_sort_file_size; 109@@global.myisam_max_sort_file_size 1100 111'#---------------------FN_DYNVARS_001_09----------------------#' 112SET @@global.myisam_max_sort_file_size = 512; 113Warnings: 114Warning 1292 Truncated incorrect myisam_max_sort_file_size value: '512' 115SELECT @@myisam_max_sort_file_size = @@global.myisam_max_sort_file_size; 116@@myisam_max_sort_file_size = @@global.myisam_max_sort_file_size 1171 118'#---------------------FN_DYNVARS_001_10----------------------#' 119SET myisam_max_sort_file_size = 2048; 120ERROR HY000: Variable 'myisam_max_sort_file_size' is a GLOBAL variable and should be set with SET GLOBAL 121SELECT myisam_max_sort_file_size; 122ERROR 42S22: Unknown column 'myisam_max_sort_file_size' in 'field list' 123SELECT @@myisam_max_sort_file_size; 124@@myisam_max_sort_file_size 1250 126SET global myisam_max_sort_file_size = 64; 127Warnings: 128Warning 1292 Truncated incorrect myisam_max_sort_file_size value: '64' 129SET @@global.myisam_max_sort_file_size = @start_global_value; 130SELECT @@global.myisam_max_sort_file_size; 131@@global.myisam_max_sort_file_size 1322146435072 133