web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml | 5 ++++-
1 file changed, 4 insertions(+), 1 deletion(-)
New commits:
commit 8a5064c455a99ef3d105a984d193a4942dcee38a
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Tue Mar 22 14:32:00 2011 +0100
Fixing another taggable_systems_in_set PostgreSQL issue.
Addressing
DBD::Pg::st execute failed: ERROR: function nvl(name, unknown) does not exist
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 a56da8b..911ac83 100644
--- a/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
+++ b/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
@@ -132,7 +132,7 @@ SELECT DISTINCT S.id,
AND USP.server_id = SS.server_id
AND USP.server_id = S.id
) S
-ORDER BY UPPER(NVL(S.NAME, '(none)')), S.ID
+ORDER BY UPPER(coalesce(S.NAME, '(none)')), S.ID
</query>
<elaborator name="system_overview" />
</mode>
commit 6e05757d69ea63b07ca775b824589176f1fce2c4
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Tue Mar 22 14:29:21 2011 +0100
Fixing the taggable_systems_in_set PostgreSQL issue.
Addressing
DBD::Pg::st execute failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must
appear in select list at character 454
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 f5be131..a56da8b 100644
--- a/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
+++ b/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
@@ -116,6 +116,8 @@ ORDER BY CDK.label
<mode name="taggable_systems_in_set">
<query params="user_id">
+select *
+from (
SELECT DISTINCT S.id,
S.name AS SERVER_NAME
FROM rhnServer S,
@@ -129,6 +131,7 @@ SELECT DISTINCT S.id,
AND EXISTS(SELECT 1 FROM rhnServerFeaturesView SFV WHERE SFV.server_id = ST.element
AND SFV.label = 'ftr_snapshotting')
AND USP.server_id = SS.server_id
AND USP.server_id = S.id
+) S
ORDER BY UPPER(NVL(S.NAME, '(none)')), S.ID
</query>
<elaborator name="system_overview" />
Show replies by date