Bug #14665 Sort is wrong in Schema Tables

• Submitted: 5 Nov 2005 0:16
• Modified: 5 Nov 2005 3:49
• Reporter: Chang-Ping Hsiao
• Status: Can't repeat
• Category: MySQL Administrator
• Severity: S3 (Non-critical)
• Version: 1.1.4
• OS: Windows (Windows XP)
• Assigned to: MySQL Verification Team
• CPU Architecture: Any

[5 Nov 2005 0:16] Chang-Ping Hsiao

Description:
The Data length and Index length column can be sorted, but they are sorted by some random order.

For example, one of my schema has the following tables sizes, and they are sorted in the following order.

Data length
-----------------
751.4 MB
151.6 MB
9.7 MB
0.8 MB
525.8 kB
216.6 kB
2.1 kB
0 B
15.1 GB
6.8 GB
1.4 GB

Index length
-----------------
425.1 MB
191.8 MB
3.6 MB
193 kB
143 kB
32 kB
3 kB
1 kB
14.9 GB
7.4 GB
2.2 GB

How to repeat:
Open MySQL Administrator
Connect to a database
Select Catalogs in the upper left panel
Select a schema in the bottom left panel
Click on the title of Data length of Index length to sort the columns

[5 Nov 2005 0:18] Chang-Ping Hsiao

screen shot for Data length sort

Attachment: data_length.gif (image/gif, text), 87.79 KiB.

[5 Nov 2005 0:19] Chang-Ping Hsiao

Index length sorting

Attachment: index_length.gif (image/gif, text), 87.71 KiB.

[5 Nov 2005 3:49] MySQL Verification Team

I was unable to repeat the behavior reported on XP SP2 and server
5.1.5. Most probably there is something different between our
environments which makes that behavior to happen on your side.