diff options
Diffstat (limited to 'mysql-test/t/query_cache.test')
| -rw-r--r-- | mysql-test/t/query_cache.test | 14 |
1 files changed, 12 insertions, 2 deletions
diff --git a/mysql-test/t/query_cache.test b/mysql-test/t/query_cache.test index c8371ea31f1..6e68b57bb3c 100644 --- a/mysql-test/t/query_cache.test +++ b/mysql-test/t/query_cache.test @@ -439,10 +439,10 @@ create table t1 (a int); insert into t1 values (1),(2); show status like "Qcache_queries_in_cache"; select * from t1; -SET OPTION SQL_SELECT_LIMIT=1; +SET SQL_SELECT_LIMIT=1; select * from t1; show status like "Qcache_queries_in_cache"; -SET OPTION SQL_SELECT_LIMIT=DEFAULT; +SET SQL_SELECT_LIMIT=DEFAULT; drop table t1; # @@ -1617,6 +1617,16 @@ select @@query_cache_size, @@global.query_cache_type, @@local.query_cache_type; set local query_cache_type= on; select @@query_cache_size, @@global.query_cache_type, @@local.query_cache_type; +--echo # +--echo # Bug#12977203: SERVER CRASH ON A DERIVED TABLE WITH QUERY CACHE ENABLED +--echo # +SET @qc= @@query_cache_size; +SET GLOBAL query_cache_size=1355776; +CREATE TABLE t1 (f1 blob); +SELECT COUNT(*) FROM (SELECT * FROM t1 ) tt; +DROP TABLE t1; +SET GLOBAL query_cache_size= @qc; +--echo # --echo restore defaults SET GLOBAL query_cache_type= default; |