Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P8252
Fixing page_props wikibase_item lower case q on wikidata clients (manually)
Active
Public
Actions
Authored by
Addshore
on Mar 21 2019, 9:19 AM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
Wikidata
User-Addshore
Referenced Files
F28435348: raw.txt
Mar 21 2019, 9:19 AM
2019-03-21 09:19:07 (UTC+0)
Subscribers
None
-----------------test2wiki-------------------------
MariaDB [test2wiki]> select * from page_props where pp_propname = 'wikibase_item' and left(pp_value,1) = 'q';
+---------+---------------+----------+------------+
| pp_page | pp_propname | pp_value | pp_sortkey |
+---------+---------------+----------+------------+
| 6791 | wikibase_item | q684150 | NULL |
+---------+---------------+----------+------------+
1 row in set (0.00 sec)
MariaDB [test2wiki]> /*T172748*/ UPDATE page_props SET pp_value = "Q684150" WHERE pp_propname = "wikibase_item" AND pp_value = "q684150";
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [test2wiki]> select * from page_props where pp_propname = 'wikibase_item' and left(pp_value,1) = 'q';
Empty set (0.00 sec)
-------------------------------------------------- skiwiki -----------------------------
MariaDB [skwiki]> select * from page_props where pp_propname = 'wikibase_item' and left(pp_value,1) = 'q';
+---------+---------------+-----------+------------+
| pp_page | pp_propname | pp_value | pp_sortkey |
+---------+---------------+-----------+------------+
| 46670 | wikibase_item | q13361379 | NULL |
+---------+---------------+-----------+------------+
1 row in set (0.86 sec)
MariaDB [skwiki]> /*T172748*/ UPDATE page_props SET pp_value = "Q13361379" WHERE pp_propname = "wikibase_item" AND pp_value = "q13361379";
Query OK, 1 row affected (0.29 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [skwiki]> select * from page_props where pp_propname = 'wikibase_item' and left(pp_value,1) = 'q';
Empty set (0.49 sec)
--------------------------------scnwiki----------------------------------
MariaDB [scnwiki]> select * from page_props where pp_propname = 'wikibase_item' and left(pp_value,1) = 'q';
+---------+---------------+-----------+------------+
| pp_page | pp_propname | pp_value | pp_sortkey |
+---------+---------------+-----------+------------+
| 10511 | wikibase_item | q13198267 | NULL |
| 33279 | wikibase_item | q13196418 | NULL |
+---------+---------------+-----------+------------+
2 rows in set (0.09 sec)
MariaDB [scnwiki]>
MariaDB [scnwiki]> /*T172748*/ UPDATE page_props SET pp_value = "Q13198267" WHERE pp_propname = "wikibase_item" AND pp_value = "q13198267";
T pp_value = "Q13196418" WHERE pp_propname = "wQuery OK, 1 row affected (0.03 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [scnwiki]> /*T172748*/ UPDATE page_props SET pp_value = "Q13196418" WHERE pp_propname = "wikibase_item" AND pp_value = "q13196418";
Query OK, 1 row affected (0.04 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [scnwiki]> select * from page_props where pp_propname = 'wikibase_item' and left(pp_value,1) = 'q';
Empty set (0.06 sec)
-----------------------------kywiki---------------------------
MariaDB [kywiki]> select * from page_props where pp_propname = 'wikibase_item' and left(pp_value,1) = 'q';
+---------+---------------+-----------+------------+
| pp_page | pp_propname | pp_value | pp_sortkey |
+---------+---------------+-----------+------------+
| 6361 | wikibase_item | q10986896 | NULL |
+---------+---------------+-----------+------------+
1 row in set (0.25 sec)
MariaDB [kywiki]> /*T172748*/ UPDATE page_props SET pp_value = "Q10986896" WHERE pp_propname = "wikibase_item" AND pp_value = "q10986896";
Query OK, 1 row affected (0.09 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [kywiki]> select * from page_props where pp_propname = 'wikibase_item' and left(pp_value,1) = 'q';
Empty set (0.15 sec)
----------------------------hsbwiki----------------------
MariaDB [hsbwiki]> select * from page_props where pp_propname = 'wikibase_item' and left(pp_value,1) = 'q';
+---------+---------------+----------+------------+
| pp_page | pp_propname | pp_value | pp_sortkey |
+---------+---------------+----------+------------+
| 2864 | wikibase_item | q9726543 | NULL |
| 3155 | wikibase_item | q9725519 | NULL |
| 4404 | wikibase_item | q9725583 | NULL |
| 4829 | wikibase_item | q9727060 | NULL |
| 5947 | wikibase_item | q9726770 | NULL |
| 5948 | wikibase_item | q9726981 | NULL |
+---------+---------------+----------+------------+
6 rows in set (0.07 sec)
MariaDB [hsbwiki]>
MariaDB [hsbwiki]>
MariaDB [hsbwiki]> /*T172748*/ UPDATE page_props SET pp_value = "Q9726543" WHERE pp_propname = "wikibase_item" AND pp_value = "q9726543";
TE page_props SET pp_value = "Q9725519" WHERE pp_propname = "wikibQuery OK, 1 row affected (0.03 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [hsbwiki]> /*T172748*/ UPDATE page_props SET pp_value = "Q9725519" WHERE pp_propname = "wikibase_item" AND pp_value = "q9725519";
/*T172748*/ UPDATE page_props SET pp_value = "Q9725583" WHEQuery OK, 1 row affected (0.03 sec)
RE ppRows matched: 1 Changed: 1 Warnings: 0
MariaDB [hsbwiki]> /*T172748*/ UPDATE page_props SET pp_value = "Q9725583" WHERE pp_propname = "wikibase_item" AND pp_value = "q9725583";
*T172748*/ UPDATE page_props SET pp_value = "Q972706Query OK, 1 row affected (0.04 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [hsbwiki]> /*T172748*/ UPDATE page_props SET pp_value = "Q9727060" WHERE pp_propname = "wikibase_item" AND pp_value = "q9727060";
/*T172748*/ UPDATE page_props SET pQuery OK, 1 row affected (0.04 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [hsbwiki]> /*T172748*/ UPDATE page_props SET pp_value = "Q9726770" WHERE pp_propname = "wikibase_item" AND pp_value = "q9726770";
T172748*/ UPDATE page_props SET pp_value = "Q9726981" Query OK, 1 row affected (0.03 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [hsbwiki]> /*T172748*/ UPDATE page_props SET pp_value = "Q9726981" WHERE pp_propname = "wikibase_item" AND pp_value = "q9726981";
Query OK, 1 row affected (0.03 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [hsbwiki]>
MariaDB [hsbwiki]>
MariaDB [hsbwiki]> select * from page_props where pp_propname = 'wikibase_item' and left(pp_value,1) = 'q';
Empty set (0.04 sec)
----------------eowiki-----------------------
MariaDB [eowiki]> select * from page_props where pp_propname = 'wikibase_item' and left(pp_value,1) = 'q';
+---------+---------------+-----------+------------+
| pp_page | pp_propname | pp_value | pp_sortkey |
+---------+---------------+-----------+------------+
| 379855 | wikibase_item | q12345572 | NULL |
+---------+---------------+-----------+------------+
1 row in set (2.78 sec)
MariaDB [eowiki]> /*T172748*/ UPDATE page_props SET pp_value = "Q12345572" WHERE pp_propname = "wikibase_item" AND pp_value = "q12345572";
Query OK, 1 row affected (0.50 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [eowiki]> select * from page_props where pp_propname = 'wikibase_item' and left(pp_value,1) = 'q';
Empty set (0.73 sec)
-------------------------- bewiki ---------------------
MariaDB [bewiki]> select * from page_props where pp_propname = 'wikibase_item' and left(pp_value,1) = 'q';
+---------+---------------+-----------+------------+
| pp_page | pp_propname | pp_value | pp_sortkey |
+---------+---------------+-----------+------------+
| 60838 | wikibase_item | q13402496 | NULL |
+---------+---------------+-----------+------------+
1 row in set (0.92 sec)
MariaDB [bewiki]> /*T172748*/ UPDATE page_props SET pp_value = "Q13402496" WHERE pp_propname = "wikibase_item" AND pp_value = "q13402496";
Query OK, 1 row affected (0.34 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [bewiki]> select * from page_props where pp_propname = 'wikibase_item' and left(pp_value,1) = 'q';
Empty set (0.45 sec)
Event Timeline
Addshore
created this paste.
Mar 21 2019, 9:19 AM
2019-03-21 09:19:07 (UTC+0)
Addshore
mentioned this in
T172748: Clean up lowercase q-IDs from page_props table
.
Log In to Comment