diff options
| author | unknown <bell@sanja.is.com.ua> | 2003-02-27 22:26:09 +0200 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2003-02-27 22:26:09 +0200 |
| commit | 5b2a810e5d857856971dcd0e9f88ec1a397486d2 (patch) | |
| tree | 1e5997ba2cebe6bd5f5e9e9e51c5391e480f1206 /mysql-test/r/query_cache.result | |
| parent | 828d7c6ec2fcd3a124dc043d7c19472106a11721 (diff) | |
| download | mariadb-git-5b2a810e5d857856971dcd0e9f88ec1a397486d2.tar.gz | |
fixed SQL_SELECT option with UNIONs
mysql-test/r/query_cache.result:
test of SQL_CACHE with UNIONs
mysql-test/t/query_cache.test:
test of SQL_CACHE with UNIONs
Diffstat (limited to 'mysql-test/r/query_cache.result')
| -rw-r--r-- | mysql-test/r/query_cache.result | 11 |
1 files changed, 8 insertions, 3 deletions
diff --git a/mysql-test/r/query_cache.result b/mysql-test/r/query_cache.result index 41fccc2743c..74dee666e05 100644 --- a/mysql-test/r/query_cache.result +++ b/mysql-test/r/query_cache.result @@ -237,13 +237,18 @@ a show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 0 -select sql_cache * from t1; +select sql_cache * from t1 union select * from t1; a 1 2 3 set query_cache_type=2; -select sql_cache * from t1; +select sql_cache * from t1 union select * from t1; +a +1 +2 +3 +select * from t1 union select sql_cache * from t1; a 1 2 @@ -253,7 +258,7 @@ Variable_name Value Qcache_hits 4 show status like "Qcache_queries_in_cache"; Variable_name Value -Qcache_queries_in_cache 1 +Qcache_queries_in_cache 2 set query_cache_type=on; reset query cache; show status like "Qcache_queries_in_cache"; |