diff options
| author | bell@sanja.is.com.ua <> | 2003-02-27 22:26:09 +0200 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2003-02-27 22:26:09 +0200 |
| commit | 4352b9953a334e70ecff8f6e71a513d9fa95c40e (patch) | |
| tree | 1e5997ba2cebe6bd5f5e9e9e51c5391e480f1206 /mysql-test/t/query_cache.test | |
| parent | c37b62b79fb1a0cd3881f2d01e2abe4cb5adc98e (diff) | |
| download | mariadb-git-4352b9953a334e70ecff8f6e71a513d9fa95c40e.tar.gz | |
fixed SQL_SELECT option with UNIONs
Diffstat (limited to 'mysql-test/t/query_cache.test')
| -rw-r--r-- | mysql-test/t/query_cache.test | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/mysql-test/t/query_cache.test b/mysql-test/t/query_cache.test index dd092866e44..83c11978436 100644 --- a/mysql-test/t/query_cache.test +++ b/mysql-test/t/query_cache.test @@ -144,9 +144,10 @@ create table t1 (a int not null); insert into t1 values (1),(2),(3); select * from t1; show status like "Qcache_queries_in_cache"; -select sql_cache * from t1; +select sql_cache * from t1 union select * from t1; set query_cache_type=2; -select sql_cache * from t1; +select sql_cache * from t1 union select * from t1; +select * from t1 union select sql_cache * from t1; show status like "Qcache_hits"; show status like "Qcache_queries_in_cache"; set query_cache_type=on; |