diff options
| author | unknown <bell@sanja.is.com.ua> | 2003-02-14 22:20:38 +0200 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2003-02-14 22:20:38 +0200 |
| commit | d13d8aa00eed069f1f2454ceb6a12b3158b4796a (patch) | |
| tree | c8abda27b5b7d2dd84cb7f60a873026ef2ddaef0 /mysql-test/t/query_cache.test | |
| parent | fb2c8c7cb879f7f46fda0398e4aa3051d9017997 (diff) | |
| download | mariadb-git-d13d8aa00eed069f1f2454ceb6a12b3158b4796a.tar.gz | |
fixed invalidation of query cache on LOAD DATA
mysql-test/r/query_cache.result:
test of LOAD DATA
mysql-test/t/query_cache.test:
test of LOAD DATA
Diffstat (limited to 'mysql-test/t/query_cache.test')
| -rw-r--r-- | mysql-test/t/query_cache.test | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/mysql-test/t/query_cache.test b/mysql-test/t/query_cache.test index f77ea3c3b2a..dd092866e44 100644 --- a/mysql-test/t/query_cache.test +++ b/mysql-test/t/query_cache.test @@ -384,7 +384,6 @@ select * from mysql.db; enable_result_log; show status like "Qcache_queries_in_cache"; - # # simple rename test # @@ -397,3 +396,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 |