diff options
Diffstat (limited to 'mysql-test/main/query_cache.test')
| -rw-r--r-- | mysql-test/main/query_cache.test | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/main/query_cache.test b/mysql-test/main/query_cache.test index e49387dcaf4..f8152945396 100644 --- a/mysql-test/main/query_cache.test +++ b/mysql-test/main/query_cache.test @@ -432,10 +432,12 @@ drop table t1; create table t1 (a int); insert into t1 values (1),(2),(3); show status like "Qcache_queries_in_cache"; +--enable_prepare_warnings select * from t1 into outfile "query_cache.out.file"; --error ER_FILE_EXISTS_ERROR select * from t1 into outfile "query_cache.out.file"; select * from t1 limit 1 into dumpfile "query_cache.dump.file"; +--disable_prepare_warnings show status like "Qcache_queries_in_cache"; drop table t1; let $datadir=`select @@datadir`; @@ -812,12 +814,14 @@ end// call p1()// drop procedure p1// +--enable_prepare_warnings create function f1() returns int begin Declare var1 int; select max(a) from t1 into var1; return var1; end// +--disable_prepare_warnings create procedure `p1`() begin select a, f1() from t1; |