summaryrefslogtreecommitdiff
path: root/mysql-test/t/query_cache.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/query_cache.test')
-rw-r--r--mysql-test/t/query_cache.test15
1 files changed, 2 insertions, 13 deletions
diff --git a/mysql-test/t/query_cache.test b/mysql-test/t/query_cache.test
index 59ea6d8777b..d2af702e566 100644
--- a/mysql-test/t/query_cache.test
+++ b/mysql-test/t/query_cache.test
@@ -1,11 +1,11 @@
--- source include/have_innodb.inc
-
#
# Tests with query cache
#
# Reset query cache variables.
+flush query cache; # This crashed in some versions
+flush query cache; # This crashed in some versions
reset query cache;
flush status;
drop table if exists t1,t2,t3;
@@ -73,17 +73,6 @@ delete from t3 where a=10;
show status like "Qcache_queries_in_cache";
drop table t1, t2, t3;
#
-# Without auto_commit.
-#
-set autocommit=0;
-create table t1 (a int not null) type=innodb;
-insert into t1 values (1),(2),(3);
-select * from t1;
-show status like "Qcache_queries_in_cache";
-drop table t1;
-commit;
-set autocommit=1;
-#
# FLUSH QUERY CACHE
#
create table t1 (a int not null);