[Wikidata-bugs] [Maniphest] T279945: Using the same property in different conditions with regardless of value generates malformed SPARQL query

[amy_rc]

amy_rc closed this task as "Resolved".
amy_rc moved this task from Test (Verification) to Done on the 
Wikidata-Campsite (Wikidata-Campsite-Iteration-∞) board.
amy_rc added a comment.


  tested and worked. 🎉

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

WORKBOARD
  https://phabricator.wikimedia.org/project/board/3539/

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

To: Tonina_Zhelyazkova_WMDE, amy_rc
Cc: amy_rc, Aklapper, guergana.tzatchkova, Invadibot, Lalamarie69, maantietaja, 
Alter-paule, Beast1978, Un1tY, Akuckartz, Hook696, Iflorez, Kent7301, 
alaa_wmde, joker88john, CucyNoiD, Nandana, Gaboe420, Giuliamocci, Cpaulf30, 
Lahi, Gq86, Af420, Bsandipan, GoranSMilovanovic, QZanden, LawExplorer, 
Lewizho99, Maathavan, _jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, 
aude, Lydia_Pintscher, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

[Wikidata-bugs] [Maniphest] T279945: Using the same property in different conditions with regardless of value generates malformed SPARQL query

[gerritbot]

gerritbot added a comment.


  Change 684912 **merged** by jenkins-bot:
  
  [wikidata/query-builder@master] Add an index to repeating properties of any 
value
  
  https://gerrit.wikimedia.org/r/684912

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

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

To: Tonina_Zhelyazkova_WMDE, gerritbot
Cc: Aklapper, guergana.tzatchkova, Invadibot, Lalamarie69, maantietaja, 
Alter-paule, Beast1978, Un1tY, Akuckartz, Hook696, Iflorez, Kent7301, 
alaa_wmde, joker88john, CucyNoiD, Nandana, Gaboe420, Giuliamocci, Cpaulf30, 
Lahi, Gq86, Af420, Bsandipan, GoranSMilovanovic, QZanden, LawExplorer, 
Lewizho99, Maathavan, _jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, 
aude, Lydia_Pintscher, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

[Wikidata-bugs] [Maniphest] T279945: Using the same property in different conditions with regardless of value generates malformed SPARQL query

[gerritbot]

gerritbot added a comment.


  Change 684912 had a related patch set uploaded (by Tonina Zhelyazkova; 
author: Tonina Zhelyazkova):
  
  [wikidata/query-builder@master] Add an index to repeating properties of any 
value
  
  https://gerrit.wikimedia.org/r/684912

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

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

To: Tonina_Zhelyazkova_WMDE, gerritbot
Cc: Aklapper, guergana.tzatchkova, Invadibot, Lalamarie69, maantietaja, 
Alter-paule, Beast1978, Un1tY, Akuckartz, Hook696, Iflorez, Kent7301, 
alaa_wmde, joker88john, CucyNoiD, Nandana, Gaboe420, Giuliamocci, Cpaulf30, 
Lahi, Gq86, Af420, Bsandipan, GoranSMilovanovic, QZanden, LawExplorer, 
Lewizho99, Maathavan, _jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, 
aude, Lydia_Pintscher, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

[Wikidata-bugs] [Maniphest] T279945: Using the same property in different conditions with regardless of value generates malformed SPARQL query

[gerritbot]

gerritbot added a comment.


  Change 684889 had a related patch set uploaded (by Tonina Zhelyazkova; 
author: Tonina Zhelyazkova):
  
  [wikidata/query-builder@master] Add an index to all 'anyValue' occurrences
  
  https://gerrit.wikimedia.org/r/684889

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

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

To: Tonina_Zhelyazkova_WMDE, gerritbot
Cc: Aklapper, guergana.tzatchkova, Invadibot, Lalamarie69, maantietaja, 
Alter-paule, Beast1978, Un1tY, Akuckartz, Hook696, Iflorez, Kent7301, 
alaa_wmde, joker88john, CucyNoiD, Nandana, Gaboe420, Giuliamocci, Cpaulf30, 
Lahi, Gq86, Af420, Bsandipan, GoranSMilovanovic, QZanden, LawExplorer, 
Lewizho99, Maathavan, _jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, 
aude, Lydia_Pintscher, Mbch331
___
Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org
To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org

[Wikidata-bugs] [Maniphest] T279945: Using the same property in different conditions with regardless of value generates malformed SPARQL query

[gerritbot]

gerritbot added a project: Patch-For-Review.

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

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

To: Tonina_Zhelyazkova_WMDE, gerritbot
Cc: Aklapper, guergana.tzatchkova, Invadibot, maantietaja, Alter-paule, 
Beast1978, Un1tY, Akuckartz, Hook696, Iflorez, Kent7301, alaa_wmde, 
joker88john, CucyNoiD, Nandana, Gaboe420, Giuliamocci, Cpaulf30, Lahi, Gq86, 
Af420, Bsandipan, GoranSMilovanovic, QZanden, LawExplorer, Lewizho99, 
Maathavan, _jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, aude, 
Lydia_Pintscher, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] T279945: Using the same property in different conditions with regardless of value generates malformed SPARQL query

[gerritbot]

gerritbot added a comment.


  Change 682684 had a related patch set uploaded (by Tonina Zhelyazkova; 
author: Tonina Zhelyazkova):
  
  [wikidata/query-builder@master] Index repeating property IDs in the sparql 
query
  
  https://gerrit.wikimedia.org/r/682684

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

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

To: Tonina_Zhelyazkova_WMDE, gerritbot
Cc: Aklapper, guergana.tzatchkova, Invadibot, maantietaja, Akuckartz, Iflorez, 
alaa_wmde, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, 
_jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, 
Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] T279945: Using the same property in different conditions with regardless of value generates malformed SPARQL query

[Tonina_Zhelyazkova_WMDE]

Tonina_Zhelyazkova_WMDE moved this task from To Do (prioritised from top to 
bottom) to Doing on the Wikidata-Campsite (Wikidata-Campsite-Iteration-∞) board.
Tonina_Zhelyazkova_WMDE claimed this task.

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

WORKBOARD
  https://phabricator.wikimedia.org/project/board/3539/

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

To: Tonina_Zhelyazkova_WMDE
Cc: Aklapper, guergana.tzatchkova, Invadibot, maantietaja, Akuckartz, Iflorez, 
alaa_wmde, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, 
_jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, 
Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] T279945: Using the same property in different conditions with regardless of value generates malformed SPARQL query

[Lydia_Pintscher]

Lydia_Pintscher moved this task from Prioritized Product (prioritised from top 
to bottom) to Wikidata-Campsite-Iteration-∞ on the Wikidata-Campsite board.
Lydia_Pintscher edited projects, added Wikidata-Campsite 
(Wikidata-Campsite-Iteration-∞); removed Wikidata-Campsite.

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

WORKBOARD
  https://phabricator.wikimedia.org/project/board/3402/

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

To: Lydia_Pintscher
Cc: Aklapper, guergana.tzatchkova, Invadibot, maantietaja, Akuckartz, Iflorez, 
alaa_wmde, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, 
_jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, 
Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] T279945: Using the same property in different conditions with regardless of value generates malformed SPARQL query

[Lydia_Pintscher]

Lydia_Pintscher set the point value for this task to "5".

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

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

To: Lydia_Pintscher
Cc: Aklapper, guergana.tzatchkova, Invadibot, maantietaja, Akuckartz, Nandana, 
Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] T279945: Using the same property in different conditions with regardless of value generates malformed SPARQL query

[Lydia_Pintscher]

Lydia_Pintscher added a project: Wikidata-Campsite.

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

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

To: Lydia_Pintscher
Cc: Aklapper, guergana.tzatchkova, Invadibot, maantietaja, Akuckartz, Nandana, 
Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] T279945: Using the same property in different conditions with regardless of value generates malformed SPARQL query

[guergana.tzatchkova]

guergana.tzatchkova created this task.
guergana.tzatchkova added a project: Wikidata Query Builder.
Restricted Application added a subscriber: Aklapper.
Restricted Application added a project: Wikidata.

TASK DESCRIPTION
  **List of steps to reproduce** (step by step, including full links if 
applicable):
  
  - select property P18  (image) it is 
automatically regardless of value)
  - create a different property and unite with OR or AND again with P18 

  - click "Run Query" button
  
  Example in QB 
  
  **Actual Results (what happens?)**:
  
  Error: `Query is malformed: BNodeID already used in another scope: 
anyValueP18` because
  
  `anyValueP18` should have an index. should be `anyValueP18_0` and 
`anyValueP18_1`:
  
SELECT DISTINCT ?item WHERE {
  {
?item p:P281 ?statement0.
?statement0 (ps:P281) "6200".
  }
  UNION
  {
?item p:P18 ?statement1.
?statement1 (ps:P18) _:anyValueP18.
  }
  {
?item p:P30 ?statement2.
?statement2 (ps:P30/(wdt:P279*)) wd:Q46.
  }
  UNION
  {
?item p:P18 ?statement3.
?statement3 (ps:P18) _:anyValueP18.
  }
}
LIMIT 100
  
  **Expected Results (what should have happened?)**:
  
  The following SPARQL should have been generated
  
SELECT DISTINCT ?item WHERE {
  {
?item p:P281 ?statement0.
?statement0 (ps:P281) "6200".
  }
  UNION
  {
?item p:P18 ?statement1.
?statement1 (ps:P18) _:anyValueP18_0.
  }
  {
?item p:P30 ?statement2.
?statement2 (ps:P30/(wdt:P279*)) wd:Q46.
  }
  UNION
  {
?item p:P18 ?statement3.
?statement3 (ps:P18) _:anyValueP18_1.
  }
}
LIMIT 100

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

WORKBOARD
  https://phabricator.wikimedia.org/project/board/4990/

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

To: guergana.tzatchkova
Cc: Aklapper, guergana.tzatchkova, Invadibot, maantietaja, Akuckartz, Nandana, 
Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, 
Scott_WUaS, Wikidata-bugs, aude, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs