summaryrefslogtreecommitdiff
path: root/mysql-test/t/query_cache.test
diff options
context:
space:
mode:
authorunknown <thek@adventure.(none)>2008-01-07 21:06:18 +0100
committerunknown <thek@adventure.(none)>2008-01-07 21:06:18 +0100
commit44101143f7668cc753f9f78057f164469b051760 (patch)
tree43e90ecdb33547c3d30ebba07889eb7b6c7928fe /mysql-test/t/query_cache.test
parent8a824b6733fcdb69429b4c09d2397d73b4182414 (diff)
downloadmariadb-git-44101143f7668cc753f9f78057f164469b051760.tar.gz
Fixed test layout error.
mysql-test/r/query_cache.result: Moved test which requires debug binaries to a new file. mysql-test/t/query_cache.test: Moved test which requires debug binaries to a new file. mysql-test/r/query_cache_debug.result: Moved test which requires debug binaries to a new file. mysql-test/t/query_cache_debug.test: Moved test which requires debug binaries to a new file.
Diffstat (limited to 'mysql-test/t/query_cache.test')
-rw-r--r--mysql-test/t/query_cache.test42
1 files changed, 0 insertions, 42 deletions
diff --git a/mysql-test/t/query_cache.test b/mysql-test/t/query_cache.test
index 14cd9385ca6..771a32e8cd7 100644
--- a/mysql-test/t/query_cache.test
+++ b/mysql-test/t/query_cache.test
@@ -1316,47 +1316,5 @@ SELECT 1 FROM t1 GROUP BY
(SELECT LAST_INSERT_ID() FROM t1 ORDER BY MIN(a) ASC LIMIT 1);
DROP TABLE t1;
-#
-# Bug #30887 Server crashes on SET GLOBAL query_cache_size=0
-#
-flush status;
-set query_cache_type=DEMAND;
-set global query_cache_size= 1024*1024*512;
---disable_warnings
-drop table if exists t1;
---enable_warnings
-create table t1 (a varchar(100));
-insert into t1 values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'),('bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb');
-connect (bug30887con1, localhost, root, ,test);
-connect (bug30887con2, localhost, root, ,test);
-
-connection bug30887con1;
---echo Activate debug hook and attempt to retrieve the statement from the cache.
-set session debug='+d,wait_in_query_cache_insert';
---send select SQL_CACHE * from t1;
-
-connection default;
-let $wait_condition= select count(*)= 1 from information_schema.processlist where state= 'wait_in_query_cache_insert';
---source include/wait_condition.inc
-
-connection bug30887con2;
---echo On a second connection; clear the query cache.
-show status like 'Qcache_queries_in_cache';
---send set global query_cache_size= 0;
-
-connection default;
---echo Signal the debug hook to release the lock.
-select id from information_schema.processlist where state='wait_in_query_cache_insert' into @thread_id;
-kill query @thread_id;
-
---echo Show query cache status.
-show status like 'Qcache_queries_in_cache';
-
-disconnect bug30887con1;
-disconnect bug30887con2;
-set global query_cache_size= 0;
-use test;
-drop table t1;
-
--echo End of 5.1 tests