On Mon, Aug 10, 2009 at 4:07 PM, Brion Vibber<brion(a)wikimedia.org> wrote: We could break ties by appending the page title to custom sort keys, if this is a problem.

2009/8/11 Helder Geovane Gomes de Lima <heldergeovane(a)gmail.com>om>: 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]]

On Tue, Aug 11, 2009 at 4:35 AM, Petr Kadlec<petr.kadlec(a)gmail.com> wrote: It will return slightly wrong results whenever two articles with the same sort key happen to hit a page boundary. It's not a huge deal, since sortkeys are usually fairly unique, but it shouldn't be hard to fix if cl_from is already part of the sortkey index -- which it is, on trunk, although I can't say for sure whether that matches the deployed version.