Author: fapeeler
Date: Fri Feb 20 18:06:29 2009
New Revision: 746313
URL: http://svn.apache.org/viewvc?rev=746313&view=rev
Log:
VCL-99
change "which of those are loaded" query to determine loaded images modified to
only consider a image loaded if exists two or more times
Modified:
incubator/vcl/trunk/managementnode/lib/VCL/Module/Predictive/Level_1.pm
Modified:
incubator/vcl/trunk/managementnode/lib/VCL/Module/Predictive/Level_1.pm
URL:
http://svn.apache.org/viewvc/incubator/vcl/trunk/managementnode/lib/VCL/Module/Predictive/Level_1.pm?rev=746313&r1=746312&r2=746313&view=diff
==============================================================================
--- incubator/vcl/trunk/managementnode/lib/VCL/Module/Predictive/Level_1.pm
(original)
+++ incubator/vcl/trunk/managementnode/lib/VCL/Module/Predictive/Level_1.pm Fri
Feb 20 18:06:29 2009
@@ -308,12 +308,15 @@
$inlist = join(',', @imgids);
my $select_loaded = "
SELECT
- DISTINCT(currentimageid)
+ DISTINCT(currentimageid),
+ COUNT(currentimageid) AS count
FROM
computer
WHERE
currentimageid IN ($inlist)
- AND stateid = 2";
+ AND stateid = 2
+ GROUP BY currentimageid
+ HAVING count > 1";
@data = database_select($select_loaded);
my @loaded;
foreach (@data) {
