Author: jfthomps
Date: Wed Oct  5 17:10:24 2011
New Revision: 1179325

URL: http://svn.apache.org/viewvc?rev=1179325&view=rev
Log:
VCL-473
query in findManagementNode in utils.php doesn't have conditional to join tables

utils.php: modified findManagementNode - added 'rs.requestid = rq.id' to where 
part of query

Modified:
    incubator/vcl/trunk/web/.ht-inc/utils.php

Modified: incubator/vcl/trunk/web/.ht-inc/utils.php
URL: 
http://svn.apache.org/viewvc/incubator/vcl/trunk/web/.ht-inc/utils.php?rev=1179325&r1=1179324&r2=1179325&view=diff
==============================================================================
--- incubator/vcl/trunk/web/.ht-inc/utils.php (original)
+++ incubator/vcl/trunk/web/.ht-inc/utils.php Wed Oct  5 17:10:24 2011
@@ -4594,6 +4594,7 @@ function findManagementNode($compid, $st
               . "FROM reservation rs, "
               .      "request rq "
               . "WHERE rs.managementnodeid IN ($inlist) AND "
+              .       "rs.requestid = rq.id AND "
               .       "rq.start > \"$start\" AND "
               .       "rq.start < \"$end\" "
               . "GROUP BY rs.managementnodeid "


Reply via email to