diff options
author | unknown <thek@adventure.(none)> | 2008-01-07 21:06:18 +0100 |
---|---|---|
committer | unknown <thek@adventure.(none)> | 2008-01-07 21:06:18 +0100 |
commit | 44101143f7668cc753f9f78057f164469b051760 (patch) | |
tree | 43e90ecdb33547c3d30ebba07889eb7b6c7928fe /mysql-test/r | |
parent | 8a824b6733fcdb69429b4c09d2397d73b4182414 (diff) | |
download | mariadb-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/r')
-rw-r--r-- | mysql-test/r/query_cache.result | 24 | ||||
-rw-r--r-- | mysql-test/r/query_cache_debug.result | 24 |
2 files changed, 24 insertions, 24 deletions
diff --git a/mysql-test/r/query_cache.result b/mysql-test/r/query_cache.result index f813d2cc7e0..1a728354c7b 100644 --- a/mysql-test/r/query_cache.result +++ b/mysql-test/r/query_cache.result @@ -1669,28 +1669,4 @@ SELECT 1 FROM t1 GROUP BY 1 1 DROP TABLE t1; -flush status; -set query_cache_type=DEMAND; -set global query_cache_size= 1024*1024*512; -drop table if exists t1; -create table t1 (a varchar(100)); -insert into t1 values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'),('bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb'); -Activate debug hook and attempt to retrieve the statement from the cache. -set session debug='+d,wait_in_query_cache_insert'; -select SQL_CACHE * from t1;; -On a second connection; clear the query cache. -show status like 'Qcache_queries_in_cache'; -Variable_name Value -Qcache_queries_in_cache 1 -set global query_cache_size= 0;; -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; -Show query cache status. -show status like 'Qcache_queries_in_cache'; -Variable_name Value -Qcache_queries_in_cache 1 -set global query_cache_size= 0; -use test; -drop table t1; End of 5.1 tests diff --git a/mysql-test/r/query_cache_debug.result b/mysql-test/r/query_cache_debug.result new file mode 100644 index 00000000000..4a4948c9845 --- /dev/null +++ b/mysql-test/r/query_cache_debug.result @@ -0,0 +1,24 @@ +flush status; +set query_cache_type=DEMAND; +set global query_cache_size= 1024*1024*512; +drop table if exists t1; +create table t1 (a varchar(100)); +insert into t1 values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'),('bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb'); +Activate debug hook and attempt to retrieve the statement from the cache. +set session debug='+d,wait_in_query_cache_insert'; +select SQL_CACHE * from t1;; +On a second connection; clear the query cache. +show status like 'Qcache_queries_in_cache'; +Variable_name Value +Qcache_queries_in_cache 1 +set global query_cache_size= 0;; +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; +Show query cache status. +show status like 'Qcache_queries_in_cache'; +Variable_name Value +Qcache_queries_in_cache 1 +set global query_cache_size= 0; +use test; +drop table t1; |