diff options
| author | unknown <gluh@gluh.mysql.r18.ru> | 2004-12-30 15:20:40 +0300 |
|---|---|---|
| committer | unknown <gluh@gluh.mysql.r18.ru> | 2004-12-30 15:20:40 +0300 |
| commit | 525242d37f2f422c9ace66a3697768fcb3c95f1c (patch) | |
| tree | a29cacdddcfc6730cc111f27a803ab1b341267be /mysql-test/t/query_cache.test | |
| parent | 499deb9c442d621a1613713a05c624abcc4f24b1 (diff) | |
| download | mariadb-git-525242d37f2f422c9ace66a3697768fcb3c95f1c.tar.gz | |
wl#1629 SHOW with WHERE(final part, after review)
added syntax:
'show variables where', 'show status where', 'show open tables where'
mysql-test/r/grant_cache.result:
wl#1629 SHOW with WHERE(final part,after review)
mysql-test/r/information_schema.result:
wl#1629 SHOW with WHERE(final part,after review)
mysql-test/r/query_cache.result:
wl#1629 SHOW with WHERE(final part,after review)
mysql-test/r/temp_table.result:
wl#1629 SHOW with WHERE(final part,after review)
mysql-test/r/union.result:
wl#1629 SHOW with WHERE(final part,after review)
mysql-test/t/information_schema.test:
wl#1629 SHOW with WHERE(final part,after review)
mysql-test/t/query_cache.test:
wl#1629 SHOW with WHERE(final part,after review)
sql/item.cc:
wl#1629 SHOW with WHERE(final part,after review)
sql/mysql_priv.h:
wl#1629 SHOW with WHERE(final part,after review)
sql/sql_parse.cc:
wl#1629 SHOW with WHERE(final part,after review)
sql/sql_select.cc:
wl#1629 SHOW with WHERE(final part,after review)
sql/sql_show.cc:
wl#1629 SHOW with WHERE(final part,after review)
sql/sql_yacc.yy:
wl#1629 SHOW with WHERE(final part,after review)
sql/table.h:
wl#1629 SHOW with WHERE(final part,after review)
Diffstat (limited to 'mysql-test/t/query_cache.test')
| -rw-r--r-- | mysql-test/t/query_cache.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/query_cache.test b/mysql-test/t/query_cache.test index ed89184a0bc..26f939582e5 100644 --- a/mysql-test/t/query_cache.test +++ b/mysql-test/t/query_cache.test @@ -686,3 +686,14 @@ show status like "Qcache_hits"; # DROP TABLE t1; SET GLOBAL query_cache_size=0; + +# +# Information schema & query cache test +# +SET SESSION query_cache_type = 2; +create table t1(a int); +select table_name from information_schema.tables +where table_schema="test"; +drop table t1; +select table_name from information_schema.tables +where table_schema="test"; |