java/code/src/com/redhat/rhn/domain/org/Org.hbm.xml | 10 +++++-----
1 file changed, 5 insertions(+), 5 deletions(-)
New commits:
commit 645d46cbfc4c8fa217b90378b882357c887dae95
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Wed May 11 13:58:14 2011 +0200
703143 - changed (+) to ANSI JOIN
PostgreSQL patch contributed by Julian Einwag
diff --git a/java/code/src/com/redhat/rhn/domain/org/Org.hbm.xml
b/java/code/src/com/redhat/rhn/domain/org/Org.hbm.xml
index f2cea5e..534149b 100644
--- a/java/code/src/com/redhat/rhn/domain/org/Org.hbm.xml
+++ b/java/code/src/com/redhat/rhn/domain/org/Org.hbm.xml
@@ -77,11 +77,11 @@ PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
<sql-query name="Org.accessibleChannels">
<![CDATA[SELECT {c.*}
FROM rhnChannel {c},
- rhnChannelCloned c_1_,
- rhnAvailableChannels cfp
- WHERE c.id = cfp.channel_id AND
- c.id = c_1_.original_id (+) AND
- cfp.org_id = :org_id]]>
+ LEFT JOIN rhnChannelCloned c_1_
+ ON c.id = c_1_.original_id
+ JOIN rhnAvailableChannels cfp
+ ON c.id = cfp.channel_id
+ WHERE cfp.org_id = :org_id]]>
<return alias="c"
class="com.redhat.rhn.domain.channel.Channel" />
</sql-query>
<sql-query name="Org.numOfOrgAdmins">
Show replies by date