[MARMOTTA-578] Evaluation of GROUP BY and ORDER BY together fails on PostgreSQL

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.3.0
• Fix Version/s: 3.3.1, 3.4.0
• Component/s: KiWi Triple Store
• Labels: sparql
• Assignee: Sergio Fernández
• Reporter: Sergio Fernández
• Due: 12/Dec/14
• Created: 09/Dec/14 08:49
• Updated: 18/Jun/18 19:31
• Resolved: 09/Dec/14 20:30

Description

Any SPARQL query with both constructions:

SELECT ?person ?name
WHERE {
  ?person a foaf:Person ;
    foaf:name ?name .
}
GROUP BY ?person ?name
ORDER BY ?name
LIMIT 10

looks to fail:

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)