458970 - Sorting by OS produces bad ordering with Mac OS X versions

Status: RESOLVED WORKSFORME

(Socorro :: Webapp, task)

Description

[Smokey Ardisson (offline for a while; not following bugs - do not email)]

STR:

1. Load URL
2. Sort by OS in descending order

ER: 10.5.5, 10.5.4, 10.5.3…10.5.0, 10.4.11, 10.4.10, 10.4.9…10.4.0
AR: 10.5.5, 10.5.4, 10.5.3…10.5.0, 10.4.9…10.4.2, 10.4.11, 10.4.10, 10.4.0 (there are currently no 10.4.1 reports)

I have no idea what version of Socorro crash-stats.m.c is currently running; choosing "Trunk"

Comment 1

[(not currently active) Ted Mielczarek]

This is kind of sucky. I think in the database we actually have two fields, "OS" and "OS Version". We could split those into two columns in the report, but sorting on "OS Version" would still probably show this. Unfortunately that's not a well-defined field, it's just text, so defining the sorting on it is hard.

Comment 2

[(not currently active) Ted Mielczarek]

I don't know that there's a good way to fix this, since the "OS" and "OS Version" fields are both arbitrary text. I guess we could match templates for specific OSes and pull the data into a more usable form in the db.

Comment 3

[Schalk Neethling [:espressive]]

I believe this is no longer a problem. Heading to https://crash-stats.mozilla.com/report/list?product=Firefox&platform=mac&query_search=signature&query_type=contains&reason_type=contains&date=03%2F25%2F2012%2021%3A13%3A08&range_value=1&range_unit=weeks&hang_type=any&process_type=any&do_query=1&signature=strlen%20|%20Flash%20Player%400x2e7bc4 and sorted the Mac OS either asc or desc works as expected.

Closing as works for me, feel free to reopen if I am wrong it is still not fixed.