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

Bug #14591	SHOW DATABASES does not order infomation_schema correct
Submitted:	2 Nov 2005 21:17	Modified:	14 Mar 2006 8:59
Reporter:	Bugs System	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0.15/BK source 5.0	OS:	Windows (Windows XP/Linux)
Assigned to:	Assigned Account	CPU Architecture:	Any

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?