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 full_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 = 'full_crc32';
14 SELECT @@global.innodb_checksum_algorithm;
15 @@global.innodb_checksum_algorithm
16 full_crc32
17 SET GLOBAL innodb_checksum_algorithm = 'strict_full_crc32';
18 SELECT @@global.innodb_checksum_algorithm;
19 @@global.innodb_checksum_algorithm
20 strict_full_crc32
21 SET GLOBAL innodb_checksum_algorithm = '';
22 ERROR 42000: Variable 'innodb_checksum_algorithm' can't be set to the value of ''
23 SELECT @@global.innodb_checksum_algorithm;
24 @@global.innodb_checksum_algorithm
25 strict_full_crc32
26 SET GLOBAL innodb_checksum_algorithm = 'foobar';
27 ERROR 42000: Variable 'innodb_checksum_algorithm' can't be set to the value of 'foobar'
28 SELECT @@global.innodb_checksum_algorithm;
29 @@global.innodb_checksum_algorithm
30 strict_full_crc32
31 SET GLOBAL innodb_checksum_algorithm = 123;
32 ERROR 42000: Variable 'innodb_checksum_algorithm' can't be set to the value of '123'
33 SELECT @@global.innodb_checksum_algorithm;
34 @@global.innodb_checksum_algorithm
35 strict_full_crc32
36 SET GLOBAL innodb_checksum_algorithm = @orig;
37 SELECT @@global.innodb_checksum_algorithm;
38 @@global.innodb_checksum_algorithm
39 full_crc32