Hadn't noticed this before or only happens with nlwiki. This query returns
wd:q2120834
wd:q1838936
instead of
wd:Q2120834
wd:Q1838936
Other results seem fine.
Hadn't noticed this before or only happens with nlwiki. This query returns
wd:q2120834
wd:q1838936
instead of
wd:Q2120834
wd:Q1838936
Other results seem fine.
Subject | Repo | Branch | Lines +/- | |
---|---|---|---|---|
Uppercase item ids received from services. | wikidata/query/rdf | master | +8 -2 |
Status | Subtype | Assigned | Task | ||
---|---|---|---|---|---|
Resolved | Smalyshev | T172642 Lowercase QIDs returned by wikibase:mwapi | |||
Resolved | Addshore | T172748 Clean up lowercase q-IDs from page_props table |
This is weird. I suspect it's how it is stored in the DB (maybe some buggy bot or extension?) but will check on Monday.
Looking at it closer, I also found some on eswiki:
wd:q11704619
wd:q5884721
Still, it's fairly rare.
mysql:wikiadmin@db1090 [nlwiki]> select * from page_props where pp_page = '1572528'; +---------+---------------+----------+------------+ | pp_page | pp_propname | pp_value | pp_sortkey | +---------+---------------+----------+------------+ | 1572528 | wikibase_item | q2120834 | NULL | +---------+---------------+----------+------------+
Looks like it's a database issue. I'll try to figure out where it comes from.
Looks like this diff: https://nl.wikipedia.org/w/index.php?title=Coupe_Manier&diff=36039023&oldid=15798333
has it lowercase:
Robot: Verplaatsing van 1 interwikilinks. Deze staan nu op Wikidata onder d:q2120834)
Maybe the code of Addbot needs to be checked.
I think Addbot just read the same table as you.
Maybe it's just a really old entry: The edit for nl at Wikidata is from 2012.
Maybe it's an old issue and we should just clean up the tables? I'd like a word from @Addshore on this though to be sure.
A couple of hundreds or none for a few other wikis.
At least that explains it why I noticed it for nlwiki.
Maybe just a lot of pages that haven't been edited recently.
OK, looks like there are several issues at play here:
Change 370593 had a related patch set uploaded (by Smalyshev; owner: Smalyshev):
[wikidata/query/rdf@master] Uppercase item ids received from services.
Change 370593 merged by jenkins-bot:
[wikidata/query/rdf@master] Uppercase item ids received from services.