Debian Codegraph @

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

raw
1 --source include/not_valgrind.inc
2
3 # Check the default value
4 SET @orig = @@global.innodb_checksum_algorithm;
5 SELECT @orig;
6
7 SET GLOBAL innodb_checksum_algorithm = 'crc32';
8 SELECT @@global.innodb_checksum_algorithm;
9
10 SET GLOBAL innodb_checksum_algorithm = 'strict_crc32';
11 SELECT @@global.innodb_checksum_algorithm;
12
13 SET GLOBAL innodb_checksum_algorithm = 'innodb';
14 SELECT @@global.innodb_checksum_algorithm;
15
16 SET GLOBAL innodb_checksum_algorithm = 'strict_innodb';
17 SELECT @@global.innodb_checksum_algorithm;
18
19 SET GLOBAL innodb_checksum_algorithm = 'none';
20 SELECT @@global.innodb_checksum_algorithm;
21
22 SET GLOBAL innodb_checksum_algorithm = 'strict_none';
23 SELECT @@global.innodb_checksum_algorithm;
24
25 -- error ER_WRONG_VALUE_FOR_VAR
26 SET GLOBAL innodb_checksum_algorithm = '';
27 SELECT @@global.innodb_checksum_algorithm;
28
29 -- error ER_WRONG_VALUE_FOR_VAR
30 SET GLOBAL innodb_checksum_algorithm = 'foobar';
31 SELECT @@global.innodb_checksum_algorithm;
32
33 -- error ER_WRONG_VALUE_FOR_VAR
34 SET GLOBAL innodb_checksum_algorithm = 123;
35 SELECT @@global.innodb_checksum_algorithm;
36
37 SET GLOBAL innodb_checksum_algorithm = @orig;
38 SELECT @@global.innodb_checksum_algorithm;