summaryrefslogtreecommitdiff
path: root/mysql-test/main/create_or_replace.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/create_or_replace.test')
-rw-r--r--mysql-test/main/create_or_replace.test9
1 files changed, 6 insertions, 3 deletions
diff --git a/mysql-test/main/create_or_replace.test b/mysql-test/main/create_or_replace.test
index 2b6f2ae4005..573e0e177c2 100644
--- a/mysql-test/main/create_or_replace.test
+++ b/mysql-test/main/create_or_replace.test
@@ -4,9 +4,9 @@
--source include/have_innodb.inc
--source include/have_metadata_lock_info.inc
---disable_warnings
-drop table if exists t1,t2,t3;
---enable_warnings
+
+SET @save_persistent=@@GLOBAL.innodb_stats_persistent;
+SET GLOBAL innodb_stats_persistent=OFF;
#
# Create help table
@@ -365,6 +365,7 @@ lock table t1 write, t2 read;
--replace_column 1 #
--sorted_result
select * from information_schema.metadata_lock_info;
+
create or replace table t1 (i int);
--replace_column 1 #
--sorted_result
@@ -508,3 +509,5 @@ UNLOCK TABLES;
DROP TABLE t3;
--echo # End of 10.4 tests
+
+SET GLOBAL innodb_stats_persistent=@save_persistent;