Bug #12808 SHOW OPEN TABLES doesn't sort the output
Submitted: 25 Aug 2005 17:05 Modified: 5 Dec 2007 19:56
Reporter: Bugs System
Status: Verified
Category:Server: I_S Severity:S4 (Feature request)
Version:5.0.11-beta OS:Microsoft Windows (Windows XP)
Assigned to: Target Version:
Triage: Triaged: D5 (Feature request)

[25 Aug 2005 17:05] Bugs System 
Description:
SHOW OPEN TABLES lists the result unsorted.

Other SHOW queries sorts the result...

How to repeat:
SHOW OPEN TABLES;
[26 Aug 2005 11:34] 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/internals/28880
[8 Nov 2005 15:13] MySQL-Front Team 
The developers are not interessed about our bug messages.
[14 Mar 2006 9:58] Jim Winstead 
Bug #14591 is the same issue, but with the output of 'SHOW DATABASES'. it should get fixed
at the same time.
[7 Feb 2007 17:49] Chad MILLER 
Fix "=" spaces, fix indentation on we_order.

Using "-1" will create a bug -- loading a structure through th IS COM object, the
structure is zeroed out.  Use 0 as the default value or set -1 default value in
information_init() for IS.  (Ask Brian if this makes no sense.)

Use the diff-p hack.

Write test cases for all the schemas you change.