Debian Codegraph @

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

raw
1 --source include/have_innodb.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 = 'full_crc32';
14 SELECT @@global.innodb_checksum_algorithm;
15
16 SET GLOBAL innodb_checksum_algorithm = 'strict_full_crc32';
17 SELECT @@global.innodb_checksum_algorithm;
18
19 -- error ER_WRONG_VALUE_FOR_VAR
20 SET GLOBAL innodb_checksum_algorithm = '';
21 SELECT @@global.innodb_checksum_algorithm;
22
23 -- error ER_WRONG_VALUE_FOR_VAR
24 SET GLOBAL innodb_checksum_algorithm = 'foobar';
25 SELECT @@global.innodb_checksum_algorithm;
26
27 -- error ER_WRONG_VALUE_FOR_VAR
28 SET GLOBAL innodb_checksum_algorithm = 123;
29 SELECT @@global.innodb_checksum_algorithm;
30
31 SET GLOBAL innodb_checksum_algorithm = @orig;
32 SELECT @@global.innodb_checksum_algorithm;