Bug #8822 Catching some Information about db's Schema makes error
Submitted: 26 Feb 2005 20:17 Modified: 27 Feb 2005 13:31
Reporter: Amir Gheibi Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S2 (Serious)
Version:5.0.2-alpha OS:Windows (Windows XP SP2)
Assigned to: CPU Architecture:Any

[26 Feb 2005 20:17] Amir Gheibi
Description:
I tried to get some information about columns with queries like "SHOW COLUMNS FROM TBL;"  or  "SELECT * FROM INFORMATION_SCHEMA.COLUMNS" raise an exception that says mysqld-max-nt made error.Lost connection to MySql server during query.
I also saw this problem with some thired-party applications like SQLYOG. It can not show the columns of a selected table and raise same error.
I had same problem with INFORMATION_SCHEMA.VIEWS too.

But I can run "SELECT * FROM INFORMATION_SCHEMA.TABLES" without any problem.

How to repeat:
SHOW COLUMNS
SELECT * FROM INFORMATION_SCHEMA.COLUMNS
SELECT * FROM INFORMATION_SCHEMA.VIEWS

Suggested fix:
I have no idea. I'm new in the world of open-source.
[26 Feb 2005 20:36] Amir Gheibi
I checked the bugs' database after that I submitted this bug.
This bug is copy of the bug #6950.