innodb_zip.cmp_per_index 'innodb'        [ fail ]

        Test ended at 2019-10-04 16:46:28

CURRENT_TEST: innodb_zip.cmp_per_index

--- /home/kevg/work/m/bb-10.2-kevgs/mysql-test/suite/innodb_zip/r/cmp_per_index.result	2019-10-03 17:34:38.626389892 +0300

+++ /home/kevg/work/m/bb-10.2-kevgs/mysql-test/suite/innodb_zip/r/cmp_per_index.reject	2019-10-04 16:46:28.612642509 +0300

@@ -61,14 +61,14 @@

 database_name	test

 table_name	t

 index_name	b

-compress_ops	43

-compress_ops_ok	43

+compress_ops	42

+compress_ops_ok	42

 uncompress_ops	0

 database_name	test

 table_name	t

 index_name	PRIMARY

-compress_ops	65

-compress_ops_ok	65

+compress_ops	45

+compress_ops_ok	45

 uncompress_ops	0

 SHOW CREATE TABLE t;

 Table	t

@@ -97,6 +97,6 @@

 index_name	PRIMARY

 compress_ops	0

 compress_ops_ok	0

-uncompress_ops	4

+uncompress_ops	2

 DROP TABLE t;

 SET GLOBAL innodb_cmp_per_index_enabled=default;

--- /home/kevg/work/m/bb-10.3-MDEV-19783-check-table/mysql-test/suite/innodb/r/index_merge_threshold.result    2019-10-03 13:32:31.117762090 +0300

+++ /home/kevg/work/m/bb-10.3-MDEV-19783-check-table/mysql-test/suite/innodb/r/index_merge_threshold.reject    2019-10-04 13:03:11.654942019 +0300

@@ -1242,9 +1242,10 @@

 and PAGE_TYPE = "INDEX" order by PAGE_NUMBER, NUMBER_RECORDS;

 PAGE_NUMBER    NUMBER_RECORDS

 3    42

-4    2

+4    3

 27    21

-28    21

+28    10

+30    11

 begin;

 delete from tab1 where a = 33;

 delete from tab1 where a = 34;

@@ -1272,8 +1273,8 @@

 SELECT name,count_reset FROM information_schema.innodb_metrics

 WHERE name like 'index_page_merge_%';

 name    count_reset

-index_page_merge_attempts    0

-index_page_merge_successful    0

+index_page_merge_attempts    1

+index_page_merge_successful    1

 select PAGE_NUMBER, NUMBER_RECORDS

 from INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES s1,

 INFORMATION_SCHEMA.INNODB_BUFFER_PAGE s2

@@ -1283,30 +1284,31 @@

 3    22

 4    2

 27    11

-28    11

+28    9

+30    11

 delete from tab1 where a = 32;

 InnoDB        0 transactions not purged

 # check page merge happens (MERGE_THRESHOLD=50 causes merge here)

 SELECT name,count_reset FROM information_schema.innodb_metrics

 WHERE name like 'index_page_merge_%';

 name    count_reset

-index_page_merge_attempts    0

-index_page_merge_successful    0

+index_page_merge_attempts    1

+index_page_merge_successful    1

 delete from tab1 where a = 31;

 InnoDB        0 transactions not purged

 # check page merge happens (MERGE_THRESHOLD=45 causes merge here)

 SELECT name,count_reset FROM information_schema.innodb_metrics

 WHERE name like 'index_page_merge_%';

 name    count_reset

-index_page_merge_attempts    1

-index_page_merge_successful    1

+index_page_merge_attempts    2

+index_page_merge_successful    2

 delete from tab1 where a = 30;

 InnoDB        0 transactions not purged

 # check page merge happens (MERGE_THRESHOLD=40 causes merge here)

 SELECT name,count_reset FROM information_schema.innodb_metrics

 WHERE name like 'index_page_merge_%';

 name    count_reset

-index_page_merge_attempts    2

-index_page_merge_successful    2

+index_page_merge_attempts    3

+index_page_merge_successful    3

 DROP TABLE tab1;

 SET GLOBAL innodb_purge_rseg_truncate_frequency = @saved_frequency;