diff options
| author | gbichot@quadita2.mysql.com <> | 2005-05-10 20:35:12 +0200 |
|---|---|---|
| committer | gbichot@quadita2.mysql.com <> | 2005-05-10 20:35:12 +0200 |
| commit | 3c81444476cebbf34ea99dae567077ca2f1648dc (patch) | |
| tree | 48ef8aaa72bb7742bc6c764d5794edd1b7463cb0 /mysql-test | |
| parent | b6ca1a1485d03db27367296b9719cc33ed2978a4 (diff) | |
| parent | efaeb069e7abd8e8845121c05f4f2bfe9f49fb00 (diff) | |
| download | mariadb-git-3c81444476cebbf34ea99dae567077ca2f1648dc.tar.gz | |
Merge gbichot@bk-internal.mysql.com:/home/bk/mysql-5.0
into quadita2.mysql.com:/nfstmp1/guilhem/mysql-5.0-4ita
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/information_schema_db.result | 28 | ||||
| -rw-r--r-- | mysql-test/t/information_schema_db.test | 9 |
2 files changed, 37 insertions, 0 deletions
diff --git a/mysql-test/r/information_schema_db.result b/mysql-test/r/information_schema_db.result new file mode 100644 index 00000000000..0ccb22be22a --- /dev/null +++ b/mysql-test/r/information_schema_db.result @@ -0,0 +1,28 @@ +use INFORMATION_SCHEMA; +show tables; +Tables_in_INFORMATION_SCHEMA +SCHEMATA +TABLES +COLUMNS +CHARACTER_SETS +COLLATIONS +COLLATION_CHARACTER_SET_APPLICABILITY +ROUTINES +STATISTICS +VIEWS +USER_PRIVILEGES +SCHEMA_PRIVILEGES +TABLE_PRIVILEGES +COLUMN_PRIVILEGES +TABLE_CONSTRAINTS +KEY_COLUMN_USAGE +show tables from INFORMATION_SCHEMA like 'T%'; +Tables_in_INFORMATION_SCHEMA (T%) +TABLES +TABLE_PRIVILEGES +TABLE_CONSTRAINTS +create database `inf%`; +use `inf%`; +show tables; +Tables_in_inf% +drop database `inf%`; diff --git a/mysql-test/t/information_schema_db.test b/mysql-test/t/information_schema_db.test new file mode 100644 index 00000000000..f88d04c2783 --- /dev/null +++ b/mysql-test/t/information_schema_db.test @@ -0,0 +1,9 @@ +-- source include/testdb_only.inc + +use INFORMATION_SCHEMA; +show tables; +show tables from INFORMATION_SCHEMA like 'T%'; +create database `inf%`; +use `inf%`; +show tables; +drop database `inf%`; |