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@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