diff options
| author | sanja@arthur.local <> | 2005-08-11 13:07:08 +0300 |
|---|---|---|
| committer | sanja@arthur.local <> | 2005-08-11 13:07:08 +0300 |
| commit | 3b64651683a6f8d9276fd49843832f672312f880 (patch) | |
| tree | 2cc73db6b2870b7e414402ae3e20ccb9030d28ff /mysql-test/t/query_cache_notembedded.test | |
| parent | 4f26fa51841d443bd8be109abccb2e586b4eec4f (diff) | |
| download | mariadb-git-3b64651683a6f8d9276fd49843832f672312f880.tar.gz | |
query_cache_notembedded.test, query_cache_notembedded.result:
postmerge fix
Diffstat (limited to 'mysql-test/t/query_cache_notembedded.test')
| -rw-r--r-- | mysql-test/t/query_cache_notembedded.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/query_cache_notembedded.test b/mysql-test/t/query_cache_notembedded.test index d29dc10ccae..fd4785ffe95 100644 --- a/mysql-test/t/query_cache_notembedded.test +++ b/mysql-test/t/query_cache_notembedded.test @@ -78,4 +78,23 @@ show status like "Qcache_total_blocks"; show status like "Qcache_free_blocks"; drop table t1, t2, t3, t11, t21; +# +# do not use QC if tables locked (BUG#12385) +# +connect (root,localhost,root,,test,$MASTER_MYPORT,master.sock); +connection root; +CREATE TABLE t1 ( a INT NOT NULL PRIMARY KEY AUTO_INCREMENT ) ENGINE = +MyISAM; +LOCK TABLE t1 READ LOCAL; +connect (root2,localhost,root,,test,$MASTER_MYPORT,master.sock); +connection root2; +INSERT INTO t1 VALUES (), (), (); +connection root; +SELECT * FROM t1; +connection root2; +SELECT * FROM t1; +connection root; +SELECT * FROM t1; +drop table t1; + set GLOBAL query_cache_size=0; |