Bug #10131 DESCRIBE COMMAND PROBLEM

• Submitted: 25 Apr 2005 0:46
• Modified: 25 Apr 2005 19:31
• Reporter: Robert Howard
• Status: Can't repeat
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: MySQL ver.5.0.3
• OS: Windows (Windows NT 2000)
• CPU Architecture: Any

[25 Apr 2005 0:46] Robert Howard

Description:
I am very new to SQL so hopefully, I'm not wasting your time with this report.

When trying to use the DESCRIBE command, the query stops, the command editor minimizes to the task bar and the MySQL service stops cold.  I get the dialog box that says Error 2013 (HY000).

Is this a commom problem in Windows NT 2000?  I'm not real sure but I think the same thing happens when I try to use the SHOW COLUMNS command.

Hope this helps.

How to repeat:
Install version 5.0.3 on an NT 2000 unit and create a database and tables.  Then use the Describe command on one of the tables .

Good Luck

[25 Apr 2005 0:50] Robert Howard

Opps, used the wrong word.

[25 Apr 2005 19:31] Jorge del Conde

this was tested w/5.0.3 winxp:

mysql> describe example;
+---------+-------------+------+-----+---------+----------------+
| Field   | Type        | Null | Key | Default | Extra          |
+---------+-------------+------+-----+---------+----------------+
| id      | int(3)      | NO   | PRI | NULL    | auto_increment |
| example | varchar(30) | NO   |     |         |                |
+---------+-------------+------+-----+---------+----------------+