diff options
| author | Alexander Nozdrin <alik@sun.com> | 2009-01-15 13:10:20 +0300 |
|---|---|---|
| committer | Alexander Nozdrin <alik@sun.com> | 2009-01-15 13:10:20 +0300 |
| commit | 852d1d66f6c75535bbe2d74da83dc2d8d7a23f33 (patch) | |
| tree | a881ad2a42e0e5964af0ab7f604886df98d829b3 /mysql-test/t/query_cache.test | |
| parent | 9a6e05d8b9908b3b0b5bca849f5af66e7c832e7c (diff) | |
| parent | ed87b43915bd9bb03c38dd6ec3924bf592ba4703 (diff) | |
| download | mariadb-git-852d1d66f6c75535bbe2d74da83dc2d8d7a23f33.tar.gz | |
Pull from 5.0-bugteam
Diffstat (limited to 'mysql-test/t/query_cache.test')
| -rw-r--r-- | mysql-test/t/query_cache.test | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/mysql-test/t/query_cache.test b/mysql-test/t/query_cache.test index ebd24bf2b89..2dd70f415a1 100644 --- a/mysql-test/t/query_cache.test +++ b/mysql-test/t/query_cache.test @@ -1276,4 +1276,31 @@ DROP TABLE t1; SET GLOBAL concurrent_insert= @save_concurrent_insert; SET GLOBAL query_cache_size= default; +# +# Bug#36326: nested transaction and select +# + +--disable_warnings +DROP TABLE IF EXISTS t1; +--enable_warnings + +FLUSH STATUS; +SET GLOBAL query_cache_size=1048576; +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES (1),(2),(3),(4),(5); +SHOW STATUS LIKE 'Qcache_queries_in_cache'; +SELECT * FROM t1; +BEGIN; +SELECT * FROM t1; +COMMIT; +SHOW STATUS LIKE 'Qcache_queries_in_cache'; +SHOW STATUS LIKE "Qcache_hits"; +SELECT * FROM t1; +BEGIN; +SELECT * FROM t1; +COMMIT; +SHOW STATUS LIKE "Qcache_hits"; +DROP TABLE t1; +SET GLOBAL query_cache_size= default; + # End of 5.0 tests |