MySQL Bugs: #30036: SHOW TABLE TYPES causes the debug client to crash

Bug #30036	SHOW TABLE TYPES causes the debug client to crash
Submitted:	25 Jul 2007 15:03	Modified:	6 Aug 2007 19:18
Reporter:	Georgi Kodinov
Status:	Closed
Category:	Server: I_S	Severity:	S2 (Serious)
Version:	5.1.21-beta-debug-log	OS:	Linux (Fedora 7)
Assigned to:	Georgi Kodinov	Target Version:

Description:
SHOW TABLE TYPES; (without further parameters) causes the mysql client to crash.

How to repeat:
on the latest 5.1-BK (compiled with BUILD/compile-pentium-debug-max): 

mysql> show table types;
--------------
show table types
--------------

Query OK, 0 rows affected, 26739 warnings (0.00 sec)

Error: Packets out of order (Found: 2, expected 1)
lt-mysql: net.c:914: my_real_read: Assertion `0' failed.
Aborted (core dumped)

Thank you for the bug report.

[miguel@skybr 5.1]$ bin/mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.21-beta-debug Source distribution

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

mysql> show table types;
Query OK, 0 rows affected, 26739 warnings (0.00 sec)

Error: Packets out of order (Found: 2, expected 1)
mysql: net.c:914: my_real_read: Assertion `0' failed.
Aborted
[miguel@skybr 5.1]$

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/31629

ChangeSet@1.2558, 2007-07-26 18:33:05+03:00, gkodinov@magare.gmz +3 -0
  Bug #30036: SHOW TABLE TYPES causes the debug client to crash
  
  SHOW TABLE TYPES is a (to be deprecated) synonym for 
  SHOW STORAGE ENGINES.
  Fixed to use the right schema table in addition to 
  issuing a warning.

Pushed into 5.1.21-beta

Noted in 5.1.21 changelog.

For the SHOW TABLE TYPES statement, the server sent incorrect output
to clients, possibly causing them to crash.