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

[2 Mar 2005 13:15] Disha
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
[2 Mar 2005 22:13] Jorge del Conde
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)