[Wikidata-bugs] [Maniphest] [Commented On] T147577: NotMaterializedException (Vocab(2):) on combination of subquery, limit, triple, and label service

2019-09-23 Thread Lucas_Werkmeister_WMDE 
Lucas_Werkmeister_WMDE added a comment.


  Well, that query is pretty different from the one in the task description (no 
subquery, no limit), so I’d file it as a separate bug.

TASK DETAIL
  https://phabricator.wikimedia.org/T147577

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

To: Smalyshev, Lucas_Werkmeister_WMDE
Cc: Lucas_Werkmeister_WMDE, bennofs, hoo, Smalyshev, Aklapper, WikidataFacts, 
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] T147577: NotMaterializedException (Vocab(2):) on combination of subquery, limit, triple, and label service

2019-09-21 Thread bennofs 
bennofs added a comment.


  This does not seem fully fixed yet: 
https://www.wikidata.org/wiki/Wikidata_talk:SPARQL_query_service#Possible_bug. 
Example from that post:
  
SELECT ?item ?itemLabel ?linkTo {
  ?item wdt:P780/wdt:P31*/wdt:P279* wd:Q737460, wd:Q86, wd:Q21120251.
  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}
  
  This has the same behaviour, it is fixed by the workaround and also 
projecting just item or itemLabel works fine. Upstream bug also has some 
reports of issues still.

TASK DETAIL
  https://phabricator.wikimedia.org/T147577

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

To: Smalyshev, bennofs
Cc: bennofs, hoo, Smalyshev, Aklapper, WikidataFacts, darthmon_wmde, ET4Eva, 
DannyS712, Nandana, Lahi, Gq86, Darkminds3113, Lucas_Werkmeister_WMDE, 
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] T147577: NotMaterializedException (Vocab(2):) on combination of subquery, limit, triple, and label service

2016-10-14 Thread Smalyshev 
Smalyshev added a comment.
Workaround: add this to query:

hint:Query hint:analytic "false" .TASK DETAILhttps://phabricator.wikimedia.org/T147577EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Smalyshev, Aklapper, WikidataFacts, 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] T147577: NotMaterializedException (Vocab(2):) on combination of subquery, limit, triple, and label service

2016-10-06 Thread Smalyshev 
Smalyshev added a comment.
Yes, looks like a bug. Even funnier, projecting both ?person and ?personLabel does not work, but each of them alone work. Something is going on there, filed https://jira.blazegraph.com/browse/BLZG-2098TASK DETAILhttps://phabricator.wikimedia.org/T147577EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Smalyshev, Aklapper, WikidataFacts, 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

[Wikidata-bugs] [Maniphest] [Commented On] T147577: NotMaterializedException (Vocab(2):) on combination of subquery, limit, triple, and label service

2016-10-06 Thread Smalyshev 
Smalyshev added a comment.
Can you provide the original query?TASK DETAILhttps://phabricator.wikimedia.org/T147577EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Smalyshev, Aklapper, WikidataFacts, 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

[Wikidata-bugs] [Maniphest] [Commented On] T147577: NotMaterializedException (Vocab(2):) on combination of subquery, limit, triple, and label service

2016-10-06 Thread WikidataFacts 
WikidataFacts added a comment.
Hrm, perhaps I over-reduced it. In the original query, I of course select ?personLabel in the inner query as well – I only noticed that it wasn’t necessary to get the error message, so I threw it out.

But anyways, the only reason I’m bothering with a subquery is so that I get the labels in a proper materialized form that I can use in expressions. Usually, variables from the label service can’t be used in, for example, SELECT (?xLabel AS ?foo) or SELECT (CONCAT("«", ?xLabel, "»") AS ?bar). That’s why I need the label service inside the subquery, so that in the outer query there are no such problems anymore.TASK DETAILhttps://phabricator.wikimedia.org/T147577EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: WikidataFactsCc: Smalyshev, Aklapper, WikidataFacts, 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

[Wikidata-bugs] [Maniphest] [Commented On] T147577: NotMaterializedException (Vocab(2):) on combination of subquery, limit, triple, and label service

2016-10-06 Thread Smalyshev 
Smalyshev added a comment.
This query doesn't look right. It should be:

SELECT ?person ?personLabel WHERE {

{
  SELECT ?person WHERE {
BIND(wd:Q23 AS ?person).
?person wdt:P31 wd:Q5.
  }
  LIMIT 1
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }

}

instead. If you need label outside subquery, service should be outside too.TASK DETAILhttps://phabricator.wikimedia.org/T147577EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Smalyshev, Aklapper, WikidataFacts, 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