Debian Codegraph @

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

raw
1
2 # Check the default value
3 SET @orig = @@global.innodb_log_checksums;
4 SELECT @orig;
5
6 -- error ER_WRONG_VALUE_FOR_VAR
7 SET GLOBAL innodb_log_checksums = 'crc32';
8 SELECT @@global.innodb_log_checksums;
9
10 -- error ER_WRONG_VALUE_FOR_VAR
11 SET GLOBAL innodb_log_checksums = 2;
12 SELECT @@global.innodb_log_checksums;
13
14 -- error ER_WRONG_TYPE_FOR_VAR
15 SET GLOBAL innodb_log_checksums = 1e2;
16 SELECT @@global.innodb_log_checksums;
17
18 -- error ER_WRONG_TYPE_FOR_VAR
19 SET GLOBAL innodb_log_checksums = 1.0;
20 SELECT @@global.innodb_log_checksums;
21
22 -- error ER_GLOBAL_VARIABLE
23 SET innodb_log_checksums = OFF;
24 SELECT @@global.innodb_log_checksums;
25
26 SET GLOBAL innodb_log_checksums = OFF;
27 SELECT @@global.innodb_log_checksums;
28
29 SET GLOBAL innodb_log_checksums = default;
30
31 SET GLOBAL innodb_log_checksums = ON;
32 SELECT @@global.innodb_log_checksums;
33
34 SET GLOBAL innodb_log_checksums = @orig;
35 SELECT @@global.innodb_log_checksums;