[Wikidata-bugs] [Maniphest] [Commented On] T197598: MWAPI query with LIMIT ignores MINUS

[Lucas_Werkmeister_WMDE]

Lucas_Werkmeister_WMDE added a comment.

I can still reproduce the bug with your suggested changes. This query returns 3500 results:

SELECT DISTINCT ?item WHERE {
  hint:Query hint:optimizer "None".
  SERVICE wikibase:mwapi {
    bd:serviceParam wikibase:api "Search";
                    wikibase:endpoint "www.wikidata.org";
                    mwapi:srsearch "zika haswbstatement:P31=Q13442814".
    ?title wikibase:apiOutput mwapi:title.
  }
  BIND(IRI(CONCAT(STR(wd:), ?title)) AS ?item)
  FILTER NOT EXISTS { ?item p:P921/ps:P921 wd:Q202864. }
}
LIMIT 10000

Without the LIMIT, only 6 results are returned.

(I also don’t understand why the FILTER NOT EXISTS should make a difference – the two parts share the ?item variable, and whether it’s bound or not within the MINUS / FILTER NOT EXISTS block shouldn’t matter as far as I can tell.)

TASK DETAIL

https://phabricator.wikimedia.org/T197598

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Lucas_Werkmeister_WMDE
Cc: Aklapper, Smalyshev, Lucas_Werkmeister_WMDE, Daniel_Mietchen, Lahi, Gq86, Darkminds3113, GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, Avner, Gehel, Jonas, FloNight, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs