Debian Codegraph @

mysql-test/suite/sys_vars/r/aria_log_file_size_basic.result

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