Red Hat Bugzilla – Bug 613846
error in sorting a column of dates
Last modified: 2013-06-17 20:02:39 EDT
Description of problem: Sorting the Updated column (calendar dates) of Fedora 14 Accepted Features gives a list which is not sorted correctly.
Version-Release number of selected component (if applicable):
last modified on 12 July 2010, at 14:01
How reproducible: every time
Steps to Reproduce:
2.Sort the Updated column by clicking on the icon in the header of that column.
Actual results: The two items with the most recent dates (in this case 2010-07-12 and 2010-07-11) are not in the correct order.
Expected results: The items are sorted correctly.
Additional info: See sceenshot attached.
Created attachment 431300 [details]
screenshot showing bad sort of calendar dates
There was an extra space in the wiki page which was causing this inconsistency.
It should be fixed now.
Yes, now the displayed order is correct. However, there is some doubt whether the fix is robust. If only the data was changed (extra space character removed) then that is not a good enough fix, because the problem will reappear when the next date is entered with an extra space. Instead, the software must be changed either to parse the entry the sort as a binary value, or at a minimum to strip all whitespace characters before sorting as a character string (taking advantage of the feature of ISO 8601 format for representation of a date, where order as a character-string is isomorphic to order as a date.)
The current accepted features page at http://fedoraproject.org/wiki/Releases/19/FeatureList looks like it is sorting properly; John, are you satisfied with the current behavior, or should we keep this open?
Yes, the "Updated" column for Fedora 19 Feature List sorts correctly. Satisfied.
Thanks, looks like the wiki no longer has this issue.