Opened 18 years ago

Last modified 18 years ago

#414 closed defect

Experiment explorer not working in Postgres — at Version 1

Reported by: Nicklas Nordborg Owned by: Nicklas Nordborg
Priority: major Milestone: BASE 2.1
Component: core Version:
Keywords: Cc:

Description (last modified by Nicklas Nordborg)

Error message  	ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
Stack trace 	

...at AbstractSqlQuery.iterate(AbstractSqlQuery.java:193)
...at net.sf.basedb.clients.web.ExperimentExplorer.getReporter(ExperimentExplorer.java:517)
...at org.apache.jsp.views.experiments.explorer.view.view_jsp._jspService(view_jsp.java:232)

SQL that was generated:

SELECT DISTINCT "rpt"."id" AS "id" 
FROM "base2"."dynamic"."D40363Spot" "spt" 
INNER JOIN "base2"."dynamic"."D40363Pos" AS "pos" 
ON "pos"."cube" = "spt"."cube" 
AND "pos"."position" = "spt"."position"  
INNER JOIN "Reporters" AS rpt 
ON rpt.id = pos."reporter_id"  
WHERE "spt"."cube" = 2 AND "spt"."layer" = 1 
ORDER BY "rpt"."external_id" ASC limit ?

Apparently, we are ordering by "external_id" which is not in the SELECT list and Postgres doesn't like that.

Change History (1)

comment:1 by Nicklas Nordborg, 18 years ago

Description: modified (diff)
Status: newassigned
Note: See TracTickets for help on using tickets.