Debian Codegraph @

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

raw
1 SET @orig = @@global.innodb_log_checksums;
2 SELECT @orig;
3 @orig
4 1
5 SET GLOBAL innodb_log_checksums = 'crc32';
6 ERROR 42000: Variable 'innodb_log_checksums' can't be set to the value of 'crc32'
7 SELECT @@global.innodb_log_checksums;
8 @@global.innodb_log_checksums
9 1
10 SET GLOBAL innodb_log_checksums = 2;
11 ERROR 42000: Variable 'innodb_log_checksums' can't be set to the value of '2'
12 SELECT @@global.innodb_log_checksums;
13 @@global.innodb_log_checksums
14 1
15 SET GLOBAL innodb_log_checksums = 1e2;
16 ERROR 42000: Incorrect argument type to variable 'innodb_log_checksums'
17 SELECT @@global.innodb_log_checksums;
18 @@global.innodb_log_checksums
19 1
20 SET GLOBAL innodb_log_checksums = 1.0;
21 ERROR 42000: Incorrect argument type to variable 'innodb_log_checksums'
22 SELECT @@global.innodb_log_checksums;
23 @@global.innodb_log_checksums
24 1
25 SET innodb_log_checksums = OFF;
26 ERROR HY000: Variable 'innodb_log_checksums' is a GLOBAL variable and should be set with SET GLOBAL
27 SELECT @@global.innodb_log_checksums;
28 @@global.innodb_log_checksums
29 1
30 SET GLOBAL innodb_log_checksums = OFF;
31 SELECT @@global.innodb_log_checksums;
32 @@global.innodb_log_checksums
33 0
34 SET GLOBAL innodb_log_checksums = default;
35 SET GLOBAL innodb_log_checksums = ON;
36 SELECT @@global.innodb_log_checksums;
37 @@global.innodb_log_checksums
38 1
39 SET GLOBAL innodb_log_checksums = @orig;
40 SELECT @@global.innodb_log_checksums;
41 @@global.innodb_log_checksums
42 1