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