Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_log_checkpoint_fuzzy_now_basic.test

raw
1 --source include/have_debug.inc
2
3 SET @start_global_value = @@global.innodb_log_checkpoint_fuzzy_now;
4 SELECT @start_global_value;
5
6 #
7 # exists as global only
8 #
9 select @@global.innodb_log_checkpoint_fuzzy_now in (0, 1);
10 select @@global.innodb_log_checkpoint_fuzzy_now;
11 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
12 select @@session.innodb_log_checkpoint_fuzzy_now;
13 show global variables like 'innodb_log_checkpoint_fuzzy_now';
14 show session variables like 'innodb_log_checkpoint_fuzzy_now';
15 --disable_warnings
16 select * from performance_schema.global_variables where variable_name='innodb_log_checkpoint_fuzzy_now';
17 select * from performance_schema.session_variables where variable_name='innodb_log_checkpoint_fuzzy_now';
18 --enable_warnings
19
20 #
21 # show that it's writable
22 #
23 set global innodb_log_checkpoint_fuzzy_now=1;
24 # Should always be OFF
25 select @@global.innodb_log_checkpoint_fuzzy_now;
26 --disable_warnings
27 select * from performance_schema.global_variables where variable_name='innodb_log_checkpoint_fuzzy_now';
28 select * from performance_schema.session_variables where variable_name='innodb_log_checkpoint_fuzzy_now';
29 --enable_warnings
30
31 set @@global.innodb_log_checkpoint_fuzzy_now=0;
32 # Should always be OFF
33 select @@global.innodb_log_checkpoint_fuzzy_now;
34 --disable_warnings
35 select * from performance_schema.global_variables where variable_name='innodb_log_checkpoint_fuzzy_now';
36 select * from performance_schema.session_variables where variable_name='innodb_log_checkpoint_fuzzy_now';
37 --enable_warnings
38
39 set global innodb_log_checkpoint_fuzzy_now=ON;
40 # Should always be OFF
41 select @@global.innodb_log_checkpoint_fuzzy_now;
42 --disable_warnings
43 select * from performance_schema.global_variables where variable_name='innodb_log_checkpoint_fuzzy_now';
44 select * from performance_schema.session_variables where variable_name='innodb_log_checkpoint_fuzzy_now';
45 --enable_warnings
46
47 set global innodb_log_checkpoint_fuzzy_now=OFF;
48 # Should always be OFF
49 select @@global.innodb_log_checkpoint_fuzzy_now;
50 --disable_warnings
51 select * from performance_schema.global_variables where variable_name='innodb_log_checkpoint_fuzzy_now';
52 select * from performance_schema.session_variables where variable_name='innodb_log_checkpoint_fuzzy_now';
53 --enable_warnings
54
55 --error ER_GLOBAL_VARIABLE
56 set session innodb_log_checkpoint_fuzzy_now='some';
57
58 --error ER_GLOBAL_VARIABLE
59 set @@session.innodb_log_checkpoint_fuzzy_now='some';
60
61 #
62 # incorrect types
63 #
64 --error ER_WRONG_TYPE_FOR_VAR
65 set global innodb_log_checkpoint_fuzzy_now=1.1;
66 --error ER_WRONG_VALUE_FOR_VAR
67 set global innodb_log_checkpoint_fuzzy_now='foo';
68 --error ER_WRONG_VALUE_FOR_VAR
69 set global innodb_log_checkpoint_fuzzy_now=-2;
70 --error ER_WRONG_TYPE_FOR_VAR
71 set global innodb_log_checkpoint_fuzzy_now=1e1;
72
73 #
74 # Cleanup
75 #
76
77 SET @@global.innodb_log_checkpoint_fuzzy_now = @start_global_value;
78 SELECT @@global.innodb_log_checkpoint_fuzzy_now;