java/code/src/com/redhat/rhn/common/db/datasource/xml/profile_queries.xml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit a041d5642d12a6b89d0c1e8fe6a34bf65081051f
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Thu Apr 5 15:32:28 2012 +0200
809897 - using the evr_t_as_vre_simple.
Addressing
ERROR: cross-database references are not implemented: pe.evr.as_vre_simple
STATEMENT: SELECT PN.name || '-' || PE.evr.as_vre_simple() AS NVRE,
PA.label as arch
FROM rhnServerProfilePackage SPP
LEFT JOIN rhnPackageArch PA ON SPP.package_arch_id = PA.id
INNER JOIN rhnPackageName PN ON SPP.name_id = PN.id
INNER JOIN rhnPackageEVR PE ON SPP.evr_id = PE.id
WHERE SPP.server_profile_id = $1
ORDER BY UPPER(PN.name), PE.evr
ERROR: current transaction is aborted, commands ignored until end of transaction
block
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/profile_queries.xml
b/java/code/src/com/redhat/rhn/common/db/datasource/xml/profile_queries.xml
index b003a47..7445571 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/profile_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/profile_queries.xml
@@ -15,7 +15,7 @@ ORDER BY UPPER(SP.name)
<mode name="profile_package_overview"
class="com.redhat.rhn.frontend.dto.ProfilePackageOverviewDto">
<query params="prid">
-SELECT PN.name || '-' || PE.evr.as_vre_simple() AS NVRE,
+SELECT PN.name || '-' || evr_t_as_vre_simple(PE.evr) AS NVRE,
PA.label as arch
FROM rhnServerProfilePackage SPP
LEFT JOIN rhnPackageArch PA ON SPP.package_arch_id = PA.id
Show replies by date