You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@marmotta.apache.org by "Jakob Frank (JIRA)" <ji...@apache.org> on 2018/06/18 19:32:05 UTC
[jira] [Closed] (MARMOTTA-578) Evaluation of GROUP BY and ORDER BY
together fails on PostgreSQL
[ https://issues.apache.org/jira/browse/MARMOTTA-578?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jakob Frank closed MARMOTTA-578.
--------------------------------
Marmotta 3.4.0 released: https://s.apache.org/oBw2
> Evaluation of GROUP BY and ORDER BY together fails on PostgreSQL
> ----------------------------------------------------------------
>
> Key: MARMOTTA-578
> URL: https://issues.apache.org/jira/browse/MARMOTTA-578
> Project: Marmotta
> Issue Type: Bug
> Components: KiWi Triple Store
> Affects Versions: 3.3.0
> Reporter: Sergio Fernández
> Assignee: Sergio Fernández
> Priority: Major
> Labels: sparql
> Fix For: 3.3.1, 3.4.0
>
> Original Estimate: 4h
> Time Spent: 2h
> Remaining Estimate: 2h
>
> Any SPARQL query with both constructions:
> {code:none}
> SELECT ?person ?name
> WHERE {
> ?person a foaf:Person ;
> foaf:name ?name .
> }
> GROUP BY ?person ?name
> ORDER BY ?name
> LIMIT 10
> {code}
> looks to fail:
> {code:none}
> org.openrdf.query.QueryEvaluationException: org.postgresql.util.PSQLException: ERROR: column "p2_object_v2.svalue" must appear in the GROUP BY clause or be used in an aggregate function
> Position: 431
> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)
> at org.apache.marmotta.kiwi.sparql.evaluation.KiWiEvaluationStrategy$1.call(KiWiEvaluationStrategy.java:220)
> at org.apache.marmotta.kiwi.sparql.evaluation.KiWiEvaluationStrategy$1.call(KiWiEvaluationStrategy.java:216)
> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:745)
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)