Bug #6940 Connection lost when using Describe

• Submitted: 2 Dec 2004 13:38
• Modified: 3 Dec 2004 20:03
• Reporter: Maxime L
• Status: Duplicate
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.0.2 Alpha
• OS: Windows (Windows 2000)
• CPU Architecture: Any

[2 Dec 2004 13:38] Maxime L

Description:
It seems that the server crashes when trying to use the 'describe' function

How to repeat:
prompt> use MyDatabse;
prompt> describe MyTable;

Or it could also be reproduced by using Mysql Query Browser and browsing 'shemadata'

[2 Dec 2004 23:55] Hartmut Holzgraefe

Please add the CREATE TABLE statements for the failing table

[3 Dec 2004 7:25] MySQL Verification Team

I was able reproduce it only on Windows

[3 Dec 2004 8:49] Maxime L

It was not on a specific table.
So just try with mysql tables' database or create a simple table with a few columns.

[3 Dec 2004 19:17] Tim Champion

I have the same issue with 5.0.2 Alpha on Windows XP Pro (sp1). Any desc (on any table) crashes the server.

[3 Dec 2004 20:03] MySQL Verification Team

I am changing the status for duplicate because is related to the crash
source as bug reports: #6950 and #6955.

Below the output with a 5.0.2 server with the patch already applied
to the those bugs:

C:\mysql\bin>mysql -uroot mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.2-alpha-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> desc user;
+-----------------------+-----------------------------------+------+-----+---------+-------+
| Field                 | Type                              | Null | Key | Default | Extra |
+-----------------------+-----------------------------------+------+-----+---------+-------+
| Host                  | varchar(60)                       |      | PRI |         |       |
| User                  | varchar(16)                       |      | PRI |         |       |
| Password              | varchar(41)                       |      |     |         |       |
| Select_priv           | enum('N','Y')                     |      |     | N       |       |
| Insert_priv           | enum('N','Y')                     |      |     | N       |       |
| Update_priv           | enum('N','Y')                     |      |     | N       |       |
| Delete_priv           | enum('N','Y')                     |      |     | N       |       |
| Create_priv           | enum('N','Y')                     |      |     | N       |       |
| Drop_priv             | enum('N','Y')                     |      |     | N       |       |
| Reload_priv           | enum('N','Y')                     |      |     | N       |       |

<cut>

| max_questions         | int(11) unsigned                  |      |     | 0       |       |
| max_updates           | int(11) unsigned                  |      |     | 0       |       |
| max_connections       | int(11) unsigned                  |      |     | 0       |       |
+-----------------------+-----------------------------------+------+-----+---------+-------+
33 rows in set (0.20 sec)

Thank you for the bug report.