1SET @start_global_value = @@global.aria_max_sort_file_size; 2select @@global.aria_max_sort_file_size; 3@@global.aria_max_sort_file_size 49223372036853727232 5select @@session.aria_max_sort_file_size; 6ERROR HY000: Variable 'aria_max_sort_file_size' is a GLOBAL variable 7show global variables like 'aria_max_sort_file_size'; 8Variable_name Value 9aria_max_sort_file_size 9223372036853727232 10show session variables like 'aria_max_sort_file_size'; 11Variable_name Value 12aria_max_sort_file_size 9223372036853727232 13select * from information_schema.global_variables where variable_name='aria_max_sort_file_size'; 14VARIABLE_NAME VARIABLE_VALUE 15ARIA_MAX_SORT_FILE_SIZE 9223372036853727232 16select * from information_schema.session_variables where variable_name='aria_max_sort_file_size'; 17VARIABLE_NAME VARIABLE_VALUE 18ARIA_MAX_SORT_FILE_SIZE 9223372036853727232 19set global aria_max_sort_file_size=1024*1024*10; 20select @@global.aria_max_sort_file_size; 21@@global.aria_max_sort_file_size 2210485760 23set session aria_max_sort_file_size=1; 24ERROR HY000: Variable 'aria_max_sort_file_size' is a GLOBAL variable and should be set with SET GLOBAL 25set global aria_max_sort_file_size=1.1; 26ERROR 42000: Incorrect argument type to variable 'aria_max_sort_file_size' 27set global aria_max_sort_file_size=1e1; 28ERROR 42000: Incorrect argument type to variable 'aria_max_sort_file_size' 29set global aria_max_sort_file_size="foo"; 30ERROR 42000: Incorrect argument type to variable 'aria_max_sort_file_size' 31set global aria_max_sort_file_size=1; 32Warnings: 33Warning 1292 Truncated incorrect aria_max_sort_file_size value: '1' 34select @@global.aria_max_sort_file_size; 35@@global.aria_max_sort_file_size 360 37set global aria_max_sort_file_size=@@global.aria_max_sort_file_size + 1024*1024 - 1; 38Warnings: 39Warning 1292 Truncated incorrect aria_max_sort_file_size value: '1048575' 40select @@global.aria_max_sort_file_size; 41@@global.aria_max_sort_file_size 420 43set global aria_max_sort_file_size=@@global.aria_max_sort_file_size + 1024*1024; 44select @@global.aria_max_sort_file_size; 45@@global.aria_max_sort_file_size 461048576 47set global aria_max_sort_file_size=cast(-1 as unsigned int); 48Warnings: 49Note 1105 Cast to unsigned converted negative integer to it's positive complement 50Note 1105 Cast to unsigned converted negative integer to it's positive complement 51Warning 1292 Truncated incorrect aria_max_sort_file_size value: '18446744073709551615' 52select @@global.aria_max_sort_file_size; 53@@global.aria_max_sort_file_size 549223372036853727232 55SET @@global.aria_max_sort_file_size = @start_global_value; 56