diff options
| author | Davi Arnaut <Davi.Arnaut@Sun.COM> | 2009-01-15 08:28:10 -0200 |
|---|---|---|
| committer | Davi Arnaut <Davi.Arnaut@Sun.COM> | 2009-01-15 08:28:10 -0200 |
| commit | e48c7178f7fb1a64558027e1574e3008368030c6 (patch) | |
| tree | 13477e1822c17bda5ef63ff3207a8246f83eafd2 /mysql-test/t/query_cache.test | |
| parent | 91e5423c642c23ba393f005c844c6ee37093e1a8 (diff) | |
| parent | 852d1d66f6c75535bbe2d74da83dc2d8d7a23f33 (diff) | |
| download | mariadb-git-e48c7178f7fb1a64558027e1574e3008368030c6.tar.gz | |
Merge 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 fe720ee68b7..6b1ef211fc1 100644 --- a/mysql-test/t/query_cache.test +++ b/mysql-test/t/query_cache.test @@ -1261,6 +1261,33 @@ 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; + --echo End of 5.0 tests # |