[Lsb-messages] /var/www/bzr/lsb/devel/dbadmin r242: Several bug fixes

Denis Silakov denis.silakov at rosalab.ru
Tue Mar 27 06:43:42 UTC 2012


------------------------------------------------------------
revno: 242
committer: Denis Silakov <denis.silakov at rosalab.ru>
branch nick: dbadmin
timestamp: Tue 2012-03-27 10:43:42 +0400
message:
  Several bug fixes
modified:
  commons/search.inc
  consistency/consistency.php
  consistency/queries.php
-------------- next part --------------
=== modified file 'commons/search.inc'
--- a/commons/search.inc	2011-08-29 07:50:40 +0000
+++ b/commons/search.inc	2012-03-27 06:43:42 +0000
@@ -24,7 +24,7 @@
     }
 
     if( $Hname ) {
-        $Lname = Query_value("SELECT Lname FROM Header JOIN Library ON Hlib-Lid WHERE Hname='$Hname'");
+        $Lname = Query_value("SELECT Lname FROM Header JOIN Library ON Hlib=Lid WHERE Hname='$Hname'");
     }
     else {
         $Lname = "";
@@ -615,7 +615,7 @@
         print "<tr>";
         print "<td><a href=\"../browse/cmd_single.php?cmd=list-by-name&amp;Cname=".$row['Cname']."\">".htmlspecialchars($row['Cname'])."</a></td>\n";
 
-	$status = command_LSB_status($row['Cname']);
+    $status = command_LSB_status($row['Cname']);
         print "<td>".$status."</td>";
 
         print "</tr>\n";

=== modified file 'consistency/consistency.php'
--- a/consistency/consistency.php	2012-03-23 12:37:45 +0000
+++ b/consistency/consistency.php	2012-03-27 06:43:42 +0000
@@ -691,10 +691,10 @@
 print("</tr><tr>");
 
 print("<td>Unused function pointers and anonymous types (excluding anon enums)</td>");
-Query("CREATE TEMPORARY TABLE tmp_1 (KEY tid(Tid)) SELECT Tid FROM Type WHERE Tid NOT IN (SELECT Ptype FROM Parameter)");
-Query("CREATE TEMPORARY TABLE tmp_2 (KEY tid(Tid)) SELECT Tid FROM tmp_1 WHERE Tid NOT IN (SELECT AIreturn FROM ArchInt)");
-Query("CREATE TEMPORARY TABLE tmp_3 (KEY tid(Tid)) SELECT Tid FROM tmp_2 WHERE Tid NOT IN (SELECT ATbasetype FROM ArchType)");
-Query("CREATE TEMPORARY TABLE tmp_4 (KEY tid(Tid)) SELECT Tid FROM tmp_3 WHERE Tid NOT IN (SELECT TMtypeid FROM TypeMember)");
+Query("CREATE TEMPORARY TABLE tmp_1 (KEY tid(Tid)) SELECT Tid FROM Type WHERE NOT EXISTS (SELECT 1 FROM Parameter WHERE Ptype=Tid)");
+Query("CREATE TEMPORARY TABLE tmp_2 (KEY tid(Tid)) SELECT Tid FROM tmp_1 WHERE NOT EXISTS (SELECT 1 FROM ArchInt WHERE AIreturn=Tid)");
+Query("CREATE TEMPORARY TABLE tmp_3 (KEY tid(Tid)) SELECT Tid FROM tmp_2 WHERE NOT EXISTS (SELECT 1 FROM ArchType WHERE ATbasetype=Tid)");
+Query("CREATE TEMPORARY TABLE tmp_4 (KEY tid(Tid)) SELECT Tid FROM tmp_3 WHERE NOT EXISTS (SELECT 1 FROM TypeMember WHERE TMtypeid=Tid)");
 $select = "SELECT COUNT(Tid) FROM tmp_4
             JOIN Type USING(Tid)
             WHERE (Tname LIKE 'anon%' AND Ttype != 'Enum')

=== modified file 'consistency/queries.php'
--- a/consistency/queries.php	2012-03-23 12:37:45 +0000
+++ b/consistency/queries.php	2012-03-27 06:43:42 +0000
@@ -2337,10 +2337,10 @@
         $i=1;
         $fix_tmpl='DELETE FROM Type WHERE Tid={$1}';
         $title="Unused Function Pointers and Anonymous Types (Excluding Enums)";
-        Query("CREATE TEMPORARY TABLE IF NOT EXISTS tmp_1 (KEY tid(Tid)) SELECT Tid FROM Type WHERE Tid NOT IN (SELECT Ptype FROM Parameter)");
-        Query("CREATE TEMPORARY TABLE tmp2 (KEY tid(Tid)) SELECT Tid FROM tmp_1 WHERE Tid NOT IN (SELECT AIreturn FROM ArchInt)");
-        Query("CREATE TEMPORARY TABLE tmp3 (KEY tid(Tid)) SELECT Tid FROM tmp_2 WHERE Tid NOT IN (SELECT ATbasetype FROM ArchType)");
-        Query("CREATE TEMPORARY TABLE tmp4 (KEY tid(Tid)) SELECT Tid FROM tmp_3 WHERE Tid NOT IN (SELECT TMtypeid FROM TypeMember)");
+        Query("CREATE TEMPORARY TABLE IF NOT EXISTS tmp_1 (KEY tid(Tid)) SELECT Tid FROM Type WHERE NOT EXISTS (SELECT 1 FROM Parameter WHERE Ptype=Tid)");
+        Query("CREATE TEMPORARY TABLE tmp_2 (KEY tid(Tid)) SELECT Tid FROM tmp_1 WHERE NOT EXISTS (SELECT 1 FROM ArchInt WHERE AIreturn=Tid)");
+        Query("CREATE TEMPORARY TABLE tmp_3 (KEY tid(Tid)) SELECT Tid FROM tmp_2 WHERE NOT EXISTS (SELECT 1 FROM ArchType WHERE ATbasetype=Tid)");
+        Query("CREATE TEMPORARY TABLE tmp_4 (KEY tid(Tid)) SELECT Tid FROM tmp_3 WHERE NOT EXISTS (SELECT 1 FROM TypeMember WHERE TMtypeid=Tid)");
         $query="SELECT Tid,Tname FROM tmp_4
                 JOIN Type USING(Tid)
                 WHERE (Tname LIKE 'anon%' AND Ttype != 'Enum')
@@ -2348,7 +2348,7 @@
         $res=Query($query);
         $numrows = mysqli_num_rows($res);
         $numFields = mysqli_num_fields($res);
-        print("<h1>.$title ($numrows ". entry($numrows).")</h1>\n");
+        print("<h1>$title ($numrows ". entry($numrows).")</h1>\n");
         if ($numrows) {
             print("<table class='wikitable'>\n");
             print_table_header("Tid", "Tname", 'Possible Fix');



More information about the lsb-messages mailing list