Debian Codegraph @

mysql-test/suite/innodb/r/innodb-page_compression_none.result

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