activemq-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gtu...@apache.org
Subject svn commit: r1241869 - /activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/Statements.java
Date Wed, 08 Feb 2012 11:21:40 GMT
Author: gtully
Date: Wed Feb  8 11:21:39 2012
New Revision: 1241869

URL: http://svn.apache.org/viewvc?rev=1241869&view=rev
Log:
https://issues.apache.org/jira/browse/AMQ-3695 - remove distinct qualifier from union, breaks
oracle and is the default

Modified:
    activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/Statements.java

Modified: activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/Statements.java
URL: http://svn.apache.org/viewvc/activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/Statements.java?rev=1241869&r1=1241868&r2=1241869&view=diff
==============================================================================
--- activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/Statements.java
(original)
+++ activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/Statements.java
Wed Feb  8 11:21:39 2012
@@ -357,7 +357,7 @@ public class Statements {
     public String getFindAllDestinationsStatement() {
         if (findAllDestinationsStatement == null) {
             findAllDestinationsStatement = "SELECT DISTINCT CONTAINER FROM " + getFullMessageTableName()
-                    + " UNION DISTINCT SELECT DISTINCT CONTAINER FROM "  + getFullAckTableName();
+                    + " UNION SELECT DISTINCT CONTAINER FROM "  + getFullAckTableName();
         }
         return findAllDestinationsStatement;
     }



Mime
View raw message