[Wikidata-bugs] [Maniphest] T306783: Combining English dialects in SPARQL FILTER bug or feature?

2022-04-25 Thread Andrawaag
Andrawaag created this task. Andrawaag added projects: Wikidata, Wikidata-Query-Service. Restricted Application added a subscriber: Aklapper. TASK DESCRIPTION When running the following DISTINCT query (https://w.wiki/56NX) the results does contain 3 seemingly identical records. When run outside

[Wikidata-bugs] [Maniphest] T306783: Combining English dialects in SPARQL FILTER bug or feature?

2022-04-25 Thread Lucas_Werkmeister_WMDE
Lucas_Werkmeister_WMDE added a comment. You can also see the difference in the query service UI if you hover over the string: F35066919: image.png I don’t really understand what the issue here is… the query uses `FILTER(LANGMATCHES(LANG(

[Wikidata-bugs] [Maniphest] T306783: Combining English dialects in SPARQL FILTER bug or feature?

2022-04-25 Thread Andrawaag
Andrawaag closed this task as "Resolved". Andrawaag claimed this task. Andrawaag added a comment. Perfect, thanks @Lucas_Werkmeister_WMDE. I agree it is a feature. TASK DETAIL https://phabricator.wikimedia.org/T306783 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emai

[Wikidata-bugs] [Maniphest] T306783: Combining English dialects in SPARQL FILTER bug or feature?

2022-04-26 Thread joshmoore
joshmoore added a comment. Thanks, Lucas. Appreciate the feedback as the original instigator. 😃 This may be getting into a data model question but this leaves me to wonder that if there a chance that there would be no `en` but several `en_*` entries, what would be the appropriate filter for

[Wikidata-bugs] [Maniphest] T306783: Combining English dialects in SPARQL FILTER bug or feature?

2022-04-26 Thread Lucas_Werkmeister_WMDE
Lucas_Werkmeister_WMDE added a comment. Something like `LIMIT 1`, or `GROUP BY` + `SAMPLE(?label)`, I guess. TASK DETAIL https://phabricator.wikimedia.org/T306783 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Andrawaag, Lucas_Werkmeister_WMDE Cc

[Wikidata-bugs] [Maniphest] T306783: Combining English dialects in SPARQL FILTER bug or feature?

2022-04-26 Thread joshmoore
joshmoore added a comment. Thanks again, Lucas. Simplifying the original a bit: SELECT DISTINCT ?city (SAMPLE(?name) as ?name) WHERE { ?city wdt:P31/wdt:P279* wd:Q387917 . # wd:Q515 . ?city rdfs:label ?label . FILTER(LANGMATCHES(LANG(?label), "en")) BIND(