java/code/src/com/redhat/rhn/common/db/datasource/xml/Package_queries.xml | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
New commits:
commit 7bd8078b7dc3483f97245f8049ef8f7f688bce83
Author: Joshua Roys <joshua.roys(a)gtri.gatech.edu>
Date: Wed May 5 11:39:29 2010 -0400
588901 - fix to_package_id
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Package_queries.xml
b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Package_queries.xml
index f85a521..fae7400 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Package_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Package_queries.xml
@@ -801,7 +801,7 @@ SELECT PN.name,
FROM (
SELECT SOP.package_name_id name_id,
MAX(PE.evr) evr,
- MAX(PE.id) evr_id,
+ PE.id evr_id,
SP.package_arch_id,
PA.label as arch_label
FROM rhnServerOutdatedPackages SOP
@@ -810,7 +810,7 @@ SELECT PN.name,
LEFT JOIN rhnPackageArch PA ON PA.id = SP.package_arch_id
WHERE SOP.server_id = :sid
AND SOP.package_name_id = SP.name_id
- GROUP BY SOP.package_name_id, SP.package_arch_id, PA.label
+ GROUP BY SOP.package_name_id, SP.package_arch_id, PA.label, PE.id
) full_list
INNER JOIN rhnServerPackage SP ON ( full_list.name_id = SP.name_id AND
full_list.package_arch_id = SP.package_arch_id )
INNER JOIN rhnPackageName PN ON ( PN.id = full_list.name_id )
Show replies by date