From c4f89626eeba1222e3a7c5f5bd9c9548a55b943d Mon Sep 17 00:00:00 2001 From: unknown Date: Thu, 6 Mar 2003 17:37:12 +0200 Subject: do not allow to cache queries with INTO clause mysql-test/r/query_cache.result: INTO OUTFILE/DUMPFILE test mysql-test/t/query_cache.test: INTO OUTFILE/DUMPFILE test --- mysql-test/t/query_cache.test | 13 +++++++++++++ 1 file changed, 13 insertions(+) (limited to 'mysql-test/t/query_cache.test') diff --git a/mysql-test/t/query_cache.test b/mysql-test/t/query_cache.test index dd092866e44..f19d3bdc93a 100644 --- a/mysql-test/t/query_cache.test +++ b/mysql-test/t/query_cache.test @@ -406,4 +406,17 @@ 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; + +# +# INTO OUTFILE/DUMPFILE test +# + +drop table if exists t1; +create table t1 (a int); +insert into t1 values (1),(2),(3); +show status like "Qcache_queries_in_cache"; +select * from t1 into outfile "query_caceh.out.file"; +select * from t1 limit 1 into dumpfile "query_cache.dump.file"; +show status like "Qcache_queries_in_cache"; drop table t1; \ No newline at end of file -- cgit v1.2.1