Debian Codegraph @

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

raw
1 SET @orig = @@global.innodb_checksum_algorithm;
2 SELECT @orig;
3 @orig
4 crc32
5 SET GLOBAL innodb_checksum_algorithm = 'crc32';
6 SELECT @@global.innodb_checksum_algorithm;
7 @@global.innodb_checksum_algorithm
8 crc32
9 SET GLOBAL innodb_checksum_algorithm = 'strict_crc32';
10 SELECT @@global.innodb_checksum_algorithm;
11 @@global.innodb_checksum_algorithm
12 strict_crc32
13 SET GLOBAL innodb_checksum_algorithm = 'innodb';
14 SELECT @@global.innodb_checksum_algorithm;
15 @@global.innodb_checksum_algorithm
16 innodb
17 SET GLOBAL innodb_checksum_algorithm = 'strict_innodb';
18 SELECT @@global.innodb_checksum_algorithm;
19 @@global.innodb_checksum_algorithm
20 strict_innodb
21 SET GLOBAL innodb_checksum_algorithm = 'none';
22 SELECT @@global.innodb_checksum_algorithm;
23 @@global.innodb_checksum_algorithm
24 none
25 SET GLOBAL innodb_checksum_algorithm = 'strict_none';
26 SELECT @@global.innodb_checksum_algorithm;
27 @@global.innodb_checksum_algorithm
28 strict_none
29 SET GLOBAL innodb_checksum_algorithm = '';
30 ERROR 42000: Variable 'innodb_checksum_algorithm' can't be set to the value of ''
31 SELECT @@global.innodb_checksum_algorithm;
32 @@global.innodb_checksum_algorithm
33 strict_none
34 SET GLOBAL innodb_checksum_algorithm = 'foobar';
35 ERROR 42000: Variable 'innodb_checksum_algorithm' can't be set to the value of 'foobar'
36 SELECT @@global.innodb_checksum_algorithm;
37 @@global.innodb_checksum_algorithm
38 strict_none
39 SET GLOBAL innodb_checksum_algorithm = 123;
40 ERROR 42000: Variable 'innodb_checksum_algorithm' can't be set to the value of '123'
41 SELECT @@global.innodb_checksum_algorithm;
42 @@global.innodb_checksum_algorithm
43 strict_none
44 SET GLOBAL innodb_checksum_algorithm = @orig;
45 SELECT @@global.innodb_checksum_algorithm;
46 @@global.innodb_checksum_algorithm
47 crc32