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.test12
1 files changed, 11 insertions, 1 deletions
diff --git a/mysql-test/t/query_cache.test b/mysql-test/t/query_cache.test
index 5f2cf8b5f56..47ea2d06d0a 100644
--- a/mysql-test/t/query_cache.test
+++ b/mysql-test/t/query_cache.test
@@ -388,7 +388,6 @@ select * from mysql.db;
enable_result_log;
show status like "Qcache_queries_in_cache";
-
#
# simple rename test
#
@@ -401,3 +400,14 @@ select * from t1 where id=2;
drop table t2;
-- error 1146
select * from t1 where id=2;
+
+#
+# Load data invalidation test
+#
+
+create table t1 (word char(20) not null);
+select * from t1;
+show status like "Qcache_queries_in_cache";
+load data infile '../../std_data/words.dat' into table t1;
+show status like "Qcache_queries_in_cache";
+drop table t1; \ No newline at end of file