summaryrefslogtreecommitdiff
path: root/mysql-test/t/information_schema_db.test
diff options
context:
space:
mode:
authorunknown <gluh@mysql.com>2005-05-06 19:06:10 +0000
committerunknown <gluh@mysql.com>2005-05-06 19:06:10 +0000
commitbf049c3167b41275c878fe2e66476f4b2e476b53 (patch)
treea3c7a1410183794df673bba84eafae2bfbb5e021 /mysql-test/t/information_schema_db.test
parent0430cdb7c51155de834f7e1268a862d5dd1a0210 (diff)
downloadmariadb-git-bf049c3167b41275c878fe2e66476f4b2e476b53.tar.gz
Fix for bug #10018:use INFORMATION_SCHEMA works, but show tables in it returns error
Diffstat (limited to 'mysql-test/t/information_schema_db.test')
-rw-r--r--mysql-test/t/information_schema_db.test9
1 files changed, 9 insertions, 0 deletions
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%`;