summaryrefslogtreecommitdiff
path: root/mysql-test/r/query_cache.result
diff options
context:
space:
mode:
authorramil@mysql.com <>2005-09-06 15:00:35 +0500
committerramil@mysql.com <>2005-09-06 15:00:35 +0500
commit68acf8fdea1af29bccc01bc251878989540a9aeb (patch)
treec261ab180af03ac30a8a8be7a06d6b62b1ee74ee /mysql-test/r/query_cache.result
parentc601bb87f856728a6429b9323914df59a6f87479 (diff)
downloadmariadb-git-68acf8fdea1af29bccc01bc251878989540a9aeb.tar.gz
fix (bug #10303: Misleading Last_query_cost value).
Diffstat (limited to 'mysql-test/r/query_cache.result')
-rw-r--r--mysql-test/r/query_cache.result16
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/query_cache.result b/mysql-test/r/query_cache.result
index 0efd5ac1566..06f1d2d0e7c 100644
--- a/mysql-test/r/query_cache.result
+++ b/mysql-test/r/query_cache.result
@@ -1127,3 +1127,19 @@ Qcache_hits 9
drop procedure f1;
drop table t1;
set GLOBAL query_cache_size=0;
+SET GLOBAL query_cache_size=102400;
+create table t1(a int);
+insert into t1 values(0), (1), (4), (5);
+select * from t1 where a > 3;
+a
+4
+5
+select * from t1 where a > 3;
+a
+4
+5
+show status like 'last_query_cost';
+Variable_name Value
+Last_query_cost 0.000000
+drop table t1;
+SET GLOBAL query_cache_size=0;