[Lsb-messages] /var/www/bzr/lsb/devel/dbadmin r274: Improve 'Included Ints without Std' check

[Denis Silakov]

------------------------------------------------------------
revno: 274
committer: Denis Silakov <denis.silakov at rosalab.ru>
branch nick: dbadmin
timestamp: Thu 2013-01-17 10:01:25 +0400
message:
  Improve 'Included Ints without Std' check
modified:
  consistency/consistency.php
  consistency/queries.php
-------------- next part --------------
=== modified file 'consistency/consistency.php'
--- a/consistency/consistency.php	2013-01-16 11:13:43 +0000
+++ b/consistency/consistency.php	2013-01-17 06:01:25 +0000
@@ -483,7 +483,7 @@
 print("<td>Included interfaces without standards</td>");
 $select = "SELECT COUNT(DISTINCT Iid) FROM Interface
             LEFT JOIN ArchInt ON AIint=Iid
-            LEFT JOIN IntStd ON ISiid=Iid
+            LEFT JOIN IntStd ON ISiid=Iid AND ISappearedin > '' AND ISwithdrawnin IS NULL
             WHERE (ISsid=0 OR ISsid IS NULL)
             AND AIappearedin > ''
             AND AIwithdrawnin IS NULL ";
@@ -928,8 +928,8 @@
 
 print "<h2>Other Checks</h2>\n";
 print "<ul>\n";
-print "<li><a href='queries.php?cmd=app-with'>'Appearance' fields consistency</a></li>\n";
-print "<li><a href='queries.php?cmd=app-mappings'>Inconsistencies of 'Appearance' fields correspondence</a></li>\n";
+print "<li><a href='queries.php?cmd=app-with'>'Appearence' fields consistency</a></li>\n";
+print "<li><a href='queries.php?cmd=app-mappings'>Inconsistencies of 'Appearence' fields correspondence</a></li>\n";
 print "<li><a href='queries.php?cmd=incons-rec'>Foreign keys check</a></li>\n";
 print "</ul>\n";
 

=== modified file 'consistency/queries.php'
--- a/consistency/queries.php	2013-01-16 11:10:11 +0000
+++ b/consistency/queries.php	2013-01-17 06:01:25 +0000
@@ -2172,7 +2172,7 @@
         $desc.= "This can be considered outstanding issues.";
         $select = "SELECT Iid,Iname,Iunmangled, Ilibrary, Sname, COUNT(DISTINCT Sid) AS StdCnt, Surl FROM Interface
                     LEFT JOIN ArchInt ON AIint=Iid
-                    LEFT JOIN IntStd ON ISiid=Iid
+                    LEFT JOIN IntStd ON ISiid=Iid AND ISappearedin > '' AND ISwithdrawnin IS NULL
                     LEFT JOIN Standard ON Sid=ISsid
                     WHERE (ISsid IS NULL OR ISsid=0)
                     AND AIappearedin > ''