[Wikidata-bugs] [Maniphest] [Commented On] T153108: Duplicated data in queries
Smalyshev added a comment. Workaround: add this to the query: hint:Query hint:analytic false .TASK DETAILhttps://phabricator.wikimedia.org/T153108EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Smalyshev, Aklapper, Tcp-ip, EBjune, mschwarzer, Avner, debt, Gehel, D3r1ck01, Jonas, FloNight, Xmlizer, Izno, jkroll, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, Mbch331, Jay8g, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T153108: Duplicated data in queries
Smalyshev added a comment. The standard says (https://www.w3.org/TR/sparql11-query/#propertypath-syntaxforms): Evaluation of a property path _expression_ can lead to duplicates because any variables introduced in the equivalent pattern are not part of the results and are not already used elsewhere. They are hidden by implicit projection of the results to just the variables given in the query. I suspect this is the reason for duplicate languages - path _expression_ wdt:P31/wdt:P279* arrives to the result by different path, which produces duplicates. However, not sure why DISTINCT hasn't eliminated them.TASK DETAILhttps://phabricator.wikimedia.org/T153108EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Smalyshev, Aklapper, Tcp-ip, EBjune, mschwarzer, Avner, debt, Gehel, D3r1ck01, Jonas, FloNight, Xmlizer, Izno, jkroll, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, Mbch331___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
