MySQL Bugs: #8889: INFORMATION_SCHEMA: The INFORMATION

Bug #8889	INFORMATION_SCHEMA: The INFORMATION_SCHEMA.VIEWS cannot be queried
Submitted:	2 Mar 2005 13:15	Modified:	2 Mar 2005 22:13
Reporter:	Disha	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0.2	OS:	Microsoft Windows (Windows Server 2003)
Assigned to:		CPU Architecture:	Any

Description:
When we try to query the INFORMATION_SCHEMA.VIEWS table the connection to the MySQL server gets disconnected

How to repeat:
Repro Steps : 	
1. Connect to the MySQL server as 'root'

2. Run the following query:

	SELECT * FROM INFORMATION_SCHEMA.VIEWS;

3. Observe that the connection to the MySQL server is lost.
			
Expected Results :  The INFORMATION_SCHEMA.VIEWS should be queried successfully

Actual Results :    The INFORMATION_SCHEMA.VIEWS cannot be queried and the connection to the MySQL server gets disconnected

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

tested w/5.0.3 from bk

mysql> select * from VIEWS;
+---------------+--------------+------------+------------------------------------------------------------------------------+--------------+--------------+
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | VIEW_DEFINITION                                                              | CHECK_OPTION | IS_UPDATABLE |
+---------------+--------------+------------+------------------------------------------------------------------------------+--------------+--------------+
| NULL          | test         | v50        | select `test`.`t50`.`s1` AS `s1`,`test`.`t50`.`s2` AS `s2` from `test`.`t50` | NONE         | YES          |
+---------------+--------------+------------+------------------------------------------------------------------------------+--------------+--------------+
1 row in set (0.04 sec)