[#MDEV-11629] Unknown table 'innodb_cmp_per_index_reset' in information

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

[MDEV-11629] Unknown table 'innodb_cmp_per_index_reset' in information_schema Created: 2016-12-22 Updated: 2017-04-28 Resolved: 2017-04-27
Status:	Closed
Project:	MariaDB Server
Component/s:	Tests
Affects Version/s:	10.2.2, 10.2
Fix Version/s:	10.1.23

[MDEV-11629] Unknown table 'innodb_cmp_per_index_reset' in information_schema Created: 2016-12-22 Updated: 2017-04-28 Resolved: 2017-04-27