[Wikidata-bugs] [Maniphest] [Commented On] T172113: ConcurrentModificationException on non-grouping query with aggregates in SELECT
gerritbot added a comment. Change 533108 **merged** by Smalyshev: [wikidata/query/blazegraph@master] Fix Concurrent modification on non-grouping query with aggregates https://gerrit.wikimedia.org/r/533108 TASK DETAIL https://phabricator.wikimedia.org/T172113 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: gerritbot Cc: WikidataFacts, Esc3300, Aklapper, Smalyshev, Lucas_Werkmeister_WMDE, PokestarFan, Hook696, Daryl-TTMG, RomaAmorRoma, 0010318400, E.S.A-Sheild, darthmon_wmde, joker88john, ET4Eva, DannyS712, CucyNoiD, Nandana, NebulousIris, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Af420, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, EBjune, merbst, LawExplorer, WSH1906, Avner, Lewizho99, Maathavan, Gehel, _jensen, rosalieper, Cirdan, Jonas, FloNight, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331, Krenair ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T172113: ConcurrentModificationException on non-grouping query with aggregates in SELECT
gerritbot added a comment. Change 533108 had a related patch set uploaded (by Igor Kim; owner: Igor Kim): [wikidata/query/blazegraph@master] Fix Concurrent modification on non-grouping query with aggregates https://gerrit.wikimedia.org/r/533108 TASK DETAIL https://phabricator.wikimedia.org/T172113 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: gerritbot Cc: WikidataFacts, Esc3300, Aklapper, Smalyshev, Lucas_Werkmeister_WMDE, PokestarFan, darthmon_wmde, ET4Eva, DannyS712, Nandana, Lahi, Gq86, Darkminds3113, GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, Avner, Gehel, _jensen, rosalieper, Jonas, FloNight, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331, Krenair ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T172113: ConcurrentModificationException on non-grouping query with aggregates in SELECT
WikidataFacts added a comment. Note that this can also occur on grouping queries: SELECT ?x (COUNT(*) AS ?total) (SUM(?y) AS ?ys) (?ys/?total AS ?ratio) WHERE { ?x wdt:P31 wd:Q1. BIND(1 AS ?y) } GROUP BY ?x And an alternative workaround is to inline the variables into the SELECT, i. e. (SUM(?y)/COUNT(*) AS ?ratio). The advantage of this is that you can still use ?ratio in a HAVING clause on the grouping query (a FILTER in the outer query is less efficient).TASK DETAILhttps://phabricator.wikimedia.org/T172113EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: WikidataFactsCc: WikidataFacts, Esc3300, Aklapper, Smalyshev, Lucas_Werkmeister_WMDE, PokestarFan, GoranSMilovanovic, QZanden, EBjune, merbst, Avner, debt, Gehel, Jonas, FloNight, Xmlizer, Izno, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T172113: ConcurrentModificationException on non-grouping query with aggregates in SELECT
Esc3300 added a comment. If it's the same as on this, I think it broke on February 22.TASK DETAILhttps://phabricator.wikimedia.org/T172113EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Esc3300Cc: Esc3300, Aklapper, Smalyshev, Lucas_Werkmeister_WMDE, PokestarFan, GoranSMilovanovic, QZanden, EBjune, merbst, Avner, debt, Gehel, Jonas, FloNight, Xmlizer, Izno, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331, Krenair___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T172113: ConcurrentModificationException on non-grouping query with aggregates in SELECT
Smalyshev added a comment. Workaround: SELECT ?total ?mandatory (?mandatory/?total AS ?ratio) WHERE { { SELECT (COUNT(*) AS ?total) (COUNT(?status) AS ?mandatory) WHERE { ?property p:P2302 ?statement. OPTIONAL { ?statement pq:P2316 ?status. } } } }TASK DETAILhttps://phabricator.wikimedia.org/T172113EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Aklapper, Smalyshev, Lucas_Werkmeister_WMDE, PokestarFan, GoranSMilovanovic, QZanden, EBjune, merbst, Avner, debt, Gehel, Jonas, FloNight, Xmlizer, Izno, 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