Elena Stepanova added a comment - 2016-12-25 23:01 In MariaDB MTR disables all optional plugins by default, so if a test needs to use a plugin (in this case innodb_cmp_per_index_reset , it should be re-enabled in test options. It can be fixed easily enough by adding an opt file: $ cat mysql-test/suite/innodb_zip/t/cmp_per_index.opt --innodb_log_compressed_pages=on --innodb_cmp_per_index_reset However, since this test is currently not run at all (because it requires innodb_log_compressed_pages=on and it's off by default), it is not maintained, so if we make it run, it produces a diff which I can't evaluate (see below). So, assigning to jplindst to modify the test/result as necessary: CURRENT_TEST: innodb_zip.cmp_per_index --- /data/bld/10.2/mysql-test/suite/innodb_zip/r/cmp_per_index.result 2016-10-17 00:56:47.000000000 +0300 +++ /data/bld/10.2/mysql-test/suite/innodb_zip/r/cmp_per_index.reject 2016-12-26 00:58:09.435089106 +0200 @@ -39,13 +39,13 @@ COMMIT; ALTER TABLE t DROP INDEX c; GRANT USAGE ON *.* TO 'tuser01'@'localhost' IDENTIFIED BY 'cDJvI9s_Uq'; -Warnings: -Level Warning -Code 1287 -Message Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. FLUSH PRIVILEGES; +connect con1,localhost,tuser01,cDJvI9s_Uq,; +connection con1; SELECT * FROM information_schema.innodb_cmp_per_index; ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation +connection default; +disconnect con1; DROP USER 'tuser01'@'localhost'; SELECT database_name, @@ -70,7 +70,6 @@ compress_ops 65 compress_ops_ok 65 uncompress_ops 0 -# restart SET GLOBAL innodb_cmp_per_index_enabled=ON; SELECT COUNT(*) FROM t; COUNT(*) 128 @@ -86,9 +85,15 @@ ORDER BY 1, 2, 3; database_name test table_name t +index_name b +compress_ops 0 +compress_ops_ok 0 +uncompress_ops 6 +database_name test +table_name t index_name PRIMARY compress_ops 0 compress_ops_ok 0 -uncompress_ops 9 +uncompress_ops 5 DROP TABLE t; SET GLOBAL innodb_cmp_per_index_enabled=default;   mysqltest: Result length mismatch

Elena Stepanova added a comment - 2017-04-23 21:08 I see the commit in the main tree: commit c07bb700c897ee36d97a6c694582c69959bbcaef Author: Jan Lindström <jan.lindstrom@mariadb.com> Date: Wed Mar 29 08:08:50 2017 +0300   MDEV-11629: Unknown table 'innodb_cmp_per_index_reset' in information_schema. Added .opt file to enable running this test as a part of innodb_zip suite and recorded current correct results. Probably the bug report can be closed now?