search

sib-swiss / sparql-examples

A set of SPARQL examples that are used in different SIB resources
https://sib-swiss.github.io/sparql-examples
Other
0 stars 0 forks source link

Import the metantex examples from the rdf.metanetx.org page #11

Closed JervenBolleman closed 1 month ago

JervenBolleman commented 1 month ago

@mpagni12 @smoretti are you ok with this?

To note this fixes a few queries which have an implicit GROUP BY that is virtuoso specific but not actually SPARQL 1.1 (examples 11,12,13) to start with.

smoretti commented 1 month ago

Regarding GROUP BY, Virtuoso does not like

GROUP BY ?reac_orig_label ?reac_mnx_label ?lb ?ub ?dir ?cata_orig ORDER BY (?reac) in 11:

Virtuoso 37000 Error SP031: SPARQL compiler: Variable ?reac is used in the result set outside aggregate and not mentioned in GROUP BY clause

but GROUP BY ?reac_orig_label ?reac_mnx_label ?lb ?ub ?dir ?cata_orig ?reac ORDER BY (?reac) works.

Do you agree with this change?

JervenBolleman commented 1 month ago

Yes

On Wed, May 29, 2024, 15:49 smoretti @.***> wrote:

Regarding GROUP BY, Virtuoso does not like

GROUP BY ?reac_orig_label ?reac_mnx_label ?lb ?ub ?dir ?cata_orig ORDER BY (?reac) in 11:

Virtuoso 37000 Error SP031: SPARQL compiler: Variable ?reac is used in the result set outside aggregate and not mentioned in GROUP BY clause

but GROUP BY ?reac_orig_label ?reac_mnx_label ?lb ?ub ?dir ?cata_orig ?reac ORDER BY (?reac) works.

Do you agree with this change?

— Reply to this email directly, view it on GitHub https://github.com/sib-swiss/sparql-examples/pull/11#issuecomment-2137464325, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAHQYFKRRVA77KFL2OM5KU3ZEXMGHAVCNFSM6AAAAABIHYSBA6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMZXGQ3DIMZSGU . You are receiving this because you authored the thread.Message ID: @.***>

smoretti commented 1 month ago

Queries 11, 12 and 13 updated on MetaNetX beta