https://bugzilla.wikimedia.org/show_bug.cgi?id=164
Huji huji.h...@gmail.com changed:
What|Removed |Added
CC||reza.ene...@gmail.com
---
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
Brion Vibber br...@wikimedia.org changed:
What|Removed |Added
Blocks|29788 |
--
Configure
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
Philippe Verdy verd...@wanadoo.fr changed:
What|Removed |Added
Status|RESOLVED|REOPENED
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
Phillip Patriakeas dragonlordofxant...@gmail.com changed:
What|Removed |Added
CC|
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
Siebrand s.mazel...@xs4all.nl changed:
What|Removed |Added
Status|REOPENED|RESOLVED
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
Mark A. Hershberger m...@everybody.org changed:
What|Removed |Added
Status|REOPENED|RESOLVED
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #231 from Bawolff bawolff...@gmail.com 2011-08-28 23:35:55 UTC ---
Re JS sortable table stuff (this bug is about too many things...): Well client
side js sorting stuff would be nice, since these tables aren't dynamic,
wouldn't it be
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #232 from Philippe Verdy verd...@wanadoo.fr 2011-08-29 01:29:45
UTC ---
If table contents are static, it's true that their collation weights could be
delivered as well with the visible table.
In a past message above, I had already
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #229 from Andrew Dunbar hippytr...@gmail.com 2011-08-27 10:03:28
UTC ---
@Philippe Verdy: I think work on the bigger Unicode problems for JavaScript is
pretty important. I tried to file a bug or feature request somewhere a couple
of
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #230 from Philippe Verdy verd...@wanadoo.fr 2011-08-27 11:06:18
UTC ---
Until recently, it was too slow to initialize a large table like the DUCET. But
now that Javascript starts being used for 2D/3D rendering with interactive
speed,
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #228 from Philippe Verdy verd...@wanadoo.fr 2011-08-26 21:49:23
UTC ---
I am currently working on a Javascript implementation of UCA (i.e. with full
support of the DUCET, at least 4 collation levels, and support for
language-based
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #227 from Purodha Blissenbach
bugzilla.wikime...@publi.purodha.net 2011-08-25 16:02:59 UTC ---
(In reply to comment #224)
Don't forget sortable table sorting.
Sortable tables are sorted client-side. This might offer additional
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
Brion Vibber br...@wikimedia.org changed:
What|Removed |Added
Status|RESOLVED|REOPENED
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
Brion Vibber br...@wikimedia.org changed:
What|Removed |Added
Blocks||29788
--
Configure
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
Siebrand s.mazel...@xs4all.nl changed:
What|Removed |Added
CC||s.mazel...@xs4all.nl
---
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
Bawolff bawolff...@gmail.com changed:
What|Removed |Added
CC||bawolff...@gmail.com
---
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #218 from Philippe Verdy verd...@wanadoo.fr 2011-07-20 08:54:53
UTC ---
OK, I immediately found a bug in the binary search function (which is defintely
not beinary, has slower than expected convergence, and may even stale on
testing
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #219 from Philippe Verdy verd...@wanadoo.fr 2011-07-20 11:20:08
UTC ---
I note the following comment in r80443:
* Changed Title::getCategorySortkey() to separate its parts with a line break
instead of a null character. All collations
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #220 from Tim Starling tstarl...@wikimedia.org 2011-07-20
12:14:54 UTC ---
(In reply to comment #218)
if ( $comparison 0 ) {
$min = $mid + 1;
} elseif ( $comparison 0 ) {
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
Domas Mituzas domas.mitu...@gmail.com changed:
What|Removed |Added
CC|
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #222 from Philippe Verdy verd...@wanadoo.fr 2011-07-20 13:18:31
UTC ---
You should know that a binary search for equality of for lower bound is
completely the same algorithm. (If not convined, look at the source of a C++
standard
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #223 from Philippe Verdy verd...@wanadoo.fr 2011-07-20 13:35:21
UTC ---
The function is not a classical binary search, which only determines equality,
instead it finds the lower bound of a range. When the test item sorts below the
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #217 from Aryeh Gregor simetrical+wikib...@gmail.com 2011-07-18
18:25:02 UTC ---
The interesting code is here:
http://svn.wikimedia.org/viewvc/mediawiki/trunk/phase3/includes/Collation.php?view=markup
That's the part that does the
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #215 from Aryeh Gregor simetrical+wikib...@gmail.com 2011-07-17
14:12:58 UTC ---
Maybe. It depends. Given the number of comments here and the number of people
being spammed on every post here, though, I'd strongly suggest that
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #216 from Philippe Verdy verd...@wanadoo.fr 2011-07-17 16:50:16
UTC ---
Aryeh, Can you point me with a link where your implementation was added in MW ?
I'd like to review it, and locate possible bugs or caveats.
Also because the
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #214 from Niklas Laxström niklas.laxst...@gmail.com 2011-07-16
11:51:15 UTC ---
There are lots of places where pages are listed - don't they also require or
benefit form such index?
--
Configure bugmail:
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
Lejonel lejo...@telia.com changed:
What|Removed |Added
CC||lejo...@telia.com
---
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #213 from Aryeh Gregor simetrical+wikib...@gmail.com 2011-07-15
20:12:10 UTC ---
Getting sorting working in other places would require work, but we could use
the same infrastructure. For Special:Allpages, we'd need to add an extra
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
Mark A. Hershberger m...@everybody.org changed:
What|Removed |Added
Status|ASSIGNED|RESOLVED
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
Roan Kattouw roan.katt...@gmail.com changed:
What|Removed |Added
CC|
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
Chad H. innocentkil...@gmail.com changed:
What|Removed |Added
CC|
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #205 from Philippe Verdy verd...@wanadoo.fr 2010-08-04 17:09:44
UTC ---
(In reply to comment #204)
If people want to put crazy stuff in sortkeys that changes based on who's
viewing it, we can't stop them. Curly braces are
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #206 from Aryeh Gregor simetrical+wikib...@gmail.com 2010-08-04
17:14:25 UTC ---
(In reply to comment #205)
That's because the Mediawiki parser still operates on the wrong level, and
performs text subtitutions always without
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #207 from Philippe Verdy verd...@wanadoo.fr 2010-08-04 17:41:52
UTC ---
In reply to comment #206)
Top-down analyzers are very easy to write, provided that you allow parsing to
be made via TWO generation points, instead of one: the
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #204 from Aryeh Gregor simetrical+wikib...@gmail.com 2010-08-03
17:37:45 UTC ---
(In reply to comment #200)
Which SQL backends (and dialects) do you support in MediaWiki ? This may help
me understanding some development
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #202 from Philippe Verdy verd...@wanadoo.fr 2010-07-28 22:06:54
UTC ---
I would suggest instead making those proposals in the CLDR project.
It already contains lots of data for many languages, related to their expected
sort order (in
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #203 from Philippe Verdy verd...@wanadoo.fr 2010-07-28 22:18:49
UTC ---
May I even suggest that the name of the new column does not even use sortkey
i.e. cl_sort_prefix instead of cl_sortkey_prefix
Why? because this column should
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #190 from Philippe Verdy verd...@wanadoo.fr 2010-07-26 18:38:10
UTC ---
Yes Language::firstLetterforList(s) maps more or less to COLLATIONMAP, but
COLLATIONMAP is a more generic concept which reflects what is defined in
Unicode
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #191 from Philippe Verdy verd...@wanadoo.fr 2010-07-26 19:07:34
UTC ---
In all this discussion it appears that the development can be made in two
separate projects developped independantly.
You can continue to develop the SQL schema
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #192 from Philippe Verdy verd...@wanadoo.fr 2010-07-26 19:20:35
UTC ---
Note that this is the minimum functional interface for the Collator class.
Other methods will be certianly needed to cache the already prepared collators,
or to
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #193 from Philippe Verdy verd...@wanadoo.fr 2010-07-26 19:41:57
UTC ---
Exemple of interface for you:
?php
require('.../CollatorFactory.php');
$wgCollatorFactory=CollatorFactory(); // this is the only global PHP variable
...
//
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #194 from Aryeh Gregor simetrical+wikib...@gmail.com 2010-07-26
19:49:15 UTC ---
(In reply to comment #190)
Yes Language::firstLetterforList(s) maps more or less to COLLATIONMAP, but
COLLATIONMAP is a more generic concept which
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #195 from Aryeh Gregor simetrical+wikib...@gmail.com 2010-07-26
19:50:19 UTC ---
By the way, I'm keeping track of progress here:
http://www.mediawiki.org/wiki/User:Simetrical/Collation
--
Configure bugmail:
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #196 from Philippe Verdy verd...@wanadoo.fr 2010-07-26 20:37:46
UTC ---
Note that the CollatorFactory may fail to locate the specified locale for which
a collator is being requested. Additionally, several locales may share exactly
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #197 from Philippe Verdy verd...@wanadoo.fr 2010-07-26 21:01:11
UTC ---
I note that you have started to define the Collator class as the Language
class.
Well I'm not sure that this should be the same class: a language has several
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #198 from Aryeh Gregor simetrical+wikib...@gmail.com 2010-07-26
21:43:21 UTC ---
(In reply to comment #187)
Drop this tacking immediately in the PHP code: the cl_sortkey is only intended
to store the clear-text sortkey hint
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #199 from Philippe Verdy verd...@wanadoo.fr 2010-07-26 22:23:47
UTC ---
(Note also that section headings (first letter) will have to be
translated
to correctly report the first letter of the Pinyin romanization, because
the
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #200 from Philippe Verdy verd...@wanadoo.fr 2010-07-26 22:44:37
UTC ---
Note that if your collator stub does not really compute true sort keys
(compacted in binary format and representing collation weights), it may return
spaces
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #201 from V85 v85.wikipe...@gmail.com 2010-07-26 23:02:33 UTC ---
For those of us who are less technical, but keen to see this bug resolved, is
there somewhere where we can submit alphabets, so that they may be added for
collation?
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #189 from Aryeh Gregor simetrical+wikib...@gmail.com 2010-07-25
17:22:32 UTC ---
(In reply to comment #186)
That'a a bad assumption : even the highest quality collations will need to be
updated from time to time:
- Unicode evolves
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #187 from Philippe Verdy verd...@wanadoo.fr 2010-07-24 06:17:18
UTC ---
(In reply to comment #185)
Oh, I didn't get what he was saying. Yes, obviously we should use the actual
cl_from field, not tack it onto cl_sortkey (is that
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #188 from Philippe Verdy verd...@wanadoo.fr 2010-07-24 07:00:47
UTC ---
(In reply to comment #183)
Okay, look, if you make posts this long I'm not going to be able to read
them.
You have to state your points briefly and clearly,
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #186 from Philippe Verdy verd...@wanadoo.fr 2010-07-24 05:53:30
UTC ---
(In reply to comment #183)
Upgrading the collation can be done in-place. The worst case is that
categories sort weirdly for a few hours. Also, we would only
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #172 from Philippe Verdy verd...@wanadoo.fr 2010-07-22 06:00:34
UTC ---
But if the SQL engine does not have such support, this must be implemented in
the PHP code and collation keys can be stored in a new datacolumn (the extra
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #173 from Roan Kattouw roan.katt...@gmail.com 2010-07-22 07:15:01
UTC ---
(In reply to comment #172)
And this was false. Because you assume that the generation of sort keys has to
be done on database queries for listing the content
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #174 from Philippe Verdy verd...@wanadoo.fr 2010-07-22 09:13:30
UTC ---
If we're gonna discuss anything, let's
discuss the current implementation plan: it is the only relevant plan to
discuss at this point.
This is EXACTLY what I
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #175 from Roan Kattouw roan.katt...@gmail.com 2010-07-22 09:59:32
UTC ---
(In reply to comment #174)
If we're gonna discuss anything, let's
discuss the current implementation plan: it is the only relevant plan to
discuss at this
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #176 from Philippe Verdy verd...@wanadoo.fr 2010-07-22 10:04:53
UTC ---
Anyway, the Aryeh's proposal is not found or documented at the location you
indicate. It just says that he will try to work on it today and still asks for
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #177 from Roan Kattouw roan.katt...@gmail.com 2010-07-22 10:17:54
UTC ---
(In reply to comment #176)
Anyway, the Aryeh's proposal is not found or documented at the location you
indicate. It just says that he will try to work on it
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #178 from Philippe Verdy verd...@wanadoo.fr 2010-07-22 10:48:39
UTC ---
Because his specification is really incomplete, and he said that Bug#164 was
useless (despite of the fact that I had described my solution extensively in
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #179 from Roan Kattouw roan.katt...@gmail.com 2010-07-22 11:16:18
UTC ---
(In reply to comment #178)
All this is something that can be avoided completely by using ICU and not
depending on SQL backends for their support of many more
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #180 from Philippe Verdy verd...@wanadoo.fr 2010-07-22 11:42:55
UTC ---
Your issue ***IS*** addressed in my proposal:
*Both* {{COLLATIONMAP:Áa}} and {{COLLATIONMAP:Aa}} will be unambiguously aa
in the primary collation level for
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #182 from Philippe Verdy verd...@wanadoo.fr 2010-07-22 13:18:28
UTC ---
Note that my developement plan will NOT imply an immmediate change of the SQL
schema. At first, if only working on the frist 2 steps, no schema change is
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #183 from Aryeh Gregor simetrical+wikib...@gmail.com 2010-07-22
17:57:42 UTC ---
Okay, look, if you make posts this long I'm not going to be able to read them.
You have to state your points briefly and clearly, or else I'm just not
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #184 from Roan Kattouw roan.katt...@gmail.com 2010-07-22 18:40:19
UTC ---
(In reply to comment #183)
It is not needless. We need a unique key to sort by, or else paging doesn't
work if many pages have the same sort key (e.g., if
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #185 from Aryeh Gregor simetrical+wikib...@gmail.com 2010-07-22
18:47:23 UTC ---
Oh, I didn't get what he was saying. Yes, obviously we should use the actual
cl_from field, not tack it onto cl_sortkey (is that what we do these
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
Tim Starling tstarl...@wikimedia.org changed:
What|Removed |Added
CC|
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
Liangent liang...@gmail.com changed:
What|Removed |Added
CC||liang...@gmail.com
---
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #168 from Aryeh Gregor simetrical+wikib...@gmail.com 2010-03-14
16:26:48 UTC ---
Changing cl_sortkey to utf8 *is* a solution. It needs a sysadmin to do it on
Wikimedia (if we want to do it), and we'd probably also want some core
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #161 from Aryeh Gregor simetrical+wikib...@gmail.com 2010-03-12
17:12:17 UTC ---
utf8 support in MySQL supports a number of common languages, including Danish,
Swedish, French, Hungarian, and Estonian:
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #162 from Huji huji.h...@gmail.com 2010-03-12 17:48:42 UTC ---
(In reply to comment #160)
Actually, I think the issues you raised with collations and languages has
nothing to do with MediaWiki; if anything, MySQL is to be blamed. All
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #163 from T. Gries m...@tgries.de 2010-03-12 21:47:56 UTC ---
(In reply to comments #159 and #160)
While the suggested patch clearly dramatically improves the page title
sorting,
it doesn't make it 100% correct for all European
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #164 from Aryeh Gregor simetrical+wikib...@gmail.com 2010-03-12
22:06:57 UTC ---
(In reply to comment #163)
Thanks for pointing out. I must admit, that you are _fully_ right, also
knowing
of the collation differences. We
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #165 from T. Gries m...@tgries.de 2010-03-12 22:18:10 UTC ---
(In reply to comment #164)
(In reply to comment #163)
The options I know of are:
1) Use MySQL collation support, just using utf8 everywhere. This will mess up
equality
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #166 from Aryeh Gregor simetrical+wikib...@gmail.com 2010-03-12
22:30:03 UTC ---
This shouldn't be an extension, we may as well have a page_sortkey added in
core. Makes more sense there. However, categories are lower-hanging fruit,
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #167 from T. Gries m...@tgries.de 2010-03-12 22:38:48 UTC ---
(In reply to comment #166)
This shouldn't be an extension, we may as well have a page_sortkey added in
core. Makes more sense there. However, categories are
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #160 from Stu Derby stude...@yahoo.com 2010-03-12 01:32:28 UTC ---
Re: comment 159
While the suggested patch clearly dramatically improves the page title sorting,
it doesn't make it 100% correct for all European languages though it
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
T. Gries m...@tgries.de changed:
What|Removed |Added
CC||m...@tgries.de
--- Comment
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
Le Chat cat...@vp.pl changed:
What|Removed |Added
Status|ASSIGNED|NEW
--- Comment #158 from Le Chat
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
Le Chat cat...@vp.pl changed:
What|Removed |Added
AssignedTo|philip@gmail.com|wikibug...@lists.wikimedia.
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
Chris chriskwonle...@msn.com changed:
What|Removed |Added
CC||chriskwonle...@msn.com
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #156 from Andrew Dunbar hippytr...@gmail.com 2009-11-27 21:50:21
UTC ---
Apparently non-BMP UTF-8 was in MySQL 6.0 which was around as alpha for a while
and whose features are all due to be added into upcoming 5.X versions:
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #155 from Andrew Dunbar hippytr...@gmail.com 2009-11-27 02:07:39
UTC ---
Here is another related MySQL bug to watch:
http://bugs.mysql.com/bug.php?id=25666
--
Configure bugmail:
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #154 from Philippe Verdy verd...@wanadoo.fr 2009-11-25 23:06:01
UTC ---
That's another good resson why collation should be supported directly within
the MediaWiki software, which already depends completely of PHP, so that it
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
Anthony bugzi...@inbox.org changed:
What|Removed |Added
CC||bugzi...@inbox.org
---
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #153 from Andrew Dunbar hippytr...@gmail.com 2009-11-25 07:57:50
UTC ---
MySQL can do the collation that Anthony mentions for PostgreSQL above in #152
and much more besides.
PostgreSQL has all the problems and more of MySQL
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #149 from Andrew Dunbar hippytr...@gmail.com 2009-11-20 11:05:53
UTC ---
I've added some feedback on the MySQL bug. I urge anyone here who cares about
this bug to also pay attention to that bug. Perhaps by working on their code,
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #150 from Peter Gervai (grin) g...@grin.hu 2009-11-20 15:09:45
UTC ---
Well I didn't want to chime in (you seem to be able to shout at each others
without my assistance :-)) but please do not forget that the solution for
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #151 from Philippe Verdy verd...@wanadoo.fr 2009-11-20 15:43:56
UTC ---
Anyway, the backend compatibility layer that maps the SQL into the SQL dialect
spoken by the SQL engine can still adapt itself : if there's a true support
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #131 from Andrew Dunbar hippytr...@gmail.com 2009-11-19 08:11:38
UTC ---
Well, there are people who know the architecture and the programming language
and can presumably do this very quickly (at least the basic step)
Why do
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #132 from Philip Tzou philip@gmail.com 2009-11-19 08:27:39
UTC ---
I'm busy with my study and I can't help this until I have passed my exam next
year January. I'm sorry to make your guys unhappy, though Chinese Wikipedia
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #133 from Le Chat cat...@vp.pl 2009-11-19 12:53:22 UTC ---
We seem to be overcomplicating things now. Of course category sort keys and
binary collation keys are different beasts. We just need a couple of stub
functions (we - or
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #138 from Le Chat cat...@vp.pl 2009-11-19 15:27:02 UTC ---
If you sort this stuff in PHP, you need to grab the entire list before you can
reliably sort it. Doing that for [[Category:Living people]] has no chance of
staying within
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #139 from Philippe Verdy verd...@wanadoo.fr 2009-11-19 15:51:05
UTC ---
#88,#100,#101 Does UCA explicitly specify the binary representation of the
generated
key?
yes and no:
- Yes there's an interface to retrieve the computed
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #140 from Philippe Verdy verd...@wanadoo.fr 2009-11-19 15:59:48
UTC ---
#138: I fully agree. Using stored collation keys will remove the dependency
with the database support, and will also avoid the problem of downtime when
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #141 from Philippe Verdy verd...@wanadoo.fr 2009-11-19 16:09:07
UTC ---
#137 From Roan Kattouw 2009-11-19 14:17:38 UTC
(In reply to comment #134)
Tdoday, basically, the categories are sorted by [sort key, full page name].
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #142 from Roan Kattouw roan.katt...@gmail.com 2009-11-19
16:40:25 UTC ---
(In reply to comment #141)
The pageID was just added to make sure that the sort key was unique (actually
this is not a requirement),
It is a requirement
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #143 from Philippe Verdy verd...@wanadoo.fr 2009-11-19 17:58:47
UTC ---
(in reply to comment #142 from Roan)
The pageID was just added to make sure that the sort key was unique (actually
this is not a requirement),
It is a
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #144 from Philippe Verdy verd...@wanadoo.fr 2009-11-19 18:12:31
UTC ---
Note that in SQL, the ORDER BY clause needs NOT unique sort keys.
Not even for sort stability, because the SQL engine will ensure the sort
stability itself
https://bugzilla.wikimedia.org/show_bug.cgi?id=164
--- Comment #145 from Roan Kattouw roan.katt...@gmail.com 2009-11-19
22:13:25 UTC ---
(In reply to comment #144)
Some SQL engines (like Oracle, Sybase, Informix, but probably not all index
formats supported in various versions of MySQL)
1 - 100 of 142 matches
Mail list logo
