Debian Codegraph @

mysql-test/suite/innodb/t/innodb-page_compression_none.test

raw
1 -- source include/innodb_checksum_algorithm.inc
2
3 --echo #
4 --echo # MDEV-30825 innodb_compression_algorithm=0 (none) increments Innodb_num_pages_page_compression_error
5 --echo #
6
7 SET @save_compression_algorithm=@@GLOBAL.innodb_compression_algorithm;
8 SET GLOBAL innodb_compression_algorithm=0;
9 --disable_cursor_protocol
10 SELECT VARIABLE_VALUE INTO @compress_errors FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Innodb_num_pages_page_compression_error';
11 --enable_cursor_protocol
12
13 CREATE TABLE t (c INT) page_compressed=1 page_compression_level=4 ENGINE=InnoDB;
14 INSERT INTO t VALUES (1);
15
16 FLUSH TABLES t FOR EXPORT;
17 UNLOCK TABLES;
18
19 SELECT VARIABLE_VALUE - @compress_errors AS NUMBER_OF_ERRORS FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Innodb_num_pages_page_compression_error';
20
21 DROP TABLE t;
22 SET GLOBAL innodb_compression_algorithm=@save_compression_algorithm;
23
24 --echo #
25 --echo # End of 10.4 tests
26 --echo #
27