From 465745a20063c4c368750415d9c8b331374b91dd Mon Sep 17 00:00:00 2001
From: "timour@mysql.com" <>
Date: Wed, 22 Feb 2006 10:04:10 +0200
Subject: Fix for BUG#17523: natural join and information schema.

The cause of the bug was an ASSERT that checked the consistency
of TABLE_SHARE::db and TABLE_LIST::db and failed for I_S tables.
The fix relaxes the requirement for consistency for I_S.
---
 mysql-test/t/join.test | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'mysql-test/t/join.test')

diff --git a/mysql-test/t/join.test b/mysql-test/t/join.test
index 553aaf987bb..90abc61ca07 100644
--- a/mysql-test/t/join.test
+++ b/mysql-test/t/join.test
@@ -523,6 +523,12 @@ select t1.b from v1a;
 -- error 1054
 select * from v1a join v1b on t1.b = t2.b;
 
+#
+# Bug #17523 natural join and information_schema
+#
+select * from information_schema.statistics join information_schema.columns
+              using(table_name,column_name) where table_name='user';
+
 drop table t1;
 drop table t2;
 drop table t3;
-- 
cgit v1.2.1