Hi,
I just came across the query "visible_to_system" in SystemGroup_queries.xml:
SELECT MAX(DECODE(VSGM.server_id, :sid, 1, 0)) is_system_member,
VSGM.GROUP_ID id,
VSGM.GROUP_NAME,
VSGM.GROUP_TYPE,
VSGM.CURRENT_MEMBERS,
VSGM.MAX_MEMBERS,
DECODE(USGP.server_group_id,VSGM.group_id,1,0) AS USER_PERMITTED_ACCESS
FROM rhnVisServerGroupMembership VSGM, rhnUserServerGroupPerms USGP
WHERE VSGM.ORG_ID = :org_id
AND :user_id = USGP.user_id (+)
AND VSGM.group_id = USGP.server_group_id (+)
GROUP BY VSGM.group_id, VSGM.group_name, VSGM.group_type, VSGM.current_members,
VSGM.max_members, USGP.server_group_id
ORDER BY UPPER(VSGM.group_name), VSGM.group_id
While I do understand that (+) is the old fashioned Oracle syntax for outer
joins, I'm having trouble understanding what the (+) does in the condition
':user_id = USGP.user_id (+)', since it's not join-related. I did some quick
tests on an Oracle installation but I couldn't make sense of it.
Any help would be appreciated.
Best regards,
Julian
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel
