You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@activemq.apache.org by gt...@apache.org on 2012/02/08 12:21:40 UTC
svn commit: r1241869 -
/activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/Statements.java
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;
}