java/code/src/com/redhat/rhn/domain/channel/Channel.hbm.xml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-)
New commits: commit 50c96dcda47590dc604fdda77be5efd01d109fe7 Author: Milan Zazrivec mzazrivec@redhat.com Date: Tue Feb 8 14:39:51 2011 +0100
fix outer join syntax in Channel.accessibleChildChannelIds
This is to fix error: ORA-00904: "C"."ID": invalid identifier
diff --git a/java/code/src/com/redhat/rhn/domain/channel/Channel.hbm.xml b/java/code/src/com/redhat/rhn/domain/channel/Channel.hbm.xml index c8ff67a..d435ae2 100644 --- a/java/code/src/com/redhat/rhn/domain/channel/Channel.hbm.xml +++ b/java/code/src/com/redhat/rhn/domain/channel/Channel.hbm.xml @@ -240,9 +240,9 @@ PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" AND rhn_channel.get_org_access(c.id, :org_id) = 1 UNION SELECT {c.*} - FROM rhnChannel c, + FROM rhnChannel c + LEFT OUTER JOIN rhnChannelCloned c_1_ ON c.id = c_1_.id, rhnSharedChannelView sc - LEFT OUTER JOIN rhnChannelCloned c_1_ ON c.id = c_1_.id WHERE sc.parent_channel = :cid AND sc.org_trust_id = :org_id AND sc.id = c.id
spacewalk-commits@lists.fedorahosted.org