Debian Codegraph @

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

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