Bug #7010 Mysql 5.0.2 crashes for show columns

• Submitted: 4 Dec 2004 16:59
• Modified: 4 Dec 2004 17:45
• Reporter: Helmut Leininger
• Status: Duplicate
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.2-1lpha
• OS: Windows (Windows XP)
• CPU Architecture: Any

[4 Dec 2004 16:59] Helmut Leininger

Description:
Mysql Server crashes for statements showing the columns of a table (i.e. show columns or describe)

How to repeat:
Mysql server 5.0.2-alpha
use Mysql Administrator or Mysql Query Browser or any other tools and issue a command showing the columns of a table.

[4 Dec 2004 17:45] MySQL Verification Team

Duplicate for #6950

[5 Dec 2004 17:17] Masada Disenhouse

Just wanted to add that it also crashes the MySQL server under Windows 2000 - crashes the service so needs to be reloaded in windows.

[28 Dec 2004 20:50] Robert Romnek

I am running into the same issue with either 'show columns from table_name;' or 'describe table_name;' with Windows 2000 directly in mysql on the server.  I am required to exit mysql and 'net start mysql'.

[3 Jan 2005 9:51] John-Paul Thompson

I have the same issue.
In 5.0.2  on XP, the describe statement crashes the server.
Is there a patch available?

[20 Mar 2005 10:00] prabhu bethuraj

i also struck with the same problem..
mysqld server crashes on using the following query's:

1. desc table_name;
2. any query based on INFORMATION_SCHEMA.COLUMNS
    eg: select * from information_schema.columns;

m.prabhu bethuraj
20-03-2005