diff options
author | Marko Mäkelä <marko.makela@mariadb.com> | 2022-06-17 08:40:51 +0300 |
---|---|---|
committer | Marko Mäkelä <marko.makela@mariadb.com> | 2022-06-17 08:40:51 +0300 |
commit | be99d0ddb603bf972201a6b188819ed099b3bd75 (patch) | |
tree | 0d26f48e294484a7d148395d7699e9a6c961b8a6 /mysql-test/suite/innodb/t/stats_persistent.test | |
parent | c4f65d8fed16370deae85115490fc0c06da2ce84 (diff) | |
download | mariadb-git-be99d0ddb603bf972201a6b188819ed099b3bd75.tar.gz |
Fix intermittent failures of innodb.stats_persistent
We do not really care about the exact result; we only care that the
statistics will be accessed. The result could change depending on
when some statistics were updated in the background or when some
committed delete-marked rows were purged from other tables on
which persistent statistics are enabled.
Diffstat (limited to 'mysql-test/suite/innodb/t/stats_persistent.test')
-rw-r--r-- | mysql-test/suite/innodb/t/stats_persistent.test | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/suite/innodb/t/stats_persistent.test b/mysql-test/suite/innodb/t/stats_persistent.test index ac412d56d0d..8561298c4d3 100644 --- a/mysql-test/suite/innodb/t/stats_persistent.test +++ b/mysql-test/suite/innodb/t/stats_persistent.test @@ -14,7 +14,8 @@ SET DEBUG_SYNC='dict_stats_update_persistent SIGNAL stop WAIT_FOR go'; --connect(con1, localhost, root) SET DEBUG_SYNC='now WAIT_FOR stop'; -SELECT ENGINE,SUM(DATA_LENGTH+INDEX_LENGTH),COUNT(ENGINE),SUM(DATA_LENGTH),SUM(INDEX_LENGTH) FROM information_schema.TABLES WHERE ENGINE='InnoDB'; +--replace_column 1 SUM +SELECT SUM(DATA_LENGTH+INDEX_LENGTH) FROM information_schema.TABLES WHERE ENGINE='InnoDB'; SET DEBUG_SYNC='now SIGNAL go'; --disconnect con1 |