Bug #12808 SHOW OPEN TABLES doesn't sort the output
Submitted: 25 Aug 2005 15:05 Modified: 5 Dec 2007 18:56
Reporter: Bugs System Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Information schema Severity:S4 (Feature request)
Version:5.0.11-beta OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[25 Aug 2005 15: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 9: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 14:13] MySQL-Front Team 
The developers are not interessed about our bug messages.
[14 Mar 2006 8: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 16: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.