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.
Note:
See TracTickets
for help on using tickets.