web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml | 3 +++
1 file changed, 3 insertions(+)
New commits:
commit 2cd413f35eff217fce8c266ea0cb10c48a43fef9
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Tue Mar 22 14:20:58 2011 +0100
Fixing the system_set_supports_reboot PostgreSQL issue.
Addressing
DBD::Pg::st execute failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must
appear in select list
diff --git a/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
b/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
index bc972c0..f5be131 100644
--- a/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
+++ b/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
@@ -733,6 +733,8 @@ SELECT DISTINCT SP.server_id id, PN.name || '-' ||
PE.evr.as_vre_simple() NVRE
<query name="system_set_supports_reboot" />
</mode>
<query name="system_set_supports_reboot" params="user_id,
set_label">
+SELECT *
+from (
SELECT DISTINCT S.id, S.name
FROM rhnArchType AT,
rhnServerArch SA,
@@ -757,6 +759,7 @@ SELECT DISTINCT S.id, S.name
AND PE2.id = lookup_evr(NULL, '2.9.3', '2.2.1AS')
AND PE.evr >= PE2.evr))
)
+) S
ORDER BY UPPER(S.name), S.id
</query>