You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@vcl.apache.org by jf...@apache.org on 2011/10/05 19:10:24 UTC
svn commit: r1179325 - /incubator/vcl/trunk/web/.ht-inc/utils.php
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 "