Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.innodb_log_checkpoint_fuzzy_now;
2 SELECT @start_global_value;
3 @start_global_value
4 0
5 select @@global.innodb_log_checkpoint_fuzzy_now in (0, 1);
6 @@global.innodb_log_checkpoint_fuzzy_now in (0, 1)
7 1
8 select @@global.innodb_log_checkpoint_fuzzy_now;
9 @@global.innodb_log_checkpoint_fuzzy_now
10 0
11 select @@session.innodb_log_checkpoint_fuzzy_now;
12 ERROR HY000: Variable 'innodb_log_checkpoint_fuzzy_now' is a GLOBAL variable
13 show global variables like 'innodb_log_checkpoint_fuzzy_now';
14 Variable_name Value
15 innodb_log_checkpoint_fuzzy_now OFF
16 show session variables like 'innodb_log_checkpoint_fuzzy_now';
17 Variable_name Value
18 innodb_log_checkpoint_fuzzy_now OFF
19 select * from performance_schema.global_variables where variable_name='innodb_log_checkpoint_fuzzy_now';
20 VARIABLE_NAME VARIABLE_VALUE
21 innodb_log_checkpoint_fuzzy_now OFF
22 select * from performance_schema.session_variables where variable_name='innodb_log_checkpoint_fuzzy_now';
23 VARIABLE_NAME VARIABLE_VALUE
24 innodb_log_checkpoint_fuzzy_now OFF
25 set global innodb_log_checkpoint_fuzzy_now=1;
26 select @@global.innodb_log_checkpoint_fuzzy_now;
27 @@global.innodb_log_checkpoint_fuzzy_now
28 0
29 select * from performance_schema.global_variables where variable_name='innodb_log_checkpoint_fuzzy_now';
30 VARIABLE_NAME VARIABLE_VALUE
31 innodb_log_checkpoint_fuzzy_now OFF
32 select * from performance_schema.session_variables where variable_name='innodb_log_checkpoint_fuzzy_now';
33 VARIABLE_NAME VARIABLE_VALUE
34 innodb_log_checkpoint_fuzzy_now OFF
35 set @@global.innodb_log_checkpoint_fuzzy_now=0;
36 select @@global.innodb_log_checkpoint_fuzzy_now;
37 @@global.innodb_log_checkpoint_fuzzy_now
38 0
39 select * from performance_schema.global_variables where variable_name='innodb_log_checkpoint_fuzzy_now';
40 VARIABLE_NAME VARIABLE_VALUE
41 innodb_log_checkpoint_fuzzy_now OFF
42 select * from performance_schema.session_variables where variable_name='innodb_log_checkpoint_fuzzy_now';
43 VARIABLE_NAME VARIABLE_VALUE
44 innodb_log_checkpoint_fuzzy_now OFF
45 set global innodb_log_checkpoint_fuzzy_now=ON;
46 select @@global.innodb_log_checkpoint_fuzzy_now;
47 @@global.innodb_log_checkpoint_fuzzy_now
48 0
49 select * from performance_schema.global_variables where variable_name='innodb_log_checkpoint_fuzzy_now';
50 VARIABLE_NAME VARIABLE_VALUE
51 innodb_log_checkpoint_fuzzy_now OFF
52 select * from performance_schema.session_variables where variable_name='innodb_log_checkpoint_fuzzy_now';
53 VARIABLE_NAME VARIABLE_VALUE
54 innodb_log_checkpoint_fuzzy_now OFF
55 set global innodb_log_checkpoint_fuzzy_now=OFF;
56 select @@global.innodb_log_checkpoint_fuzzy_now;
57 @@global.innodb_log_checkpoint_fuzzy_now
58 0
59 select * from performance_schema.global_variables where variable_name='innodb_log_checkpoint_fuzzy_now';
60 VARIABLE_NAME VARIABLE_VALUE
61 innodb_log_checkpoint_fuzzy_now OFF
62 select * from performance_schema.session_variables where variable_name='innodb_log_checkpoint_fuzzy_now';
63 VARIABLE_NAME VARIABLE_VALUE
64 innodb_log_checkpoint_fuzzy_now OFF
65 set session innodb_log_checkpoint_fuzzy_now='some';
66 ERROR HY000: Variable 'innodb_log_checkpoint_fuzzy_now' is a GLOBAL variable and should be set with SET GLOBAL
67 set @@session.innodb_log_checkpoint_fuzzy_now='some';
68 ERROR HY000: Variable 'innodb_log_checkpoint_fuzzy_now' is a GLOBAL variable and should be set with SET GLOBAL
69 set global innodb_log_checkpoint_fuzzy_now=1.1;
70 ERROR 42000: Incorrect argument type to variable 'innodb_log_checkpoint_fuzzy_now'
71 set global innodb_log_checkpoint_fuzzy_now='foo';
72 ERROR 42000: Variable 'innodb_log_checkpoint_fuzzy_now' can't be set to the value of 'foo'
73 set global innodb_log_checkpoint_fuzzy_now=-2;
74 ERROR 42000: Variable 'innodb_log_checkpoint_fuzzy_now' can't be set to the value of '-2'
75 set global innodb_log_checkpoint_fuzzy_now=1e1;
76 ERROR 42000: Incorrect argument type to variable 'innodb_log_checkpoint_fuzzy_now'
77 SET @@global.innodb_log_checkpoint_fuzzy_now = @start_global_value;
78 SELECT @@global.innodb_log_checkpoint_fuzzy_now;
79 @@global.innodb_log_checkpoint_fuzzy_now
80 0