[Lsb-messages] /var/www/bzr/lsb/devel/dbadmin r240: Remove dups from 'LSB cmds not in distribution' consistency report

[Denis Silakov]

------------------------------------------------------------
revno: 240
committer: Denis Silakov <denis.silakov at rosalab.ru>
branch nick: dbadmin
timestamp: Thu 2012-03-15 10:30:04 +0400
message:
  Remove dups from 'LSB cmds not in distribution' consistency report
modified:
  presence.inc
-------------- next part --------------
=== modified file 'presence.inc'
--- a/presence.inc	2011-12-12 07:59:00 +0000
+++ b/presence.inc	2012-03-15 06:30:04 +0000
@@ -756,13 +756,14 @@
                             WHERE Cdistr=$Did";
     Query($createDistrCmds);
 
-    $selectMissingCmds = "SELECT Cname, SMmandatorysince FROM tmp_CmdsIncludedIn_".$ver_str."
+    $selectMissingCmds = "SELECT Cname, MAX(SMmandatorysince) AS SMmandatorysince FROM tmp_CmdsIncludedIn_".$ver_str."
                             JOIN SModCmd ON SMCcid=Cid
                             JOIN SubModule ON SMid=SMCsmid
                             WHERE NOT EXISTS (
                                 SELECT 1 FROM tmp_Distr_".$Did."_".$ver_str."_Cmds
                                 WHERE tmp_CmdsIncludedIn_".$ver_str.".Cname = tmp_Distr_".$Did."_".$ver_str."_Cmds.Cname
                             )
+                            GROUP BY Cname
                             ";
     $res = Query($selectMissingCmds);
     print "<table class='wikitable'>\n";