diff options
| author | unknown <gluh@mysql.com> | 2005-05-06 19:06:10 +0000 |
|---|---|---|
| committer | unknown <gluh@mysql.com> | 2005-05-06 19:06:10 +0000 |
| commit | bf049c3167b41275c878fe2e66476f4b2e476b53 (patch) | |
| tree | a3c7a1410183794df673bba84eafae2bfbb5e021 /mysql-test | |
| parent | 0430cdb7c51155de834f7e1268a862d5dd1a0210 (diff) | |
| download | mariadb-git-bf049c3167b41275c878fe2e66476f4b2e476b53.tar.gz | |
Fix for bug #10018:use INFORMATION_SCHEMA works, but show tables in it returns error
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%`; |