diff options
| author | unknown <sanja@arthur.local> | 2005-08-11 13:07:08 +0300 |
|---|---|---|
| committer | unknown <sanja@arthur.local> | 2005-08-11 13:07:08 +0300 |
| commit | bf07693148f916b27e8a520965fdd556ad054806 (patch) | |
| tree | 2cc73db6b2870b7e414402ae3e20ccb9030d28ff /mysql-test/t/query_cache_notembedded.test | |
| parent | 7a3cf493899a5d2c522e95de5ae97f707f623258 (diff) | |
| download | mariadb-git-bf07693148f916b27e8a520965fdd556ad054806.tar.gz | |
query_cache_notembedded.test, query_cache_notembedded.result:
postmerge fix
mysql-test/r/query_cache_notembedded.result:
postmerge fix
mysql-test/t/query_cache_notembedded.test:
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; |