innodb.innodb_stats_persistent 'innodb'  w4 [ fail ]

        Test ended at 2019-12-21 11:54:02

CURRENT_TEST: innodb.innodb_stats_persistent

--- /usr/share/mysql-test/suite/innodb/r/innodb_stats_persistent.result	2019-12-21 10:40:37.000000000 +0000

+++ /dev/shm/var/4/log/innodb_stats_persistent.reject	2019-12-21 11:54:02.037904709 +0000

@@ -22,7 +22,7 @@

 # DELETE must not affect statistics before COMMIT.

 EXPLAIN SELECT * FROM t1 WHERE val=4;

 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra

-1	SIMPLE	t1	ref	val	val	4	const	1	Using index

+1	SIMPLE	t1	ref	val	val	4	const	2	Using index

 connection con1;

 COUNT(*)

 0

@@ -90,11 +90,11 @@

 # ha_innobase::records_in_range() would count the delete-marked records.

 EXPLAIN SELECT * FROM t1;

 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra

-1	SIMPLE	t1	index	NULL	val	4	NULL	1	Using index

+1	SIMPLE	t1	index	NULL	val	4	NULL	2	Using index

 ROLLBACK;

 EXPLAIN SELECT * FROM t1;

 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra

-1	SIMPLE	t1	index	NULL	val	4	NULL	16	Using index

+1	SIMPLE	t1	index	NULL	val	4	NULL	18	Using index

 SELECT COUNT(*) FROM t1;

 COUNT(*)

 16

mysqltest: Result content mismatch