Hi,
I believe I've found an error in the rhnVisServerGroupMembership view:
SELECT sg.org_id, sgm.server_id, sg.id AS group_id, sg.name AS
group_name, sgt.label AS group_type, sg.current_members,
sg.max_members
FROM ((rhnservergroupmembers sgm RIGHT JOIN rhnvisibleservergroup sg ON
((sg.id = sgm.server_group_id)))
LEFT JOIN rhnservergroup type sgt ON ((sg.group_type = sgt.id)));
The view selects sgt.label (which is of type varchar) as group_type, but isn't
group_type supposed to be a numeric field?
Group_type being a varchar leads to further errors in PostgreSQL with other
queries, like 'group_a_system_is_in' from SystemGroup_queries.xml).
Best regards,
Julian
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel
