MySQL Bugs: #14591: SHOW DATABASES does not order infomation

Bug #14591	SHOW DATABASES does not order infomation_schema correct
Submitted:	2 Nov 2005 22:17	Modified:	14 Mar 2006 9:59
Reporter:	Bugs System
Status:	Duplicate
Category:	Server	Severity:	S3 (Non-critical)
Version:	5.0.15/BK source 5.0	OS:	Microsoft Windows (Windows XP/Linux)
Assigned to:	Jim Winstead	Target Version:

Description:
Since I can't reopen a accidently closed error I have to create a new one.

The original bug is reported here:
http://bugs.mysql.com/bug.php?id=14473

Since the same bug related to SHOW TABLES has been fixes I expect the fixing of this bug
also:
http://bugs.mysql.com/bug.php?id=12808

@Sergei Golubchik:
Please don't forget: 
1. Jim Winstead confirmed this bug.
2. SHOW TABLES is sorted.
3. The unsorted SHOW OPEN TABLES has been fixed to a sorted result.
4. SHOW DATABASES is sorted (without information_schema)

... seems the only reason you think this is not a bug is that you don't want to fix this
bug.

Indeed it's faster to say "It's not a bug" than fixing a bug. But this is not the way
make a program better.

Ok, if you still think this is not a bug - I report an other one:

SHOW TABLES
SHOW OPEN TABLES
SHOW DATABASES 
sorts the result before sending to the client. This uses unneeded server resources and
slow down the speeding of the return.

Please fix this bug instead of the resorted.

How to repeat:
http://bugs.mysql.com/bug.php?id=14473
http://bugs.mysql.com/bug.php?id=12808

SHOW TABLES;
SHOW OPEN TABLES;
SHOW DATABASES;

Ok, sorry. Looks like SHOW DATABASES indeed sorts the output...

The developers are not interessed about our bug messages.

This should be simple to fix once the patch for Bug #12808 is pushed.

Jim, would you like to review Bug#12808?