Bug #30036 SHOW TABLE TYPES causes the debug client to crash

• Submitted: 25 Jul 2007 13:03
• Modified: 17 Jun 2010 1:13
• Reporter: Georgi Kodinov
• Status: Closed
• Category: MySQL Server: Information schema
• Severity: S2 (Serious)
• Version: 5.1.21-beta-debug-log
• OS: Linux (Fedora 7)
• Assigned to: Georgi Kodinov
• CPU Architecture: Any

[25 Jul 2007 13:03] Georgi Kodinov

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)

[25 Jul 2007 14:59] MySQL Verification Team

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]$

[26 Jul 2007 15:33] Bugs System

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, [e-mail] +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.

[2 Aug 2007 19:12] Bugs System

Pushed into 5.1.21-beta

[6 Aug 2007 17:18] Paul DuBois

Noted in 5.1.21 changelog.

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

[21 May 2010 14:47] Bugs System

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/108879

3055 Alexander Nozdrin	2010-05-21
      Backporting a test case for Bug#30036 (SHOW TABLE TYPES causes the debug client
      to crash) from mysql-6.0-codebase.

[15 Jun 2010 8:15] Bugs System

Pushed into 5.5.5-m3 (revid:[e-mail]-20100615080459-smuswd9ooeywcxuc) (version source revid:[e-mail]-20100415070122-1nxji8ym4mao13ao) (merge vers: 5.1.47) (pib:16)

[15 Jun 2010 8:24] Bugs System

Pushed into mysql-next-mr (revid:[e-mail]-20100615080558-cw01bzdqr1bdmmec) (version source revid:[e-mail]-20100415070122-1nxji8ym4mao13ao) (pib:16)

[17 Jun 2010 1:13] Paul DuBois

Additional patch was for test case only. No changelog entry needed.