web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit cab6342be786e25f9ce2cae6665e26c1e99940a8
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Wed Aug 10 14:14:47 2011 +0200
COALESCE works in both db backends
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 5a23d57..7ee73b4 100644
--- a/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
+++ b/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
@@ -346,7 +346,7 @@ SELECT S.id
AND SC.channel_id = CP.channel_id
AND CP.package_id = :pid
AND CP.package_id = P.id
- AND NVL((SELECT MAX(PE.evr)
+ AND COALESCE((SELECT MAX(PE.evr)
FROM rhnServerPackage SP, rhnPackageEvr PE
WHERE SP.name_id = P.name_id
AND SP.server_id = S.id
Show replies by date