[Lsb-messages] /var/www/bzr/lsb/devel/dbadmin r261: Give unique names to all tmp_Result temporary tables.
Jeff Licquia
licquia at linuxfoundation.org
Tue Jul 31 19:35:07 UTC 2012
------------------------------------------------------------
revno: 261
committer: Jeff Licquia <licquia at linuxfoundation.org>
branch nick: dbadmin
timestamp: Tue 2012-07-31 15:35:07 -0400
message:
Give unique names to all tmp_Result temporary tables.
modified:
app.inc
app_stats.inc
class_single.inc
coverage/cmd_cov.inc
coverage/coverage.inc
header.inc
headgroup.inc
int_single.inc
interface.inc
intlang.inc
java_class.inc
java_int.inc
lib_single.inc
libgroup.inc
module.inc
presence.inc
rawint.inc
-------------- next part --------------
=== modified file 'app.inc'
--- a/app.inc 2012-04-18 08:11:35 +0000
+++ b/app.inc 2012-07-31 19:35:07 +0000
@@ -157,7 +157,7 @@
$num = Query_value($selectCount);
$entry = entry($num);
- $create = "CREATE TEMPORARY TABLE tmp_Result
+ $create = "CREATE TEMPORARY TABLE tmp_Result_app_1
(KEY k_Aname(Aname))
SELECT Application.*, AppInfo.* FROM tmp_App
LEFT JOIN Application USING(Aid)
@@ -169,7 +169,7 @@
}
Query($create);
- $select = "SELECT * FROM tmp_Result";
+ $select = "SELECT * FROM tmp_Result_app_1";
$res=Query($select);
if( $heading ) {
@@ -198,7 +198,7 @@
$span = 0;
if( $oldAname != $row['Aname'] ) {
$oldAname = $row['Aname'];
- $span = Query_value("SELECT COUNT(*) FROM tmp_Result WHERE Aname='$oldAname'");
+ $span = Query_value("SELECT COUNT(*) FROM tmp_Result_app_1 WHERE Aname='$oldAname'");
}
$selectInts = "SELECT COUNT(*) FROM AppRInt WHERE ARIaid=".$row["Aid"];
@@ -525,7 +525,7 @@
$num = Query_value("SELECT COUNT(*) FROM AppJInt WHERE AJIjcompid=$Aid");
$entry = entry($num);
- $create = "CREATE TEMPORARY TABLE tmp_Result
+ $create = "CREATE TEMPORARY TABLE tmp_Result_app_2
(KEY JCid(JCid))
SELECT JIid, JCid, JCname, JIname, JIunmangled FROM JavaClass
JOIN JavaInterface ON JIjcid=JCid
@@ -536,7 +536,7 @@
}
Query($create);
- $select = "SELECT * FROM tmp_Result ORDER BY JCname, JIname";
+ $select = "SELECT * FROM tmp_Result_app_2 ORDER BY JCname, JIname";
$res = Query($select);
$Name = form_app_name($row);
@@ -561,7 +561,7 @@
$JCid = $row['JCid'];
if( $JCid != $old_JCid ) {
$old_JCid = $JCid;
- $span = Query_value("SELECT COUNT(*) FROM tmp_Result WHERE JCid=$JCid");
+ $span = Query_value("SELECT COUNT(*) FROM tmp_Result_app_2 WHERE JCid=$JCid");
print "<td rowspan='$span'><a href='java_class.php?cmd=display&JCid=$JCid'>".htmlspecialchars($row['JCname'])."</a></td>\n";
}
=== modified file 'app_stats.inc'
--- a/app_stats.inc 2012-04-18 08:11:35 +0000
+++ b/app_stats.inc 2012-07-31 19:35:07 +0000
@@ -265,7 +265,7 @@
$Name = form_app_name($row);
$Aarch = $row['Aarch'];
- $createResultTable = "CREATE TEMPORARY TABLE tmp_Result
+ $createResultTable = "CREATE TEMPORARY TABLE tmp_Result_app_stats_1
(KEY `RIlibrary` (`RIlibrary`,`RIname`), KEY `RIname` (`RIname`))
SELECT DISTINCT RIname, RIunmangled, RIversion, RIlibrary
FROM cache_AppRIntLib
@@ -277,7 +277,7 @@
)";
Query($createResultTable);
- $select = "SELECT * FROM tmp_Result
+ $select = "SELECT * FROM tmp_Result_app_stats_1
WHERE RIname > ''
ORDER BY RIlibrary,RIname ";
@@ -306,7 +306,7 @@
print( "<tr>" );
if( $oldlib != $row['RIlibrary'] ) {
- $selectLibInts = "SELECT COUNT(*) FROM tmp_Result WHERE RIlibrary='".$row['RIlibrary']."'";
+ $selectLibInts = "SELECT COUNT(*) FROM tmp_Result_app_stats_1 WHERE RIlibrary='".$row['RIlibrary']."'";
$lib_cnt = Query_value($selectLibInts);
print( "<th class='left' rowspan='".$lib_cnt."'>" );
$libLinkName = rawurlencode($row['RIlibrary']);
@@ -420,7 +420,7 @@
$Name = form_app_name($row);
$Aarch = $row['Aarch'];
- $createResultTable = "CREATE TEMPORARY TABLE tmp_Result
+ $createResultTable = "CREATE TEMPORARY TABLE tmp_Result_app_stats_2
(KEY `k_RILMlanguage`(`RILMlanguage`,`RILMname`))
SELECT RILMid, RILMlanguage, RILMname
FROM AppRILM
@@ -433,7 +433,7 @@
)";
Query($createResultTable);
- $select = "SELECT * FROM tmp_Result ORDER BY RILMlanguage, RILMname ";
+ $select = "SELECT * FROM tmp_Result_app_stats_2 ORDER BY RILMlanguage, RILMname ";
$res = Query($select);
$entry = entry(mysqli_num_rows($res));
@@ -723,7 +723,7 @@
return;
}
- $select = "CREATE TEMPORARY TABLE tmp_Result
+ $select = "CREATE TEMPORARY TABLE tmp_Result_app_stats_3
(KEY `app_needed_cnt` (`app_needed_cnt`), KEY `Lid` (`Lid`), KEY `ALrunname` (`ALrunname`))
SELECT COUNT(DISTINCT Aid) AS app_needed_cnt, ArchLib.ALrunname, Lid FROM tmp_Library
LEFT JOIN ArchLib ON ArchLib.ALlid=Lid AND ArchLib.ALaid=tmp_Library.ALaid
@@ -740,9 +740,9 @@
SELECT DISTINCT Lid, LibName, ALrunname FROM tmp_Library ";
Query($createUniqTmpLib);
- $selectReal = "SELECT COUNT(DISTINCT cache_AppLibUsage.Aid) AS app_cnt, tmp_Result.app_needed_cnt,
- tmp_Result.ALrunname, tmp_LibraryUniq.Lid FROM tmp_LibraryUniq
- LEFT JOIN tmp_Result USING(Lid)
+ $selectReal = "SELECT COUNT(DISTINCT cache_AppLibUsage.Aid) AS app_cnt, tmp_Result_app_stats_3.app_needed_cnt,
+ tmp_Result_app_stats_3.ALrunname, tmp_LibraryUniq.Lid FROM tmp_LibraryUniq
+ LEFT JOIN tmp_Result_app_stats_3 USING(Lid)
LEFT JOIN cache_AppLibUsage ON tmp_LibraryUniq.ALrunname=cache_AppLibUsage.ALrunname
JOIN tmp_App USING(Aid) ";
if( $archfilter and $archfilter != 'None' ) {
@@ -915,7 +915,7 @@
SELECT DISTINCT Lid, LibName FROM tmp_Library ";
Query($createUniqTmpLib);
- $createResult = "CREATE TEMPORARY TABLE tmp_Result
+ $createResult = "CREATE TEMPORARY TABLE tmp_Result_app_stats_4
(KEY `RIlibrary` (`RIlibrary`,`app_cnt`), KEY `app_cnt` (`app_cnt`))
SELECT COUNT(DISTINCT tmp_App.Aid) AS app_cnt, RLname AS RIlibrary FROM cache_AppLibUsage
JOIN tmp_App USING(Aid)
@@ -933,7 +933,7 @@
$createResult.= "GROUP BY RLname ";
Query( $createResult );
- $total = Query_value("SELECT COUNT(*) FROM tmp_Result");
+ $total = Query_value("SELECT COUNT(*) FROM tmp_Result_app_stats_4");
print( "<h2>Libraries not Included in $standard but Used by Applications</h2>\n" );
print( "<em>Libraries are ranged by the number of applications they are used by.</em><p/>\n" );
@@ -945,7 +945,7 @@
print_pages($total,$offset,$link,500);
}
- $select = "SELECT tmp_Result.*, COUNT(DISTINCT ALaid) AS app_needed_cnt FROM tmp_Result
+ $select = "SELECT tmp_Result_app_stats_4.*, COUNT(DISTINCT ALaid) AS app_needed_cnt FROM tmp_Result_app_stats_4
LEFT JOIN cache_AppLibName ON RIlibrary=RLname
JOIN tmp_App ON tmp_App.Aid=ALaid
GROUP BY RIlibrary
@@ -1019,7 +1019,7 @@
Query( $createResult );
}
- $createResult = "CREATE TEMPORARY TABLE tmp_Result
+ $createResult = "CREATE TEMPORARY TABLE tmp_Result_app_stats_5
SELECT ARIaid, RIname, RIlibrary, RIunmangled, RLibRIntId FROM tmp_App A1
JOIN cache_AppRIntLib ON Aid=ARIaid ";
if( !$rejected_ints_filter ) {
@@ -1038,12 +1038,12 @@
Query( $createResult );
- $total = Query_value("SELECT COUNT(DISTINCT RLibRIntId) FROM tmp_Result");
+ $total = Query_value("SELECT COUNT(DISTINCT RLibRIntId) FROM tmp_Result_app_stats_5");
if($total > 500) {
print_pages($total,$offset,$link,500);
}
- $select = "SELECT COUNT(DISTINCT ARIaid) AS app_cnt, RIname, RIlibrary, RIunmangled FROM tmp_Result
+ $select = "SELECT COUNT(DISTINCT ARIaid) AS app_cnt, RIname, RIlibrary, RIunmangled FROM tmp_Result_app_stats_5
GROUP BY RLibRIntId
ORDER BY app_cnt DESC, RIname ";
if($total > 500) {
@@ -1406,7 +1406,7 @@
{
global $Architecture;
- $createResult = "CREATE TEMPORARY TABLE tmp_Result
+ $createResult = "CREATE TEMPORARY TABLE tmp_Result_app_stats_6
(KEY `Aname`(`Aname`))
SELECT Aname, Aversion, tmp_App.Aarch FROM AppInterpreter
JOIN tmp_App ON tmp_App.Aid=AIaid
@@ -1414,7 +1414,7 @@
WHERE AIinterpreter = '$interpreter'";
$res = Query($createResult);
- $select = "SELECT * FROM tmp_Result ORDER BY Aname";
+ $select = "SELECT * FROM tmp_Result_app_stats_6 ORDER BY Aname";
$res = Query($select);
$num = mysqli_num_rows($res);
@@ -1434,7 +1434,7 @@
while( $row = mysqli_fetch_array($res) ) {
print "<tr>";
if( $prevName != $row['Aname'] ) {
- $selectVersions = "SELECT COUNT(*) FROM tmp_Result WHERE Aname='".$row['Aname']."'";
+ $selectVersions = "SELECT COUNT(*) FROM tmp_Result_app_stats_6 WHERE Aname='".$row['Aname']."'";
$span = Query_value($selectVersions);
print "<th rowspan='$span' class='left'><a href=\"app.php?cmd=display-by-name&Aname=".rawurldecode($row['Aname'])."\">".$row['Aname']."</a></th>\n";
$prevName = $row['Aname'];
=== modified file 'class_single.inc'
--- a/class_single.inc 2012-06-20 14:35:50 +0000
+++ b/class_single.inc 2012-07-31 19:35:07 +0000
@@ -633,7 +633,7 @@
{
global $Architecture;
- $create = "CREATE TEMPORARY TABLE tmp_Result
+ $create = "CREATE TEMPORARY TABLE tmp_Result_class_single
(KEY `Aid`(`Aid`), KEY `Aname`(`Aname`))
SELECT ARIaid AS Aid, Aname, cache_AppRIntLib.Aarch, Aversion, COUNT(RawInterface.RIid) AS int_cnt FROM tmp_App
LEFT JOIN cache_AppRIntLib ON ARIaid=Aid
@@ -644,10 +644,10 @@
GROUP BY Aid";
Query($create);
- $select = "SELECT * FROM tmp_Result ORDER BY Aname";
+ $select = "SELECT * FROM tmp_Result_class_single ORDER BY Aname";
$res = Query($select);
- $selectCnt = "SELECT COUNT(DISTINCT Aid) AS rec_cnt, COUNT(DISTINCT Aname) AS names_cnt FROM tmp_Result";
+ $selectCnt = "SELECT COUNT(DISTINCT Aid) AS rec_cnt, COUNT(DISTINCT Aname) AS names_cnt FROM tmp_Result_class_single";
$resCnt = Query($selectCnt);
$rowCnt = mysqli_fetch_array($resCnt);
$num_recs = $rowCnt['rec_cnt'];
@@ -672,7 +672,7 @@
print "<tr>";
$newName = $row['Aname'];
if( $newName != $oldName ) {
- $selectCnt = "SELECT COUNT(*) FROM tmp_Result WHERE Aname='$newName'";
+ $selectCnt = "SELECT COUNT(*) FROM tmp_Result_class_single WHERE Aname='$newName'";
$app_cnt = Query_value($selectCnt);
print( "<td rowspan='".$app_cnt."'><a href=\"app.php?cmd=display-by-name&Aname=".rawurldecode($newName)."\">".$newName."</a></td>\n" );
$oldName = $newName;
=== modified file 'coverage/cmd_cov.inc'
--- a/coverage/cmd_cov.inc 2010-04-05 12:18:33 +0000
+++ b/coverage/cmd_cov.inc 2012-07-31 19:35:07 +0000
@@ -36,7 +36,7 @@
print "<h2>Commands Covered by '$TSname $TSversion' Test Suite</h2>\n";
- $createResult = "CREATE TEMPORARY TABLE tmp_Result
+ $createResult = "CREATE TEMPORARY TABLE tmp_Result_cmd_cov_1
(KEY `k_SMid` (`SMid`))
SELECT SMid, SMname, Cname FROM TestCmd
JOIN Command ON Cid=TSCcmd
@@ -45,7 +45,7 @@
WHERE TSCtest=$TSid";
Query($createResult);
- $select = "SELECT * FROM tmp_Result ORDER BY SMname,Cname";
+ $select = "SELECT * FROM tmp_Result_cmd_cov_1 ORDER BY SMname,Cname";
$res = Query($select);
if( mysqli_num_rows($res) ) {
@@ -56,7 +56,7 @@
print "<tr>";
if( $row['SMid'] != $old_sm ) {
$old_sm = $row['SMid'];
- $span = Query_value("SELECT COUNT(*) FROM tmp_Result WHERE SMid=".$row['SMid']);
+ $span = Query_value("SELECT COUNT(*) FROM tmp_Result_cmd_cov_1 WHERE SMid=".$row['SMid']);
print "<td rowspan='$span'>".$row['SMname']."</td>\n";
}
print "<td><a href='../browse/cmd_single.php?cmd=list-by-name&Cname=".$row['Cname']."'>".$row['Cname']."</a></td>\n";
@@ -74,7 +74,7 @@
{
global $lsbversion;
- $create = "CREATE TEMPORARY TABLE tmp_Result
+ $create = "CREATE TEMPORARY TABLE tmp_Result_cmd_cov_2
(KEY k_cnt(test_cnt), KEY k_SMmandat(SMmandatorysince))
SELECT Cid, Cname, Cdocumented, COUNT(TSCtest) AS test_cnt, SMmandatorysince FROM tmp_Command
JOIN Command USING(Cid)
@@ -88,14 +88,14 @@
GROUP BY Cid";
Query($create);
- $total_cmds = Query_value("SELECT COUNT(*) FROM tmp_Result");
- $total_trial = Query_value("SELECT COUNT(*) FROM tmp_Result WHERE SMmandatorysince = '' OR SMmandatorysince > '$lsbversion'");
- $tested_cmds = Query_value("SELECT COUNT(*) FROM tmp_Result WHERE test_cnt > 0");
- $tested_trial = Query_value("SELECT COUNT(*) FROM tmp_Result WHERE test_cnt > 0 AND (SMmandatorysince = '' OR SMmandatorysince > '$lsbversion')");
+ $total_cmds = Query_value("SELECT COUNT(*) FROM tmp_Result_cmd_cov_2");
+ $total_trial = Query_value("SELECT COUNT(*) FROM tmp_Result_cmd_cov_2 WHERE SMmandatorysince = '' OR SMmandatorysince > '$lsbversion'");
+ $tested_cmds = Query_value("SELECT COUNT(*) FROM tmp_Result_cmd_cov_2 WHERE test_cnt > 0");
+ $tested_trial = Query_value("SELECT COUNT(*) FROM tmp_Result_cmd_cov_2 WHERE test_cnt > 0 AND (SMmandatorysince = '' OR SMmandatorysince > '$lsbversion')");
print "<strong>Total commands:</strong> $total_cmds ($total_trial trial)<br/>";
print "<strong>Tested commands:</strong> $tested_cmds ($tested_trial trial)<br/>";
- $select = "SELECT * FROM tmp_Result ORDER BY Cname";
+ $select = "SELECT * FROM tmp_Result_cmd_cov_2 ORDER BY Cname";
$res = Query($select);
if( mysqli_num_rows($res) ) {
=== modified file 'coverage/coverage.inc'
--- a/coverage/coverage.inc 2011-08-29 07:50:40 +0000
+++ b/coverage/coverage.inc 2012-07-31 19:35:07 +0000
@@ -28,14 +28,14 @@
$prevSMname = "";
- $createResult = "CREATE TEMPORARY TABLE tmp_Result
+ $createResult = "CREATE TEMPORARY TABLE tmp_Result_coverage_1
(KEY `SMname`(`SMname`,`Lid`))
SELECT DISTINCT SMid,SMname,Lid FROM SubModule
LEFT JOIN SModLib ON SMLsmid=SMid
LEFT JOIN tmp_NonThunk_Interface ON SMLlid=Lid ";
Query($createResult);
- $select = "SELECT * FROM tmp_Result ORDER BY SMname ";
+ $select = "SELECT * FROM tmp_Result_coverage_1 ORDER BY SMname ";
$resMod = Query($select);
$total['all'] = 0;
@@ -119,7 +119,7 @@
$prevMid = $rowMod['SMid'];
- $select = "SELECT COUNT(DISTINCT Lid) FROM tmp_Result
+ $select = "SELECT COUNT(DISTINCT Lid) FROM tmp_Result_coverage_1
WHERE SMname = '".$rowMod['SMname']."'";
$span = Query_value($select);
@@ -952,7 +952,7 @@
*/
function display_int_by_testsuite($TSid, $quality, $offset=1)
{
- $create = "CREATE TEMPORARY TABLE tmp_Result
+ $create = "CREATE TEMPORARY TABLE tmp_Result_coverage_2
(KEY k_Lid(Iid,Lid))
SELECT SQL_CALC_FOUND_ROWS Lid, Ilibrary, Interface.Iid, Iname, TCStsid, COUNT(TCSid) AS TCnum FROM tmp_TestInt
JOIN TestCaseSource ON TSItest=TCSid
@@ -973,7 +973,7 @@
print_pages($num,$offset,$link,500);
}
- $select = "SELECT * FROM tmp_Result ORDER BY Ilibrary, Iname";
+ $select = "SELECT * FROM tmp_Result_coverage_2 ORDER BY Ilibrary, Iname";
$res = Query($select);
if( mysqli_num_rows($res) ) {
=== modified file 'header.inc'
--- a/header.inc 2012-04-18 08:11:35 +0000
+++ b/header.inc 2012-07-31 19:35:07 +0000
@@ -297,7 +297,7 @@
{
global $tmpInterface;
- $create = "CREATE TEMPORARY TABLE tmp_Result
+ $create = "CREATE TEMPORARY TABLE tmp_Result_header
(KEY `k_Lid`(`Lid`))
SELECT Header.Hid,Hname,Lname, Header.Hlib AS Lid FROM tmp_Header
LEFT JOIN Header USING(Hid)
@@ -305,7 +305,7 @@
ORDER BY Lname,Hname
LIMIT ".($offset-1).", 500";
Query($create);
- $res = Query("SELECT * FROM tmp_Result ORDER BY Lname,Hname");
+ $res = Query("SELECT * FROM tmp_Result_header ORDER BY Lname,Hname");
$num = Query_value("SELECT COUNT(*) FROM tmp_Header");
$entry = entry($num);
@@ -328,7 +328,7 @@
if( !$row['Lid'] ) {
$row['Lid'] = 0;
}
- $selectHeaders = "SELECT COUNT(Hid) FROM tmp_Result WHERE Lid=".$row['Lid'];
+ $selectHeaders = "SELECT COUNT(Hid) FROM tmp_Result_header WHERE Lid=".$row['Lid'];
$span = Query_value($selectHeaders);
print( "<th class='left' rowspan='".$span."'><a href=\"lib_single.php?cmd=display&Lid=".$row['Lid']."\">".$row['Lname']."</a></th>\n" );
$oldlib = $row['Lname'];
=== modified file 'headgroup.inc'
--- a/headgroup.inc 2012-04-18 08:11:35 +0000
+++ b/headgroup.inc 2012-07-31 19:35:07 +0000
@@ -113,14 +113,14 @@
//
// Create a list of all HeadGroups, so the user can choose one
//
- $create = "CREATE TEMPORARY TABLE tmp_Result
+ $create = "CREATE TEMPORARY TABLE tmp_Result_headgroup
(KEY `k_HGheader`(`HGheader`))
SELECT Hid,Hname,HeaderGroup.* FROM HeaderGroup
JOIN Header ON Hid=HGheader
ORDER BY Hname,HGorder
LIMIT ".($offset-1).", 500";
Query($create);
- $res = Query("SELECT * FROM tmp_Result ORDER BY Hname,HGorder");
+ $res = Query("SELECT * FROM tmp_Result_headgroup ORDER BY Hname,HGorder");
$num = Query_value("SELECT COUNT(*) FROM HeaderGroup");
if( $num > 500 ) {
@@ -133,7 +133,7 @@
$lastheader=-1;
while( $row=mysqli_fetch_array($res)) {
if($row["Hid"] != $lastheader ) {
- $selectCount = "SELECT COUNT(*) FROM tmp_Result
+ $selectCount = "SELECT COUNT(*) FROM tmp_Result_headgroup
WHERE HGheader=".$row['Hid'];
$span = Query_value($selectCount);
=== modified file 'int_single.inc'
--- a/int_single.inc 2012-05-29 09:13:19 +0000
+++ b/int_single.inc 2012-07-31 19:35:07 +0000
@@ -947,7 +947,7 @@
print_app_category_filters();
- $createRsult = "CREATE TEMPORARY TABLE tmp_Result
+ $createRsult = "CREATE TEMPORARY TABLE tmp_Result_int_single
(KEY `AppName`(`AppName`))
SELECT DISTINCT Application.Aname AS AppName,Aversion,RIversion,Application.Aarch,AIsummary,tmp_App.Aid FROM tmp_App
LEFT JOIN Application USING(Aid)
@@ -960,7 +960,7 @@
}
Query($createRsult);
- $select = "SELECT * FROM tmp_Result
+ $select = "SELECT * FROM tmp_Result_int_single
ORDER BY AppName, Aversion, Aarch";
$res=Query($select);
@@ -973,7 +973,7 @@
$span = 0;
if( $row['AppName'] != $old_name ) {
$old_name = $row['AppName'];
- $selectCnt = "SELECT COUNT(*) FROM tmp_Result WHERE AppName='$old_name'";
+ $selectCnt = "SELECT COUNT(*) FROM tmp_Result_int_single WHERE AppName='$old_name'";
$span = Query_value($selectCnt);
}
display_int_appinfo_entry($row,$span);
=== modified file 'interface.inc'
--- a/interface.inc 2012-05-17 02:06:14 +0000
+++ b/interface.inc 2012-07-31 19:35:07 +0000
@@ -630,7 +630,7 @@
$link="interface.php?cmd=list-bystd-full&Sid=$Sid";
- $select = "CREATE TEMPORARY TABLE tmp_Result
+ $select = "CREATE TEMPORARY TABLE tmp_Result_interface_1
(SELECT Interface.*, ArchInt.*, LGIlibg AS LGid, ISstatus, ISstatustext, Lid
FROM $tmpInterface
JOIN Interface USING(Iid)
@@ -650,14 +650,14 @@
$select.= ")";
$res = Query($select);
- $select_num = "SELECT COUNT(DISTINCT Iid, AIarch, ISstatus) FROM tmp_Result";
+ $select_num = "SELECT COUNT(DISTINCT Iid, AIarch, ISstatus) FROM tmp_Result_interface_1";
$num = Query_value($select_num);
$entry = entry($num);
- $select_distinct_ints = "SELECT COUNT(DISTINCT Iid) FROM tmp_Result";
+ $select_distinct_ints = "SELECT COUNT(DISTINCT Iid) FROM tmp_Result_interface_1";
$distinct_num = Query_value($select_distinct_ints);
- $select = "SELECT * FROM tmp_Result
+ $select = "SELECT * FROM tmp_Result_interface_1
GROUP BY Iid, AIarch, ISstatus
ORDER BY Iname, AIarch, ISstatus ";
if( $num > $on_page ) {
@@ -860,7 +860,7 @@
$link="interface.php?cmd=display-bylibgroup&LGid=$LGid";
- $select = "CREATE TEMPORARY TABLE tmp_Result
+ $select = "CREATE TEMPORARY TABLE tmp_Result_interface_2
(SELECT Interface.*, IntStd.*, $tmpInterface.LGIlibg AS LGid, ArchInt.*, ISstatus, ISstatustext
FROM $tmpInterface
JOIN Interface USING(Iid)
@@ -875,10 +875,10 @@
)";
$res = Query($select);
- $num = Query_value( "SELECT COUNT(*) FROM tmp_Result" );
+ $num = Query_value( "SELECT COUNT(*) FROM tmp_Result_interface_2" );
$entry = entry($num);
- $select = "SELECT * FROM tmp_Result ORDER BY Iname ";
+ $select = "SELECT * FROM tmp_Result_interface_2 ORDER BY Iname ";
if( $num > $on_page ) {
$select.= " LIMIT ".($offset-1).",$on_page";
}
=== modified file 'intlang.inc'
--- a/intlang.inc 2012-04-18 08:11:35 +0000
+++ b/intlang.inc 2012-07-31 19:35:07 +0000
@@ -490,14 +490,14 @@
print "<h2>Usage in Applications</h2>\n";
$RILMid = $row['RILMid'];
- $createResult = "CREATE TEMPORARY TABLE tmp_Result (KEY `Aname`(`Aname`))
+ $createResult = "CREATE TEMPORARY TABLE tmp_Result_intlang (KEY `Aname`(`Aname`))
SELECT * FROM AppRILM
LEFT JOIN Application ON Aid=ARMaid
LEFT JOIN AppInfo ON AIname=Aname
WHERE ARMrilmid=$RILMid";
Query($createResult);
- $select = "SELECT * FROM tmp_Result ORDER BY Aname";
+ $select = "SELECT * FROM tmp_Result_intlang ORDER BY Aname";
$res = Query($select);
print "<table class='wikitable'>\n";
@@ -508,7 +508,7 @@
$span = 0;
if( $oldAppName != $row['Aname'] ) {
$oldAppName = $row['Aname'];
- $selectCnt = "SELECT COUNT(*) FROM tmp_Result WHERE Aname='$oldAppName'";
+ $selectCnt = "SELECT COUNT(*) FROM tmp_Result_intlang WHERE Aname='$oldAppName'";
$span = Query_value($selectCnt);
}
display_rilm_appinfo_entry($row, $span);
=== modified file 'java_class.inc'
--- a/java_class.inc 2010-10-26 13:31:43 +0000
+++ b/java_class.inc 2012-07-31 19:35:07 +0000
@@ -110,7 +110,7 @@
print_app_category_filters();
- $create = "CREATE TEMPORARY TABLE tmp_Result
+ $create = "CREATE TEMPORARY TABLE tmp_Result_java_class
(KEY Aname(Aname))
SELECT Aid, Aname, Application.Aarch, Aversion, AIsummary, COUNT(DISTINCT AJIjiid) AS int_cnt FROM JavaClass
JOIN JavaInterface ON JIjcid=JCid
@@ -122,7 +122,7 @@
GROUP BY Aid";
Query($create);
- $res = Query("SELECT * FROM tmp_Result ORDER BY Aname, Aversion, Aarch");
+ $res = Query("SELECT * FROM tmp_Result_java_class ORDER BY Aname, Aversion, Aarch");
if( !mysqli_num_rows($res) ) {
print "There are no applications registered in the database that use members of this class.\n<br/>";
@@ -137,7 +137,7 @@
$Aname = $row['Aname'];
$span = 0;
if( $Aname != $oldAppName ) {
- $span = Query_value("SELECT COUNT(*) FROM tmp_Result WHERE Aname='$Aname'");
+ $span = Query_value("SELECT COUNT(*) FROM tmp_Result_java_class WHERE Aname='$Aname'");
$oldAppName = $Aname;
}
print_jclass_appinfo_entry($row,$span,$JCname);
=== modified file 'java_int.inc'
--- a/java_int.inc 2010-10-26 13:31:43 +0000
+++ b/java_int.inc 2012-07-31 19:35:07 +0000
@@ -258,7 +258,7 @@
print_app_category_filters();
- $create = "CREATE TEMPORARY TABLE tmp_Result
+ $create = "CREATE TEMPORARY TABLE tmp_Result_java_int
(KEY Aname(Aname))
SELECT DISTINCT Aid, Aname, Aversion, Application.Aarch, AIsummary FROM tmp_App
JOIN Application USING(Aid)
@@ -266,7 +266,7 @@
LEFT JOIN AppInfo ON AIname=Aname";
Query($create);
- $res = Query("SELECT * FROM tmp_Result ORDER BY Aname, Aversion, Aarch");
+ $res = Query("SELECT * FROM tmp_Result_java_int ORDER BY Aname, Aversion, Aarch");
if( !mysqli_num_rows($res) ) {
print "There are no applications registered in the database that use this ".strtolower($kind).".\n<br/>";
return;
@@ -280,7 +280,7 @@
$span = 0;
$Aname = $row['Aname'];
if( $oldAppName != $Aname ) {
- $span = Query_value("SELECT COUNT(*) FROM tmp_Result WHERE Aname='$Aname'");
+ $span = Query_value("SELECT COUNT(*) FROM tmp_Result_java_int WHERE Aname='$Aname'");
$oldAppName = $Aname;
}
display_jint_appinfo_entry($row,$span);
=== modified file 'lib_single.inc'
--- a/lib_single.inc 2012-07-16 11:11:35 +0000
+++ b/lib_single.inc 2012-07-31 19:35:07 +0000
@@ -554,7 +554,7 @@
}
}
- $create = "CREATE TEMPORARY TABLE tmp_Result
+ $create = "CREATE TEMPORARY TABLE tmp_Result_lib_single_1
(KEY `Aid`(`Aid`), KEY `Aname`(`Aname`))
SELECT ARIaid AS Aid, Aname, cache_AppRIntLib.Aarch, Aversion, COUNT(RIid) AS int_cnt FROM tmp_App
LEFT JOIN cache_AppRIntLib ON Aid=ARIaid
@@ -562,7 +562,7 @@
GROUP BY ARIaid ";
Query($create);
- $selectCnt = "SELECT COUNT(DISTINCT Aid) AS rec_cnt, COUNT(DISTINCT Aname) AS names_cnt FROM tmp_Result";
+ $selectCnt = "SELECT COUNT(DISTINCT Aid) AS rec_cnt, COUNT(DISTINCT Aname) AS names_cnt FROM tmp_Result_lib_single_1";
$resCnt = Query($selectCnt);
$rowCnt = mysqli_fetch_array($resCnt);
$num_recs = $rowCnt['rec_cnt'];
@@ -570,7 +570,7 @@
$entry = entry($num_recs);
$app = $num_names == 1 ? "applications" : "application";
- $select = "SELECT * FROM tmp_Result
+ $select = "SELECT * FROM tmp_Result_lib_single_1
ORDER BY Aname, Aarch ";
$res = Query($select);
@@ -589,7 +589,7 @@
print "<tr>";
$newName = $row['Aname'];
if( $newName != $oldName ) {
- $selectCnt = "SELECT COUNT(*) FROM tmp_Result WHERE Aname='$newName'";
+ $selectCnt = "SELECT COUNT(*) FROM tmp_Result_lib_single_1 WHERE Aname='$newName'";
$numCnt = Query_value($selectCnt);
print( "<td rowspan='".$numCnt."'><a href=\"app.php?cmd=display-by-name&Aname=".rawurldecode($row['Aname'])."\">".$row['Aname']."</a></td>\n" );
$oldName = $newName;
@@ -620,7 +620,7 @@
Query($create);
}
- $create = "CREATE TEMPORARY TABLE tmp_Result
+ $create = "CREATE TEMPORARY TABLE tmp_Result_lib_single_2
(KEY `Aid`(`Aid`), KEY `Aname`(`Aname`))
SELECT DISTINCT Application.*,ALrunname FROM tmp_App
LEFT JOIN AppLib ON tmp_App.Aid=ALaid
@@ -634,7 +634,7 @@
Query($create);
- $selectCnt = "SELECT COUNT(DISTINCT Aid) AS rec_cnt, COUNT(DISTINCT Aname) AS names_cnt FROM tmp_Result";
+ $selectCnt = "SELECT COUNT(DISTINCT Aid) AS rec_cnt, COUNT(DISTINCT Aname) AS names_cnt FROM tmp_Result_lib_single_2";
$resCnt = Query($selectCnt);
$rowCnt = mysqli_fetch_array($resCnt);
$num_recs = $rowCnt['rec_cnt'];
@@ -642,7 +642,7 @@
$entry = entry($num_recs);
$app = $num_names == 1 ? "applications" : "application";
- $select = "SELECT * FROM tmp_Result
+ $select = "SELECT * FROM tmp_Result_lib_single_2
ORDER BY Aname, Aarch ";
$res = Query($select);
@@ -667,7 +667,7 @@
print "<tr>";
$newName = $row['Aname'];
if( $newName != $oldName ) {
- $selectCnt = "SELECT COUNT(*) FROM tmp_Result WHERE Aname='$newName'";
+ $selectCnt = "SELECT COUNT(*) FROM tmp_Result_lib_single_2 WHERE Aname='$newName'";
$numCnt = Query_value($selectCnt);
print( "<td rowspan='".$numCnt."'><a href=\"app.php?cmd=list-by-id&Aid=".$row['Aid']."\">".$row['Aname']."</a></td>\n" );
$oldName = $newName;
@@ -698,7 +698,7 @@
WHERE RLname='$Lname'";
Query($create);
- $create = "CREATE TEMPORARY TABLE tmp_Result
+ $create = "CREATE TEMPORARY TABLE tmp_Result_lib_single_3
(KEY `Aid`(`Aid`), KEY `Aname`(`Aname`))
SELECT Application.Aid, Application.Aarch, Aname, Aversion, RLSsoname
FROM tmp_App
@@ -708,7 +708,7 @@
JOIN tmp_RLibSonames ON RLsoname=RLSsoname";
Query($create);
- $selectCnt = "SELECT COUNT(DISTINCT Aid) AS rec_cnt, COUNT(DISTINCT Aname) AS names_cnt FROM tmp_Result";
+ $selectCnt = "SELECT COUNT(DISTINCT Aid) AS rec_cnt, COUNT(DISTINCT Aname) AS names_cnt FROM tmp_Result_lib_single_3";
$resCnt = Query($selectCnt);
$rowCnt = mysqli_fetch_array($resCnt);
$num_recs = $rowCnt['rec_cnt'];
@@ -716,7 +716,7 @@
$entry = entry($num_recs);
$app = $num_names == 1 ? "applications" : "application";
- $select = "SELECT * FROM tmp_Result
+ $select = "SELECT * FROM tmp_Result_lib_single_3
ORDER BY Aname, Aarch ";
$res = Query($select);
@@ -735,7 +735,7 @@
print "<tr>";
$newName = $row['Aname'];
if( $newName != $oldName ) {
- $selectCnt = "SELECT COUNT(*) FROM tmp_Result WHERE Aname='$newName'";
+ $selectCnt = "SELECT COUNT(*) FROM tmp_Result_lib_single_3 WHERE Aname='$newName'";
$numCnt = Query_value($selectCnt);
print( "<td rowspan='".$numCnt."'><a href=\"app.php?cmd=display-by-name&Aname=".rawurldecode($row['Aname'])."\">".$row['Aname']."</a></td>\n" );
$oldName = $newName;
=== modified file 'libgroup.inc'
--- a/libgroup.inc 2012-04-18 08:11:35 +0000
+++ b/libgroup.inc 2012-07-31 19:35:07 +0000
@@ -102,7 +102,7 @@
// Let's assume that if a libgroup contains no interfaces,
// then it contains no classes,
// so we'll only check number interfaces
- $create = "CREATE TEMPORARY TABLE tmp_Result
+ $create = "CREATE TEMPORARY TABLE tmp_Result_libgroup
(KEY k_Lid(Lid))
SELECT LGid, LGname, tmp_Library.Lid, LibName AS Lname FROM tmp_Library
JOIN LibGroup ON LGlib=Lid
@@ -114,7 +114,7 @@
";
Query($create);
- $select = "SELECT * FROM tmp_Result ORDER BY Lname, LGname";
+ $select = "SELECT * FROM tmp_Result_libgroup ORDER BY Lname, LGname";
$res=Query($select);
if( $action != 'interface.php' and $action != 'app_stats.php') {
@@ -135,7 +135,7 @@
print("<tr>");
if( $row['Lname'] != $oldlib ) {
- $selectGroups = "SELECT COUNT(*) FROM tmp_Result WHERE Lid=".$row['Lid'];
+ $selectGroups = "SELECT COUNT(*) FROM tmp_Result_libgroup WHERE Lid=".$row['Lid'];
$span = Query_value($selectGroups);
$libLinkName = rawurlencode($row['Lname']);
print("<th class='left' rowspan='$span'><a href=\"lib_single.php?cmd=list-by-name&Lname=$libLinkName\">".$row['Lname']."</a></th>");
=== modified file 'module.inc'
--- a/module.inc 2012-07-16 11:11:35 +0000
+++ b/module.inc 2012-07-31 19:35:07 +0000
@@ -109,7 +109,7 @@
{
global $lsbversion;
- $createResult = "CREATE TEMPORARY TABLE tmp_Result (KEY `name`(`Mname`,`SMname`), KEY `Mid`(`Mid`))
+ $createResult = "CREATE TEMPORARY TABLE tmp_Result_module (KEY `name`(`Mname`,`SMname`), KEY `Mid`(`Mid`))
SELECT DISTINCT Module.*,SubModule.*,ModSMod.* FROM tmp_SubModule
LEFT JOIN SubModule ON tmp_SubModule.SMid=SubModule.SMid
LEFT JOIN ModSMod ON MSMsmid=SubModule.SMid
@@ -120,7 +120,7 @@
}
$res=Query($createResult);
- $select = "SELECT * FROM tmp_Result
+ $select = "SELECT * FROM tmp_Result_module
ORDER BY Mname, SMname";
$res=Query($select);
@@ -132,7 +132,7 @@
$span = 0;
if( $old_Mid != $row['Mid'] ) {
$old_Mid = $row['Mid'];
- $selectCnt = "SELECT COUNT(*) FROM tmp_Result WHERE Mid=$old_Mid";
+ $selectCnt = "SELECT COUNT(*) FROM tmp_Result_module WHERE Mid=$old_Mid";
$span = Query_value($selectCnt);
}
$libQuery = "SELECT COUNT(DISTINCT Lid) FROM tmp_Library LEFT JOIN SModLib ON SMLlid=Lid WHERE SMLsmid=".$row["SMid"]." ";
=== modified file 'presence.inc'
--- a/presence.inc 2012-03-15 06:30:04 +0000
+++ b/presence.inc 2012-07-31 19:35:07 +0000
@@ -37,7 +37,7 @@
$total = Query_value($selectNum);
print "Total distributions: $total";
- $createResult = "CREATE TEMPORARY TABLE tmp_Result (
+ $createResult = "CREATE TEMPORARY TABLE tmp_Result_presence_1 (
ALsoname VARCHAR(750) NOT NULL DEFAULT '',
ALlibname VARCHAR(200) NOT NULL DEFAULT '',
distr_cnt INT(10) UNSIGNED NOT NULL DEFAULT 0,
@@ -46,7 +46,7 @@
Query("CALL count_libs_presence()");
- $select = "SELECT ALsoname, ALlibname, distr_cnt FROM tmp_Result
+ $select = "SELECT ALsoname, ALlibname, distr_cnt FROM tmp_Result_presence_1
ORDER BY distr_cnt DESC, ALlibname, ALsoname";
$res = Query($select);
@@ -977,7 +977,7 @@
$missing_txt = $missing ? "Missing" : "Present";
print "<h1>Commands from the Approved List That Are $missing_txt in ".$row['Dname']." ".$row['Dversion']." ".$Architecture[$row['Darch']]." Distribution</h1>\n";
- $createResult = "CREATE TEMPORARY TABLE tmp_Result
+ $createResult = "CREATE TEMPORARY TABLE tmp_Result_presence_2
(KEY `k_ACname`(`ACname`))
SELECT DISTINCT ACname FROM cache_Component
JOIN RawCommand ON RCcomponent=Cid
@@ -998,12 +998,12 @@
if( $missing ) {
$select = "SELECT ACname FROM ApprovedCommand
WHERE ACname NOT IN (
- SELECT ACname FROM tmp_Result
+ SELECT ACname FROM tmp_Result_presence_2
)
ORDER BY ACname";
}
else {
- $select = "SELECT ACname FROM tmp_Result ORDER BY ACname";
+ $select = "SELECT ACname FROM tmp_Result_presence_2 ORDER BY ACname";
}
$res = Query($select);
@@ -1029,7 +1029,7 @@
$missing_txt = $missing ? "Missing" : "Present";
print "<h1>Libraries from the Approved List That Are $missing_txt in ".$row['Dname']." ".$row['Dversion']." ".$Architecture[$row['Darch']]." Distribution</h1>\n";
- $createResult = "CREATE TEMPORARY TABLE tmp_Result
+ $createResult = "CREATE TEMPORARY TABLE tmp_Result_presence_3
(KEY `k_ALlibname`(`ALlibname`))
SELECT DISTINCT ALlibname, RLsoname AS ALsoname FROM cache_Component
JOIN RawLibrary ON RLcomponent=Cid
@@ -1046,13 +1046,13 @@
if( $missing ) {
$select = "SELECT ALlibname, ALsoname FROM ApprovedLibrary
WHERE NOT EXISTS (
- SELECT 1 FROM tmp_Result
- WHERE tmp_Result.ALlibname = ApprovedLibrary.ALlibname
+ SELECT 1 FROM tmp_Result_presence_3
+ WHERE tmp_Result_presence_3.ALlibname = ApprovedLibrary.ALlibname
)
ORDER BY ALlibname, ALsoname";
}
else {
- $select = "SELECT ALlibname, ALsoname FROM tmp_Result ORDER BY ALlibname, ALsoname";
+ $select = "SELECT ALlibname, ALsoname FROM tmp_Result_presence_3 ORDER BY ALlibname, ALsoname";
}
$res = Query($select);
@@ -1072,7 +1072,7 @@
$span = Query_value("SELECT COUNT(*) FROM ApprovedLibrary WHERE ALlibname='".$prev_lib."'");
}
else {
- $span = Query_value("SELECT COUNT(*) FROM tmp_Result WHERE ALlibname='".$prev_lib."'");
+ $span = Query_value("SELECT COUNT(*) FROM tmp_Result_presence_3 WHERE ALlibname='".$prev_lib."'");
}
print "<td rowspan='$span'><a href='../browse/library.php?cmd=display&AdminMode=admin&Lname=".rawurlencode($row['ALlibname'])."'>".$row['ALlibname']."</a></td>\n";
}
=== modified file 'rawint.inc'
--- a/rawint.inc 2012-04-18 08:11:35 +0000
+++ b/rawint.inc 2012-07-31 19:35:07 +0000
@@ -374,7 +374,7 @@
$Cid = $Calias;
}
- $create = "CREATE TEMPORARY TABLE tmp_Result
+ $create = "CREATE TEMPORARY TABLE tmp_Result_rawint_1
(KEY k_RLname(RIlibrary,RIname))
SELECT RLid, RawInterface.*
FROM RawLibrary
@@ -384,7 +384,7 @@
LIMIT ".($offset-1).", $on_page ";
Query($create);
- $select = "SELECT * FROM tmp_Result ORDER BY RIlibrary,RIname";
+ $select = "SELECT * FROM tmp_Result_rawint_1 ORDER BY RIlibrary,RIname";
$res = Query($select);
if($total > $on_page) {
@@ -399,7 +399,7 @@
while($row=mysqli_fetch_array($res)) {
if( $oldLib != $row['RIlibrary'] ) {
$oldLib = $row['RIlibrary'];
- $span = Query_value("SELECT COUNT(*) FROM tmp_Result WHERE RIlibrary='$oldLib'");
+ $span = Query_value("SELECT COUNT(*) FROM tmp_Result_rawint_1 WHERE RIlibrary='$oldLib'");
}
else {
$span = 0;
@@ -665,7 +665,7 @@
$lib_field = $Lname ? "" : "Library";
print_table_header( $lib_field, 'Interface',' Version', "$standard Status", 'Comment' );
- $createResult = "CREATE TEMPORARY TABLE tmp_Result
+ $createResult = "CREATE TEMPORARY TABLE tmp_Result_rawint_2
(KEY `RIname` (`RIname`,`RIlibrary`), KEY `RIlibrary` (`RIlibrary`))
SELECT RIname,RIunmangled,RIversion,RIlibrary,Aarch FROM RawInterface
LEFT JOIN AppRInt ON ARIriid=RIid
@@ -686,7 +686,7 @@
}
Query($createResult);
- $select = "SELECT * FROM tmp_Result
+ $select = "SELECT * FROM tmp_Result_rawint_2
LEFT JOIN cache_IntStatus ON Iname=RIname AND Ilibrary=RIlibrary AND (AIarch=Aarch OR AIarch=1) AND AIversion=RIversion
ORDER BY RIlibrary,RIname";
$res=Query($select);
@@ -702,7 +702,7 @@
if( !$Lname ) {
if( $oldlib != $row['RIlibrary'] ) {
- $selectLibInts = "SELECT COUNT(RIname) FROM tmp_Result WHERE RIlibrary='".$row['RIlibrary']."'";
+ $selectLibInts = "SELECT COUNT(RIname) FROM tmp_Result_rawint_2 WHERE RIlibrary='".$row['RIlibrary']."'";
$num = Query_value($selectLibInts);
$libLinkName = rawurlencode($row['RIlibrary']);
print("<th class='left' rowspan='$num'><a href=\"lib_single.php?cmd=list-by-name&Lname=$libLinkName\">".$row['RIlibrary']."</a></th>");
More information about the lsb-messages
mailing list