diff options
| author | gluh@gluh.mysql.r18.ru <> | 2004-12-30 15:20:40 +0300 |
|---|---|---|
| committer | gluh@gluh.mysql.r18.ru <> | 2004-12-30 15:20:40 +0300 |
| commit | 50266af38caddb9d9d0186431976969e6050d88c (patch) | |
| tree | a29cacdddcfc6730cc111f27a803ab1b341267be /mysql-test/r/query_cache.result | |
| parent | 043c1d32801e95895e6a2c894fcdf0aefe5c5150 (diff) | |
| download | mariadb-git-50266af38caddb9d9d0186431976969e6050d88c.tar.gz | |
wl#1629 SHOW with WHERE(final part, after review)
added syntax:
'show variables where', 'show status where', 'show open tables where'
Diffstat (limited to 'mysql-test/r/query_cache.result')
| -rw-r--r-- | mysql-test/r/query_cache.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/query_cache.result b/mysql-test/r/query_cache.result index 57c5da870ad..3568be8cc12 100644 --- a/mysql-test/r/query_cache.result +++ b/mysql-test/r/query_cache.result @@ -947,3 +947,13 @@ Variable_name Value Qcache_hits 7 DROP TABLE t1; SET GLOBAL query_cache_size=0; +SET SESSION query_cache_type = 2; +create table t1(a int); +select table_name from information_schema.tables +where table_schema="test"; +table_name +t1 +drop table t1; +select table_name from information_schema.tables +where table_schema="test"; +table_name |