Author: markdayel
Description:
Sorting a table by date in Semantic Mediawiki svn (r65007) (on Mediawiki 1.16.0Beta2 svn r65007) does not produce correct date order. Reverting to prior Semantic Mediawiki svn (r63846) fixes the problem. (note: I'm sorting by a date propertly, and there are multiple date entries per page. r63846 handles this fine)
Version: unspecified
Severity: normal
I cannot reproduce this problem on our sites. Please have a look at http://sandbox.semantic-mediawiki.org/wiki/Property:Submission_deadline for an example query where one entry has two dates.
Of course, when you have more than one date per page, the page can still be sorted by only one of them. Which one this is is not defined by SMW or SQL, so you cannot expect a deterministic result in such cases. The page will appear in only one of the positions that its various dates indicate. This is why it is not suggested to sort by a property value that is set many times for single pages; but this is not specific to Type:Date.
Another possible reason for sorting problems in an upgrade is that some internal format change has occurred that was not applied yet to your DB. In this case, pages that are stored again should sort properly. Updating all pages can be effected by using the Repair button in Special:SMWAdmin.
I close this bug as WORKSFORME. Feel free to re-open if the problem persists. Please also provide a URL for the problem in this case (you can use the sandbox to reproduce it).