diff options
| author | Daniel Black <daniel@mariadb.org> | 2020-10-01 16:10:11 +1000 |
|---|---|---|
| committer | Daniel Black <daniel@mariadb.org> | 2020-10-01 16:10:14 +1000 |
| commit | 904b811636ef62478db2d78fdd8c01080eaac0f9 (patch) | |
| tree | 1e0f453c9a410564236fb6b15d4c930bf96dee1e | |
| parent | 7a1923c3693332584921e5ca938537fdef4bb29c (diff) | |
| download | mariadb-git-bb-10.1-danielblack-test-innodb_stats_drop_locked_cleanup.tar.gz | |
mtr: innodb_stats_dropped_locked cleanupbb-10.1-danielblack-test-innodb_stats_drop_locked_cleanup
As discovered in later test, this test doesn't remove
the innodb_{index,table}_stats entries generated
in the test upon completion.
| -rw-r--r-- | mysql-test/suite/innodb/r/innodb_stats_drop_locked.result | 2 | ||||
| -rw-r--r-- | mysql-test/suite/innodb/t/innodb_stats_drop_locked.test | 2 |
2 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/innodb_stats_drop_locked.result b/mysql-test/suite/innodb/r/innodb_stats_drop_locked.result index 13cc45e0ef9..c8329156162 100644 --- a/mysql-test/suite/innodb/r/innodb_stats_drop_locked.result +++ b/mysql-test/suite/innodb/r/innodb_stats_drop_locked.result @@ -43,3 +43,5 @@ innodb_stats_drop_locked innodb_stats_drop_locked innodb_stats_drop_locked innodb_stats_drop_locked +DELETE FROM mysql.innodb_index_stats WHERE database_name='test' AND table_name='innodb_stats_drop_locked'; +DELETE FROM mysql.innodb_table_stats WHERE database_name='test' AND table_name='innodb_stats_drop_locked'; diff --git a/mysql-test/suite/innodb/t/innodb_stats_drop_locked.test b/mysql-test/suite/innodb/t/innodb_stats_drop_locked.test index 26367b8e6ae..07c77299451 100644 --- a/mysql-test/suite/innodb/t/innodb_stats_drop_locked.test +++ b/mysql-test/suite/innodb/t/innodb_stats_drop_locked.test @@ -56,6 +56,8 @@ WHERE table_name='innodb_stats_drop_locked'; SELECT table_name FROM mysql.innodb_index_stats WHERE table_name='innodb_stats_drop_locked'; +DELETE FROM mysql.innodb_index_stats WHERE database_name='test' AND table_name='innodb_stats_drop_locked'; +DELETE FROM mysql.innodb_table_stats WHERE database_name='test' AND table_name='innodb_stats_drop_locked'; --disable_query_log call mtr.add_suppression("Unable to delete statistics for table test.innodb_stats_drop_locked: Lock wait timeout. They can be deleted later using DELETE FROM mysql.innodb_index_stats WHERE database_name"); --enable_query_log |