java/code/src/com/redhat/rhn/common/db/datasource/xml/Channel_queries.xml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 0005d41368a0770c4539fb9c46aa818121ea0a5c
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Tue Oct 25 13:55:51 2011 +0200
DISTINCT is equivalent to UNIQUE.
Addressing
ERROR com.redhat.rhn.common.db.datasource.CachedStatement - Error while processing
cached statement sql: select unique c.id,
c.label,
c.name,
[...]
and rhn_channel.loose_user_role_check(c.id, ?,
'subscribe') = 1
com.redhat.rhn.common.db.WrappedSQLException: ERROR: syntax error at or near
"c"
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Channel_queries.xml
b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Channel_queries.xml
index 28c0613..d04f5f5 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Channel_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Channel_queries.xml
@@ -767,7 +767,7 @@ SELECT C.id, C.name, C.label, 1 AS IS_CUSTOM
<mode name="base_eus_channels_by_version_channel_arch"
class="com.redhat.rhn.frontend.dto.EssentialChannelDto">
<query params="product_name_label, version, channel_arch_id, user_id,
org_id">
- select unique c.id,
+ select distinct c.id,
c.label,
c.name,
rcm.release,
Show replies by date