MySQL Bugs: #25166: Sort bugs by version does string sort instead of numeric/version

Bug #25166	Sort bugs by version does string sort instead of numeric/version
Submitted:	19 Dec 2006 9:25	Modified:	19 Dec 2006 17:25
Reporter:	Nicola Worthington	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Websites: bugs.mysql.com	Severity:	S3 (Non-critical)
Version:	Current	OS:	Unknown
Assigned to:		CPU Architecture:	Any
Tags:	sort, version

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Sorting the bug list by the version column doesn't sort correctly. It appears to do a string sort instead of numeric or version sort.

How to repeat:
Sort bugs by version by clicking on the version column heading.

Suggested fix:
Sort by version like the Apache mod_autoindex version sort, or better.

Thank you for a problem report. Sorry, but that "Version" field is really a string, without any fixed format, like in your case: "Current". The only way to sort all values we have in Version is to sort them as strings. So, this is expected behaviour (and I do not have problems with it, sorting many times per day).