diff options
Diffstat (limited to 'mysql-test/suite/innodb/r/innodb_stats_drop_locked.result')
| -rw-r--r-- | mysql-test/suite/innodb/r/innodb_stats_drop_locked.result | 4 |
1 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..b8f312ccd63 100644 --- a/mysql-test/suite/innodb/r/innodb_stats_drop_locked.result +++ b/mysql-test/suite/innodb/r/innodb_stats_drop_locked.result @@ -17,6 +17,8 @@ innodb_stats_drop_locked innodb_stats_drop_locked innodb_stats_drop_locked innodb_stats_drop_locked +connect con1,localhost,root,,; +connection con1; ALTER TABLE innodb_stats_drop_locked DROP INDEX c_key; Warnings: Warning 1205 Unable to delete statistics for index c_key from mysql.innodb_index_stats because the rows are locked: Lock wait timeout. They can be deleted later using DELETE FROM mysql.innodb_index_stats WHERE database_name = 'test' AND table_name = 'innodb_stats_drop_locked' AND index_name = 'c_key'; @@ -28,6 +30,8 @@ innodb_stats_drop_locked CREATE TABLE `innodb_stats_drop_locked` ( DROP TABLE innodb_stats_drop_locked; SHOW TABLES; Tables_in_test +connection default; +disconnect con1; COMMIT; SELECT table_name FROM mysql.innodb_table_stats WHERE table_name='innodb_stats_drop_locked'; |