MySQL Bugs: #15059: Sorting is not working right

Bug #15059	Sorting is not working right
Submitted:	18 Nov 2005 22:08	Modified:	27 Jul 2006 12:03
Reporter:	Chang-Ping Hsiao	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.1.5	OS:	Windows (Windows XP SP2)
Assigned to:	Mike Lischke	CPU Architecture:	Any
Tags:	Catalog

Description:
The sorting function in Catalogs --> Schemata --> Schema Tables, clicking on "Data length" and "Index length" does not work.

How to repeat:
1. Open MySQL Administrator
2. Click and select "Catalogs" in the upper left panel
3. Select a schema in Schemata in the lower left panel
4. Select "Schema Tables" tab in the right panel
5. Click on either "Data length" or "Index length" header
6. the sorting is inaccurate in my case.  See attached screen shots.

Suggested fix:
Check to see if the sort function has size limit.

Sort data length ascendingly

Attachment: data_ascend.gif (image/gif, text), 84.01 KiB.

Sort data length descendingly

Attachment: data_descend.gif (image/gif, text), 84.09 KiB.

Sort index length ascendingly

Attachment: index_ascend.gif (image/gif, text), 83.90 KiB.

Sort index length descendingly

Attachment: index_descend.gif (image/gif, text), 83.90 KiB.

Thanks for your bug report.  I was able to reproduce this bug using 1.1.5

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://www.mysql.com/doc/en/Installing_source_tree.html