diff options
| author | Brad Jorsch <bjorsch@wikimedia.org> | 2013-01-10 19:22:03 -0500 |
|---|---|---|
| committer | Brad Jorsch <bjorsch@wikimedia.org> | 2013-04-03 13:22:20 -0400 |
| commit | c013ec02b9219941b29030ae6ff9f7052df646ef (patch) | |
| tree | 53ac79f08b97d8a7c282e19864fe2f367da0ca5b /maintenance/postgres/archives/patch-rename-iwl_prefix.sql | |
| parent | cdb562b09e654d1b06474a7d7c39d8f239b719ea (diff) | |
| download | mediawikicore-c013ec02b9219941b29030ae6ff9f7052df646ef.tar.gz mediawikicore-c013ec02b9219941b29030ae6ff9f7052df646ef.zip | |
(bug 36400) API: Fix sorting for iwlinks, langlinks
The iwlinks and langlinks modules continue parameters imply ordering by
page then prefix then title. But in certain modes, the actual queries
use a different ordering, which may result in skipped or repeated
results.
This changeset fixes that. To do so, it needs to re-add an index
iwl_prefix_from_title which was mistakenly removed in 2010 (r69721). And
while it's doing that, it cleans up errors in the sqlite and postgresql
handling of the iwlinks indexes too.
Also, per Asher, make the iwl_prefix_from_title and
iwl_prefix_title_from indexes non-UNIQUE.
Change-Id: I607e8bf9183a2d8152a6127a81c83a0b5bba0c61
Diffstat (limited to 'maintenance/postgres/archives/patch-rename-iwl_prefix.sql')
| -rw-r--r-- | maintenance/postgres/archives/patch-rename-iwl_prefix.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/maintenance/postgres/archives/patch-rename-iwl_prefix.sql b/maintenance/postgres/archives/patch-rename-iwl_prefix.sql index a4bdb6a91345..0eb792eae2f9 100644 --- a/maintenance/postgres/archives/patch-rename-iwl_prefix.sql +++ b/maintenance/postgres/archives/patch-rename-iwl_prefix.sql @@ -1,2 +1,2 @@ DROP INDEX iwl_prefix; -CREATE UNIQUE INDEX iwl_prefix_title_from ON iwlinks (iwl_prefix, iwl_from, iwl_title); +CREATE UNIQUE INDEX iwl_prefix_title_from ON iwlinks (iwl_prefix, iwl_title, iwl_from); |