Debian Codegraph @

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

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