Opened 18 years ago

Last modified 18 years ago

#414 closed defect

Experiment explorer not working in Postgres — at Initial Version

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

Description

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 (0)

Note: See TracTickets for help on using tickets.