From: <sc...@hy...> - 2008-04-21 18:00:43
|
Author: scottmf Date: 2008-04-21 11:00:27 -0700 (Mon, 21 Apr 2008) New Revision: 9076 URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=9076 Modified: trunk/src/org/hyperic/hq/measurement/server/session/AvailabilityDataDAO.java Log: [HQ-1246] expanded group by stmt to work with postgres Modified: trunk/src/org/hyperic/hq/measurement/server/session/AvailabilityDataDAO.java =================================================================== --- trunk/src/org/hyperic/hq/measurement/server/session/AvailabilityDataDAO.java 2008-04-21 07:21:35 UTC (rev 9075) +++ trunk/src/org/hyperic/hq/measurement/server/session/AvailabilityDataDAO.java 2008-04-21 18:00:27 UTC (rev 9076) @@ -237,7 +237,13 @@ .append(" OR rle.endtime > :startime)") .append(" AND (rle.availabilityDataId.startime < :endtime") .append(" OR rle.endtime < :endtime)") - .append(" group by m,") + // must group by all columns in query for postgres to work + // there is an open bug on this for hibernate to + // automatically expand group by's + // http://opensource.atlassian.com/projects/hibernate/browse/HHH-2407 + .append(" group by m.id,m._version_,m.instanceId,") + .append(" m.template,m.mtime,m.enabled,") + .append(" m.interval,m.dsn,m.resource,") .append(" rle.availabilityDataId.startime, rle.availVal,") .append(" rle.endtime").toString(); return getSession() |