summaryrefslogtreecommitdiff
path: root/mysql-test/t/information_schema.test
diff options
context:
space:
mode:
authorSergey Glukhov <Sergey.Glukhov@sun.com>2009-10-23 14:19:54 +0500
committerSergey Glukhov <Sergey.Glukhov@sun.com>2009-10-23 14:19:54 +0500
commit676c12e2d4a89cae2f396900b4648cda8e3c1abf (patch)
treedf61ee82293849b166a89f8294feec427ecc2cf8 /mysql-test/t/information_schema.test
parent0a0f50e4ab671190d106aaf6e86576ab393e309b (diff)
downloadmariadb-git-676c12e2d4a89cae2f396900b4648cda8e3c1abf.tar.gz
Bug#35428 When selecting from INFORMATION_SCHEMA tables, incomplete metadata
backport to Betony
Diffstat (limited to 'mysql-test/t/information_schema.test')
-rw-r--r--mysql-test/t/information_schema.test10
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/information_schema.test b/mysql-test/t/information_schema.test
index fc9e42b90b5..9da7cc1042d 100644
--- a/mysql-test/t/information_schema.test
+++ b/mysql-test/t/information_schema.test
@@ -1441,5 +1441,15 @@ EXPLAIN SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
EXPLAIN SELECT * FROM INFORMATION_SCHEMA.TRIGGERS
WHERE EVENT_OBJECT_SCHEMA='test';
+#
+# Bug #43834 Assertion in Natural_join_column::db_name() on an I_S query
+#
+SELECT *
+FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
+LEFT JOIN INFORMATION_SCHEMA.COLUMNS
+USING (TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME)
+WHERE COLUMNS.TABLE_SCHEMA = 'test'
+AND COLUMNS.TABLE_NAME = 't1';
+
# Wait till all disconnects are completed
--source include/wait_until_count_sessions.inc