Bug #7720 SHOW FULL FIELDS crash
Submitted: 6 Jan 2005 23:24 Modified: 7 Jan 2005 0:19
Reporter: Yahya Jawed Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.2-alpha-win OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[6 Jan 2005 23:24] Yahya Jawed 
Description:
I upgraded from Mysql 5.0.1 to 5.0.2 in order to use stored procedures and triggers (like I used to in Oracle and PostgreSQL).

After doing so, I was able to do everything just fine, till I tried the SHOW FULL FIELDS/SHOW FIELDS query. Upon executing this query using mysql, mysqld-nt.exe would stop responding and eventually crash. I figured it was an install error on my part (though I've done this at least 70 different times across *nix and Windows), so I used the actual installer instead of the zip file. Still got the same behavior.

How to repeat:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.2-alpha-nt

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

mysql> USE mysql;
Database changed
mysql> SELECT User FROM user;
+------+
| User |
+------+
| root |
+------+
1 row in set (0.00 sec)

mysql> SHOW FULL FIELDS FROM user; # Crashes here
ERROR 2013 (HY000): Lost connection to MySQL server during query
[6 Jan 2005 23:36] Yahya Jawed 
Other miscellaneous information:

Error signature:

szAppName : mysqld-nt.exe     szAppVer : 0.0.0.0     szModName : mysqld-nt.exe
szModVer : 0.0.0.0     offset : 001346c4

WinXP with SP2.
[6 Jan 2005 23:42] Yahya Jawed 
Update:

Behavior replicated on Windows 2003 Server as well.
[7 Jan 2005 0:19] MySQL Verification Team 
This is related to the same cause of bug:

http://bugs.mysql.com/bug.php?id=6950