summaryrefslogtreecommitdiff
path: root/mysql-test/t/query_cache.test
diff options
context:
space:
mode:
authorunknown <bell@sanja.is.com.ua>2005-12-01 14:38:29 +0200
committerunknown <bell@sanja.is.com.ua>2005-12-01 14:38:29 +0200
commit68db75c56c8fb5c5163730c7c0a891ccc72da350 (patch)
tree2fdb203e8cc312708738a9c8aab02d81cd9ac837 /mysql-test/t/query_cache.test
parentba1eb86240afa7c9f818170effb62c65973e87ef (diff)
parent134fe7143c9ce073da57d5ec6541a55e14c85cdc (diff)
downloadmariadb-git-68db75c56c8fb5c5163730c7c0a891ccc72da350.tar.gz
Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-4.1
into sanja.is.com.ua:/home/bell/mysql/bk/work-merge1-5.0 configure.in: merge mysql-test/r/query_cache.result: merge mysql-test/t/query_cache.test: merge sql/sql_cache.cc: merge
Diffstat (limited to 'mysql-test/t/query_cache.test')
-rw-r--r--mysql-test/t/query_cache.test15
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/query_cache.test b/mysql-test/t/query_cache.test
index 646151a5aae..d83f84661d5 100644
--- a/mysql-test/t/query_cache.test
+++ b/mysql-test/t/query_cache.test
@@ -743,6 +743,21 @@ show status like "Qcache_hits";
drop table t1;
#
+# BUG#14652: Queries with leading '(' characters.
+#
+create table t1 (a int);
+flush status;
+(select a from t1) union (select a from t1);
+show status like "Qcache_queries_in_cache";
+show status like "Qcache_inserts";
+show status like "Qcache_hits";
+(select a from t1) union (select a from t1);
+show status like "Qcache_queries_in_cache";
+show status like "Qcache_inserts";
+show status like "Qcache_hits";
+drop table t1;
+
+#
# SP cursors and selects with query cache (BUG#9715)
#
create table t1 (a int);