You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@roller.apache.org by sn...@apache.org on 2006/11/20 17:22:12 UTC

svn commit: r477235 - /incubator/roller/branches/roller_3.1/src/org/apache/roller/planet/business/hibernate/HibernatePlanetManagerImpl.java

Author: snoopdave
Date: Mon Nov 20 08:22:12 2006
New Revision: 477235

URL: http://svn.apache.org/viewvc?view=rev&rev=477235
Log:
distinct is unnecessary (and fails on Derby), merged from trunk r475787

Modified:
    incubator/roller/branches/roller_3.1/src/org/apache/roller/planet/business/hibernate/HibernatePlanetManagerImpl.java

Modified: incubator/roller/branches/roller_3.1/src/org/apache/roller/planet/business/hibernate/HibernatePlanetManagerImpl.java
URL: http://svn.apache.org/viewvc/incubator/roller/branches/roller_3.1/src/org/apache/roller/planet/business/hibernate/HibernatePlanetManagerImpl.java?view=diff&rev=477235&r1=477234&r2=477235
==============================================================================
--- incubator/roller/branches/roller_3.1/src/org/apache/roller/planet/business/hibernate/HibernatePlanetManagerImpl.java (original)
+++ incubator/roller/branches/roller_3.1/src/org/apache/roller/planet/business/hibernate/HibernatePlanetManagerImpl.java Mon Nov 20 08:22:12 2006
@@ -287,7 +287,7 @@
             
             if (group != null) {
                 StringBuffer sb = new StringBuffer();
-                sb.append("select distinct e from org.apache.roller.planet.pojos.PlanetEntryData e ");
+                sb.append("select e from org.apache.roller.planet.pojos.PlanetEntryData e ");
                 sb.append("join e.subscription.groups g ");
                 sb.append("where g.handle=:groupHandle and e.pubTime < :endDate ");
                 if (startDate != null) {
@@ -305,7 +305,7 @@
                 ret = query.list();
             } else {
                 StringBuffer sb = new StringBuffer();
-                sb.append("select distinct e from org.apache.roller.planet.pojos.PlanetEntryData e ");
+                sb.append("select e from org.apache.roller.planet.pojos.PlanetEntryData e ");
                 sb.append("join e.subscription.groups g ");
                 sb.append("where (g.handle='external' or g.handle='all') ");
                 sb.append("and e.pubTime < :endDate ");