2009/8/11 Helder Geovane Gomes de Lima heldergeovane@gmail.com:
2009/8/10 Aryeh Gregor
We could break ties by appending the page title to custom sort keys, if this is a problem.
I think it would be good! =)
I don’t (at least not in the way it is expressed). If you want to use the page title as a tiebreaker, then add it as a new column to the index (before the page_id), not (as I read the original sentence) by appending the title to the sort key.
Otherwise, you’ll have to separate the sort key from the title with some control character under U+0020 (to ensure correct ordering of different-length sort keys – you need a separator which sorts before any valid character), which would be messy.
But still, I don’t see the point in doing that. You don’t want a page called “Aaa” to come after a page called “Abc” when you set their sortkeys both to the same value? Don’t do that then. Set the sortkey accordingly to what you want.
(OBTW, a different thing is that category paging is probably buggy in this tiebreaking aspect – even though the index is correctly defined to be unique, the page_id column is not included in the &from= paging parameter. But this bug will probably appear only in extreme cases, like 300 articles with an identical sortkey.)
-- [[cs:User:Mormegil | Petr Kadlec]]